SQL Server Performance

how to move database files to new location?

Discussion in 'SQL Server Clustering' started by xuka200308, Aug 10, 2006.

  1. xuka200308 New Member

    Hi All
    i'd like to thank you for your great suggestion and great help in the past. but i have another question: i need to move the database files from default location to new folders i create after i install SQL Server 2000 clustering. i checked the KB/224071. it said how to move SQL Server database to a new location. my question is how i can move the database files to new location in clustering. where and how to stop and restart SQL Server? on cluster administrator or somewhere else? i didn't get any this kind of information online regarding to move database files on clustering. could anyone give me a hint on how/where to stop/restart SQL Server during the datasebase file moving?

    thanks in advance for any idea.

    karen
  2. satya Moderator

    The referred KBA is still applicable for Clustering and follow whatever method was suggested. As far as restarting SQL server services is concerned, there is no much difference as you need to stop the service from Administrative tools -->Services. Moving the database files you can deploy DETACH & ATTACH method.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. FrankKalis Moderator

  4. pchee373 New Member

    You should not use the Administrative Tools --> Services to stop the SQL server in a cluster. You should always try to stop the the SQL using the Cluster Administrator. When SQL is in a cluster. The SQL service is now controlled by the clustering service now. You want to keep the sql service in that control.
  5. xuka200308 New Member

    thank you all for your great information. i'll stop and start SQL Server clustering on cluster admin. it'd be great if i can stop/start it on service manager.

    have a nice weekend,

    karen

Share This Page