We help IT Professionals succeed at work.

Moving a large MS Sql Database

k3vsmith
k3vsmith asked
on
130 Views
Last Modified: 2017-04-03
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?
Comment
Watch Question

Alexey KomarovChief Project Engineer
CERTIFIED EXPERT

Commented:
Hi,
From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.

Author

Commented:
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?
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Alexander ArdatovSoftware Manager

Commented:
You can try to use copy-only full and tlog backups. It will not break current backup chain.

Author

Commented:
Thanks. We are going to try mirroring.