Hi
We did a full backup of a DB on Server A (SQL Server 2000) and restored it on Server B (SQL server 2005). Since we have Notification Services, so we run nscontrol upgrade command to upgrade it to 2005. We want to test our application by pointing test server to Server B, while our live application is running by still pointing to Server A.
Now we want to make the states of Server A and B in sync. What can be the best approach for this, since during upgrade some data gets modified. Will differential backup work in this scenario?
Please help me.
Thanks,
Gagan
Unfortunately differential backup does not work across the sql2000->sql2005 upgrade.
Before taking differential backups in sql2005, a new full backup is required.
However, when using the FULL/BULK recovery models, you can use log backups to rollforward thru the upgrade.
Be aware that until server A is upgraded to sql2005, no backups taken from server B (now at sql2005) can be restored.
Hope that helps.
No comments:
Post a Comment