Please advise on a solution to migrate for SQL 2008 R2 and SQL 2012 to SQL 2016 Thursday, Febru6:00:34 AM - Shiraj Karolia INNER JOIN sysjobsteps sjt on sj.job_id = sjt.job_id Script to list dependant jobs would be better if you use below code use msdb How can we migrate more than 20 databases and size of database are more than 4TB? There are additional options such disk based replication etc. You can use backup to migrate (Full, Diff and Transaction Log) or you can use the HA services like Log Shipping to migrate. SELECT = + ', ' + 'IsRecursiveTriggersEnabled' SELECT = + ', ' + 'IsQuotedIdentifiersEnabled' SELECT = + ', ' + 'IsNumericRoundAbortEnabled' SELECT = + ', ' + 'IsLocalCursorsDefault' ![]() SELECT = + ', ' + 'IsCloseCursorsOnCommitEnabled' SELECT = + ', ' + 'IsAutoUpdateStatistics' SELECT = + ', ' + 'IsAutoCreateStatistics' SELECT = + ', ' + 'IsArithmeticAbortEnabled' SELECT = + ', ' + 'IsAnsiWarningsEnabled' SELECT = + ', ' + 'IsTornPageDetectionEnabled' SELECT = + ', Collation=' + = + ', SQLSortOrder=' + These are the boolean properties Set = 'Status=' + = + ', Updateability=' + = + ', UserAccess=' + = + ', Recovery=' + = + ', Version=' + These props only available if db not shutdown Script to Check the Disk and Database Size
0 Comments
Leave a Reply. |