January 24, 2005 at 4:57 am
I have a new machine on which I need to load old files from another system. I have copied the hard drive from the old system, as it is now dead. With that, I have the entire MSSQL directories and the database files. How do I restore the database to the new computer. What files need to be moved where? Note, both machines are/were running the same SQL Version , 7.0
Thanks
Dan
January 25, 2005 at 5:01 am
1) If you have file backups, you can use those to restore each db. 2) You can also "attach" each database using the mdf and ldf files in the Data folder. 3) If your setup is the exactly the same for both SQL servers (reg settings, file pathes, etc.), it might work to copy all the old "Data" folder(s) files (master, msdb, etc.) to the new Data folder(s), replacing those already there. When SQL Server starts, it just might work - also, it might not.
I hope this is not a production machine.
Randy
Helpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
January 26, 2005 at 12:36 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply