December 1, 2009 at 10:09 am
Hello SQL Guru's,
I need an urgent help. We are migrating the sql 2000 to sql 2008. The final cutover backup strategy , the team is suggesting to take the last full backup and restore on new server with no recovery and in week later take the last differential backup and restore with recovery. I am suggesting to just take a full consistent backup on final cutover and restore with recovery instead of full and diff. What do you say? If you are suggesting an option then please give the reason too. My main concern is will it be ok to leave the database with no recovery for a week and then restore with last diff. backup with recovery. Do you see any issue with this process? Please reply asap.Thanks!
The db's are about 100 to 200 GB size.
December 1, 2009 at 10:16 am
Redundant Post...
why dont you continue in the old post...same query again..
http://www.sqlservercentral.com/Forums/Topic826786-338-1.aspx
December 1, 2009 at 10:18 am
Thanks for sending the link 😉 and thanks for the response. I really appreciate it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply