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?
Chief Project Engineer
CERTIFIED EXPERT
Hi,
From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.
From the beginning you need to restore full backup in norecovery mode.
Then you need to restore all transaction log backup's.
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?
