January 12, 2006 at 10:18 am
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?
January 12, 2006 at 10:37 am
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
January 12, 2006 at 11:22 am
Many thanks Michelle, I found that very helpfull
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply