Posted by Byron on 12/10/05 10:18

Hi,

I have(had) an old Win2k Server server with about 30 web site databases
(SQL 2000) that just went under due to hardware problems. Thankfully, I
have backups of all the databases plus the MDF and LDF files from the
hard drive.

I want to move all of these sites and their data to a newer server
(Win2003) running SQL2000.

What's the best way to copy the database from the old server hard drive
(now mounted as an extrnal drive to a local machine; I'm currently
FTPing all of the web site directories from it to the new server)?

Just upload the original data to the new server and then mount the MDF
and LDF files within the new SQL server? Or do I restore the backup
files in the new SQL2000?

All of my previous data migrations have been DTS operations from one
live server to another, so no experience with either of the above
scenarios. I'll certainly have a lot more experience at one of them by
the time this weekend is through.

Thanks for any help you can offer.

• Next in forum: Re: Database security (crosspost)
• Prev in forum: Re: dynamically trasnpose rows into columns
• Thread view: How to copy data from backup or data files to new SQL installation?

[Reply to this message]