Link to home
Start Free TrialLog in
Avatar of k3vsmith

asked on

Moving a large MS Sql Database

Im looking for a way to move a large MS Sql Database without taking a full backup and copying it over to new server.

Is there a way to copy database today.
Then the next day only copy over what has changed since last copy?
Avatar of Alexey Komarov
Alexey Komarov
Flag of Russian Federation image

From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.
Avatar of k3vsmith


Ok, so your saying copy full backup over to server. Then restore full backup in norecovery mode. I will have to look up how to do that.
Then your saying I should be able to copy over transaction log backups from point of time I took full backup to time I want to cutover to new server?
Avatar of arnold
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can try to use copy-only full and tlog backups. It will not break current backup chain.
Thanks. We are going to try mirroring.