April 10, 2008 at 7:39 pm
Hi all,
I have a situation, All servers are on remote,
Server1--- from here i need to move two databases to Server2
Server2--- Here i need to restore the databases from server1
Server3--- Here the backups of server1 databases are stored
1)I wanted to know what is the best way to move my databases from
server1 to server2.
2)They want me to move the databases by taking the recent full
database backups,
3)How do i connect to the server3 to restore the full backups from
server2.
Pls reply me asap.
Thanks
Farooq
April 11, 2008 at 12:45 pm
q1) there are many ways. The easiest would be to detach the database copy the .mdf,ldf and logs zip them (.rar ) get them to the second server and then re-attach the database.
q2) full backup zip get it to server 2 and 3. Create an empty database "with the same number of data and log files" then select task restore the database choose from device select your backup then click options and override and in the restore database as window choose every file to its proper path.
April 12, 2008 at 8:10 pm
I did it with the export data wizard, because i wasnt able to restore the backups from the shared drives. Now the databases are moved successfully to another server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply