mardi 1 mars 2016

Need suggestion for SQL server 2005 to 2012 migration steps [on hold]

I have to create a plan of implementation for SQL server 2005 to 2012 migration. My senior told me that i am missing important points so please check the steps below and suggest me what i am doing wrong.

Migration

1 Run upgrade adviser on the databases for the instance that i want to upgrade.

2 If any issues found, Report dev team/ Vendor for fixing the same.

3 Take the backup of all the databases and validate them.

4 Backup of sql server level setting by sp_configure.

5 Scripting out all the jobs and take it in a file.

6 Scripting the linked server

7 Restore the backup on the destination server and fix the orphan users issue

8 Change the compatibility level and run dbcc checkdb on all the databases.

9 Run rebuild indexes on all the databases.

10 restore server level setting on the destination server

11 run job scripts on the destination sql server

12 Change job owner if any problem exists.

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire