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?
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
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?
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
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
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
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
ASKER
Thanks. We are going to try mirroring.
From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.