Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Melissa    Date: Aug 26    Category: Sharepoint    Views: 603

If I want to move databases to a different drive, can I just shut down
SharePoint, detach the database, copy the files, attach the database and
then restart the services?



2 Answers Found

Answer #1    Answered By: Brinda Bca     Answered On: Aug 26

Yup. SharePoint only cares about the SQL instance and the database
name. You can put the databases  wherever you want just as long as they
respond to the same SQL instance and database  name. You just need to
make sure you reattach them in SQL, there's nothing to do in SharePoint.

Answer #2    Answered By: Sheryl Velez     Answered On: Aug 26

Anyway I wanna know about the performance issue when running WSS 3.0 on SQL
server 2005 and SQL Server 2000.

Do you have article related to this issue ?

Didn't find what you were looking for? Find more on Databases Or get search suggestion and latest updates.