December 16, 2008 at 9:08 pm
I have a DB server with Sql server 2000. The OS is windows 2000 server.
Now, The OS can't startup normally. I want to reinstall OS, but need to backup up DB file first. How to do it.
Copy all DB file and log files ?
After reinstall OS and sql server 2000, how to input the old DB file and log files to new Sql server.
Thanks.
December 16, 2008 at 9:25 pm
If you're able to startup OS in safeboot mode, check the sql server servcies status.
1. If its not running(or you are unable to start sql server), copy all the database files to a seperate drive. This includes your production databases and system databases.
2. If Sql server is running, take a backup of all databases (including system databases).
Once u're done with OS installation, SQL server installation with all the patches, you can restore the databases from the backed up files.
December 16, 2008 at 10:43 pm
but now , the os can't startup.
I want to knowe that how to restore DB file using all old DB file and log file.( I only copy the all file). Thanks
December 16, 2008 at 10:51 pm
What files do you have?
One thing to consider if you want the current mdf/ldf files is to install a new copy of the OS in a new folder, then boot to that and copy off the files. Then you can wipe the machine and reinstall SQL.
December 16, 2008 at 11:04 pm
If you're thinking of restoring old mdf/ldf files, you'll lose data that was changed after that old cold backup.
If losing data is fine with you, you can do that.
or as Steve suggested, do a 2nd OS install(i call dual boot) in a different folder or drive, copy database files to safe location and then do formatting/reinstallation.
Another option that i can think of is to consult your hardware engineers if they can pull out the disk drives, attach them to other systems and copy your data files before fresh installation.....
December 17, 2008 at 12:14 am
Thank you for your suggestion. I will try to do it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply