Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

WSS 3.0 with MS SQL 2005 PRO - content database location

Asked By: Melissa Lewis Date: Jun 07, 2007 Category: Sharepoint Views: 489

I need to install WSS 3.0 with MS SQL 2005 PRO on a single server, and
store the content database on a separate drive (attached H: drive).
Where or how I can specify the location of the content database
during/before the installation? Any help appreciated... I can not find
any documentation on this subject .

Tagged:wss with ms sql 2005 pro content database location

1 Answer Found

Answer #1 Answered By: Judy Pittman Answered On: Jun 07, 2007

If you want all your databases to be on a seperate drive, you can specify the
Data location during SQL setup, or if the SQL Server is already setup see the
"Database Settings" page in the Server Properties dialog.

If your SQL Server is already setup, you can move your content database after
it's setup using the instructions here: http://support.microsoft.com/kb/224071/

There is no way in WSS to instruct SQL which drive to put the databases.

There were instructions for WSSv2 and SPS2003 for pre-creating a database, then
preparing it for SharePoint then adding it in to the content databases page, but
can't seem to find that link

Didn't find what you were looking for? Find more on WSS 3.0 with MS SQL 2005 PRO - content database location Or get search suggestion and latest updates.