160
We are looking at new database hardware and our SQL Server will go from 2008R2 to 2012. I don't think this is all that complicated, but I can't seem to find much in the way of documentation for SL database upgrades.
We use integrated security, so will need to move logins in addition to the databases.
We are SL2011FP1 if that matters.
Did I miss the write up on this?
Regards,
Stuart
*This post is locked for comments
Moving to a new SQL server, the largest issue is moving the SQL Authenticated users before moving the DBs. Then all that is needed is to clean up the orphaned SQL users once the DBs are moved.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (