MSSQL$SHAREPOINT location

[anon...@discussions.microsoft.com]

Hi

Can anyone point me in the direction of information which
will help me move the companyweb data (MSSQL$SHAREPOINT)
directory to another drive. It used to be on the "E"
drive but I broke my companyweb and had to remove and
reinstall everything, but it installs onto my "C" drive
which isn't cool. I cant figure out how to select the
location in Small Business Server setup. Any help would
be greatly appriciated.

thanks
Tim

[Les Connor [SBS MVP]]

Hi Tim,

From a google search of this newsgroup:

<snip>
Everything is stored in the MSSQL$SharePoint database. Default location is
Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data.

Companyweb is basically Windows SharePoint Services. Check out the admin
guide to learn about the product.
http://www.microsoft.com/downloads/details.aspx?familyid=a637eff6-8224-4b19-
a6a4-3e33fa13d230&displaylang=en

Follow the steps below to move the SharePoint database.
==================================

OSQL -E -S servername\sharepoint [Enter]
sp_detach_db STS_Config [Enter]
go [Enter]

sp_detach_db STS_servername_1 [Enter]
go [Enter]

<Before you go to the next two steps. Go ahead to copy the SharePoint files
from the original location (Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data) to the "new location">

exec sp_attach_db @dbname = 'STS_Config', @filename1= 'E:\new
location\STS_config.mdf', @filename2 = 'E:\new location\STS_Config_log.ldf'
[Enter]
go [Enter]

exec sp_attach_db @dbname = 'STS_servername_1', @filename1= 'E:\new
location\STS_servername_1.mdf', @filename2 = 'E:\new
location\STS_servername_1_log.ldf'[Enter]
go [Enter]

==================================

Ray Fong
Microsoft SBS Product Support

<endsnip>

--
Les Connor [SBS MVP]
-------------------------------------
SBS Rocks !

"t...@inetomaha.com" <anon...@discussions.microsoft.com> wrote in message
news:287901c42178$0ddb1430$7d02...@phx.gbl...

[Frank Brown [MSFT]]

Thank you for posting your question.

These commands will move the SharePoint DB from one location to another.
Replace "servername" with the name of your server.
Exit to a command prompt and enter the following commands:

==========================================

OSQL -E -S servername\sharepoint <Enter>
sp_detach_db STS_Config <Enter>
go <Enter>

sp_detach_db STS_servername_1 <Enter>
go <Enter>

exec sp_attach_db @dbname = 'STS_Config', @filename1= 'E:\new

location\STS_config.mdf', @filename2 = 'E:\new
location\STS_Config_log.ldf' <Enter>
go <Enter>

exec sp_attach_db @dbname = 'STS_servername_1', @filename1= 'E:\new
location\STS_servername_1.mdf', @filename2 = 'E:\new
location\STS_servername_1_log.ldf' <Enter>
go <Enter>

Regards,

Frank Brown
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

[Les Connor [SBS MVP]]

If you have Premium (SQL installed) and have upgraded your Companyweb to
SQL, use this:

224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071

--
Les Connor [SBS MVP]
-------------------------------------
SBS Rocks !

"t...@inetomaha.com" <anon...@discussions.microsoft.com> wrote in message
news:287901c42178$0ddb1430$7d02...@phx.gbl...

[anon...@discussions.microsoft.com]

Thanks. I was able to use these commands and it looks
like they took, but now i get a "The virtual server that
is referenced here is not in the config database."
whenever I try to get to the companyweb. I looked at the
sharepoint administration settings, but I get the same
error when I try to modify the virtual server settings.
Any advice?

>.
>

[anon...@discussions.microsoft.com]

Thanks. I was able to use these commands and it looks
like they took, but now i get a "The virtual server that
is referenced here is not in the config database."
whenever I try to get to the companyweb. I looked at the
sharepoint administration settings, but I get the same
error when I try to modify the virtual server settings.
Any advice?

>.
>