December 15, 2014 at 2:08 am
After migrating databases from 2008 to SQL 2012, what are the steps I should do?
I did change comp to 110 and ran integrity.
December 15, 2014 at 2:23 am
Hi,
1. Take Backup of all the user and system databases.
2. Run SQL Server 2012 Upgrade Advisor and check for any warning or error.
3. Check BOL for "Breaking Changes" and "Behavioral changes"
4. Run Upgrade Setup.
5. Run DBCC CHECKDB WITH DATA_PURITY;
6. Update Stats
7. Take a Full Backup again. (Just in case...)
Regards
Shafat Husain
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 15, 2014 at 2:25 am
PS
5.5 DBCC UPDATEUSAGE(db_name); (To Fix page count inaccuracies)
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply