February 20, 2004 at 2:11 am
I'm completely new to SQL, and have to migrate a SQL 7 database from an old server to SQL 2000 on a new server, at a new location. The two servers cannot be connected in any way, no network (the old one has had it's network plug pulled) or compatible tape drive. The only method I have to get data from the old Server is by hooking up a laptop and using that as a carrier to the new server. Is it going to be as straight forward as copying the databases from the old PC (they're not that big) to the new server and then just telling SQL 2000 where they are? Any help would be greatly appreciated.
February 20, 2004 at 5:45 am
Personally I would backup the databases, copy the backups to the new server and restore using MOVE option. If you keep the backups in a separate area on the new server you can restore as many times as required until the database(s) are 'live'.
You can copy the files (.mdf & .ldf) to the new server and ATTACH them using sp_attach_db. If they are single files (1 mdf, 1 log) then this is straight forward. If there are multiple files then you have to attach them in the correct order. AFAIK (or remember) when you 'attach' a database to SQL2000 is is updated to SQL2000 and it it is not be possible to copy the file(s) back to SQL7.
Far away is close at hand in the images of elsewhere.
Anon.
February 20, 2004 at 10:07 am
Personally I like the backup restore. Run a backup and copy to your laptop, then copy to the enw server and restore.
http://www.sqlservercentral.com/columnists/sjones/migratingtoanewservermovinglogins.asp
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply