Avatar of k3vsmith
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?
SQLMicrosoft SQL Server

Avatar of undefined
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?
ASKER CERTIFIED SOLUTION
arnold

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
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.
ask a question
Alexander Ardatov

You can try to use copy-only full and tlog backups. It will not break current backup chain.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
k3vsmith

ASKER
Thanks. We are going to try mirroring.