What is the best practice for copying system databases when migrating from SQL Server 2012 (no SP) to 2012 SP2 in a Failover Cluster? Just backup and restore? Or, script out and script in?
Asked
Active
Viewed 47 times
0
-
3Possible duplicate of [Migrating to a new SQL Server machine: should master database be restored?](http://serverfault.com/questions/386715/migrating-to-a-new-sql-server-machine-should-master-database-be-restored) – Bart De Vos Oct 24 '15 at 11:22
1 Answers
0
Best practice is to not migrate the system DBs.
Bart De Vos
- 17,911
- 6
- 63
- 82
-
A source for this best practice and some details as to why it's not might not be amiss here. – GregL Oct 22 '15 at 17:52
-
Not really anything online. See duplicate. Source: Years of working with SQL Server? – Bart De Vos Oct 24 '15 at 11:23