Moving Data Folders for Windows Small Business Server 2003

I need to move Monitoring folder with files SBSMonitoring.mdg ect.

I am doing it exactly like in instruction
http://technet.microsoft.com/en-us/l...31(WS.10).aspx


but there is a command to copy:

Osql -E -S ServerName\SBSMonitoring -Q "sp_detach_db 'SBSMonitoring'" and
result is:


C:\Documents and Settings\Administrator> Osql -E -S MYSERVER\SharePoint -Q
"sp_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]

It looks like a syntax error ? but syntax is corect

Anyone can help?

Verify your quotation marks. Sometimes you get "smart quotes" from the
website when you copy/paste so maybe retype them.

--
Allan Williams




ZielonySBS wrote:
> I need to move Monitoring folder with files SBSMonitoring.mdg ect.
>
> I am doing it exactly like in instruction
> http://technet.microsoft.com/en-us/l...31(WS.10).aspx
>
>
> but there is a command to copy:
>
> Osql -E -S ServerName\SBSMonitoring -Q "sp_detach_db 'SBSMonitoring'"
> and result is:
>
>
> C:\Documents and Settings\Administrator> Osql -E -S
> MYSERVER\SharePoint -Q "sp_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]
>
> It looks like a syntax error ? but syntax is corect
>
> Anyone can help?

Hello,

Thanks for your post and Allan's input.

Please click the "Copy Code" option on the right of the page and modify the ServerName part. Make sure you didn't change the default configuration name which is
"STS_Config". You can verify the names under "C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data" folder.

Hope this helps.


Best regards,
Robbin Meng(MSFT)
Microsoft Online Newsgroup Support