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?
SQLMicrosoft SQL Server
Last Comment
k3vsmith
8/22/2022 - Mon
Alexey Komarov
Hi,
From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.
k3vsmith
ASKER
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?
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.