Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

WSS 3.0 with MS SQL 2005 PRO - content database location

  Asked By: Melissa    Date: Jun 07    Category: Sharepoint    Views: 2261

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 .



1 Answer Found

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

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.