Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how to save my DB before uninstalling SQL Server?

Author  Topic 

oberon
Starting Member

3 Posts

Posted - 2007-05-31 : 11:27:38
Hi everybody
I have to uninstall my SQL Server 2000, so I need to make a backup of some of my databases.
Would u tell me what should I exactly do?
Before uninstalling SQL Server, which file(s) and from where should I copy for future restore?
Thank you

Kristen
Test

22859 Posts

Posted - 2007-05-31 : 11:40:37
Make a Backup. Restore the backup file on another computer, running SQL Server, to prove that you can. Run a DBCC CHECKDB on the database - to check for errors (i.e. after restoring on the second computer)

You can also detach the database, and copy the files (usually one .MDF and one .LDF). But it is not recommended to Detach a database unless you have a backup ... so taking a Backup would be my preferred approach.

Kristen
Go to Top of Page
   

- Advertisement -