January 31, 2011 at 12:10 pm
Friends, we are moving our SQL 2005 box to 2008 We are going to follow Side by Side Upgrade approach by backup and restore method I have doubts over default databases How should we handle them ? specially when they contain the login information (very particular about these), job details etc. Can you suggest pre upgrade checklist or points to be taken care of ?
January 31, 2011 at 12:40 pm
You can make use of SQL Server 2008 Upgrade Advisor to look for any possible issues, before actually upgrading the instance. You may find this article useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 31, 2011 at 1:18 pm
Is there anything to take care of with respect to login transfer ?
January 31, 2011 at 10:10 pm
Since you are upgrading, the setup would take care of transferring the logins to the upgraded instance. However, before performing the upgrade make sure to have FULL backups of all the databases including the system databases.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 1, 2011 at 10:57 am
And in case of migration ?
February 1, 2011 at 11:09 am
If you are migrating the user databases to a new SQL Server 2008 instance, you can script the logins on the SQL Server 2005 instance using sp_help_revlogin and execute the resultant script on SQL Server 2008 instance.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 1, 2011 at 11:14 am
Try using the Transfer login task in BIDS and be sure that "Copy Sids" is set to True. It worked great for my side by side upgrades.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply