Storing SQL server data on another physical drive?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  January 12, 2006 at 10:18 am

  #188848

  I have a pc running SQL server 200 and all the databases I use are on another hard drive on the same pc, my question is, if for any reason I need to reinstall the operating system and SQL Server on the main drive (for instance after a system crash) how do I point the server to drive D again to pick up all my existing data including Databases and Stored Procedures?

• mimorr

  SSCarpal Tunnel

  Points: 4850

  More actions

  January 12, 2006 at 10:37 am

  #614435

  Before you reinstall, it is best to detach all your databases. Then reinstall the OS and SQL and then attach your databases. If you don't get a chance to detach the DBs, you might still be able to reattach them. Make sure to make a backup of all your data before attempting any of this.

  In Books Online(BOL), take a look at the following topics:

  sp_attach_db

  sp_detach_db

  Physical Database Files and Filegroups

  
  
  Michelle

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  January 12, 2006 at 11:22 am

  #614455

  Many thanks Michelle, I found that very helpfull