1) Some of our user DB's vary in Recovery Model, either Full or Simple. Is there anything to consider for the migration?
2) I foresee a significant delay between initial restore/testing and final cutover (while we upgrade our DTS packages...manually!!) However, currently the DB's are backed up fully on a regular basis - any recommendations on the best way to synch them (bearing in mind Recovery Models above?)
Here's a rough plan I made...
Ok, does this preserve the continuity of the LSN's and synch up ? ....
8pm Place all DB's in Full recovery, kick off Backups (full);
8.01 Disable t/log backup job;
10pm Backups complete;
10.01 Commence zip/copy of .bak files;
10.02 Enable t/log backup job;
10.03 Run batch process to copy all subsequent log backups to new server;
10.04 Go to the bar, chug down a few beers;
9am Restore scripted logins onto target;
10am Restore full backups onto target;
3pm Restore scripted jobs onto target;
Rebuild DTS packages in SSIS, test jobs etc...
5pm Reset all DB's on old server to Read only;
5.01 Restore all t/log backups (dozens, possibly hundreds by this point) at target, With NoRecovery, until the last one.