December 17, 2008 at 6:27 am
Hi,
Which method below is preferred while carrying a database to another server?
1) Detach / Attach Mdf, ldf files?
2) Full Backup and take transaction log backup after full backup up to now?
Is there any advantages/disadvantages which are declared?
December 17, 2008 at 6:50 am
thinknight (12/17/2008)
Hi,Which method below is preferred while carrying a database to another server?
1) Detach / Attach Mdf, ldf files?
2) Full Backup and take transaction log backup after full backup up to now?
Is there any advantages/disadvantages which are declared?
That depends on a lot of things (size of the DB, your network connection between the servers, free disk space, etc.)
1) is probably the easiest, but if you have the space I'd reccomend a full backup before you do anything just in case.
2) also will work fine....
But in either case, if at all possible I'd somehow get users (or other processes) out of the database before you start the move. That way you'll only need to mess with a full backup and not a TX log backup.
The Redneck DBA
December 17, 2008 at 12:26 pm
It depends on whether you have downtime or not. 1st technique requires downtime and also databases won't be avaiable on source instance once they are detached.
Backup/Restore process can do your work with minimal downtime and databases will be available on source instance.
MJ
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply