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.
Author |
Topic |
oberon
Starting Member
3 Posts |
Posted - 2007-05-31 : 11:27:38
|
Hi everybodyI 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 |
|
|
|
|
|