good to do b/c the bigger it is, the longer it will take to load into memory — USE msdb; GO EXEC sp_cycle_agent_errorlog;
Month: May 2016
Very detailed https://www.brentozar.com/?s=What+to+Do+When+DBCC+CHECKDB+Reports+Corruption
https://www.simple-talk.com/sql/sql-tools/sql-server-tablediff-utility/ “TableDiff can be used for comparing tables, as when you run automated tests that check a result against a table of expected values.”
Excerpt from http://www.sqlsoldier.com/wp/sqlserver/schemaonlybackupsandrestores Schema-only Backups Alternatively, there is an option for exporting a data-tier application which has lots of options and allows you to export only part of a database and includes the data. That’s a discussion for another day.If you right-click on a database…