| Author |
Message |
BrianMultiLanguage
Guest
|
 Posted:
Thu Nov 10, 2005 9:50 pm Post subject:
can't move sharepoint by the instructions. |
|
|
Ok, we are back to it and it does not work.
On step 4, I input;
Osql -E -S CLISBS\SharePoint -Q “sp_detach_db 'STS_Config'”
and get this:
detach_db 'STS_Config'"
usage: osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-X[1] disable commands [and exit with warning]]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[-? show syntax summary] |
|
| Back to top |
|
 |
Jenny wu [MSFT]
Guest
|
| Posted:
Fri Nov 11, 2005 9:50 am Post subject:
RE: can't move sharepoint by the instructions. |
|
|
Hi Brian,
Thanks for posting here! I am Jenny, I have answered your question on
another thread. Please try to run the command as follows:
OSQL -E -S CLISBS\sharepoint <Enter>
| Quote: | sp_detach_db "STS_Config" <Enter
exit <Enter
|
How about the result?
For your convenience, I list the steps as blow, please strictly follow to
test:
I To stop the Internet Information Services (IIS) Web sites for Windows
SharePoint Services
To prevent users from accessing SharePoint sites while you are moving the
databases, stop the related IIS Web sites. If you have created additional
SharePoint sites, you should stop those Web sites as well.
II. To verify that the SharePoint instance of WMSDE is running
III. To connect to the SharePoint instance of WMSDE (MSDE) and detach
detach the WSS config and config databases (Replace "servername" with the
name of your server):
Before moving the SharePoint instance of WMSDE, you must connect to the
instance and detach the two databases used by the instance.
Bring up a command console, and then run:
OSQL -E -S servername\sharepoint <Enter>
| Quote: | sp_detach_db "STS_Config" <Enter
go <Enter
sp_detach_db "STS_servername_1" <Enter
go <Enter
|
*Note: Please replace servername of STS_servername_1 with the name of your
server!
IV. In Windows Explorer, move all the databases (*.mdf, *.ldf) to the new
location (such as D:\MSDEDatabases\Sharepoint). The original files should
be located under the folder ''C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data'' if you have not changed the default folder
location.
---STS_Servername_1.mdf
---STS_Servername_1_Log.ldf
---STS_Config.mdf
---STS_Config_Log.ldf
*Note:
1. Please replace servername of STS_servername_1 with the name of your
server!
2. At this time, please stop the MSSQL$SHAREPOINT service in services
console. After you copied those files to another location, please start the
MSSQL$SHAREPOINT service.
3. Please set the MSDEDatabases folder has the same permissions with
original folder.
V. Attach the databases by following these steps:
Bring up a command console, and then run:
OSQL -E -S servername\sharepoint <Enter>
| Quote: | sp_attach_db "STS_Config","D:\MSDEDatabases\Sharepoint\STS_config.mdf","
D:\MSDEDatabases\Sharepoint\STS_Config_log.ldf" <Enter
go <Enter
sp_attach_db "STS_servername_1","D:\MSDEDatabases\Sharepoint\
STS_servername_1","D:\MSDEDatabases\Sharepoint\STS_servername_1_log.ldf" |
<Enter>
*Note: Please replace servername of STS_servername_1 with the name of your
server!
VI. Restart the IIS and Server$Sharepoint services, next please bring up a
command console, and then run IISReset.
VII. Let us access http://companyweb to test.
More information:
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
I have tested the process, it works fine. Please follow above steps to have
a test again. Please note those parameters are case sensitive. I am
currently waiting for your test result.
I am happy to be assistance of you and look forward to your reply!
Have a nice day!
Sincerely,
Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx |
|
| Back to top |
|
|
BrianMultiLanguage
Guest
|
| Posted:
Sat Nov 12, 2005 1:50 am Post subject:
RE: can't move sharepoint by the instructions. |
|
|
Step V. Error.
sp_attach_db is not recognized as an internal or external command.....
BML |
|
| Back to top |
|
|
BrianMultiLanguage
Guest
|
| Posted:
Sat Nov 12, 2005 1:50 am Post subject:
RE: can't move sharepoint by the instructions. |
|
|
Since these DOS commands aren't reliably working, why not just back up the
whole directory of C:\Program Files\Microsoft SQL Server, uninstall all sql,
reinstall the SQL in the new location, restore the data from backup.
? |
|
| Back to top |
|
|
Kathy
Guest
|
| Posted:
Sat Nov 12, 2005 1:50 pm Post subject:
Re: can't move sharepoint by the instructions. |
|
|
Are you sure you typed the OSQL line in order to get the OSQL command prompt
(as these aren't DOS commands, but you quoted a DOS error message) before
entering the sp_attach_db line?
Kathy |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in