SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
Ola Hallengren, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts:
- Support for printing of commands without executing them. Set the new parameter @Execute to 'N' to use this feature. Please note that you need the latest versions of DatabaseBackup, DatabaseIntegrityCheck, IndexOptimize and CommandExecute to use this feature.
- Changed behaviour in DatabaseBackup when deleting old log backups. In the new version it doesn't delete any log backups that are newer than the latest full or differential backup.
| Print article | This entry was posted by tosc on 2009-06-22 at 08:37:28 . Follow any responses to this post through RSS 2.0. |
-
-
backup «best practices» books bug ctp «cumulative update» demo dmv ebook humor index indexoptimize integrity kbfix maintenance «ms sql server 2008» performance php reviews «service pack» «service pack 2» «service packs» sharepoint «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack sysadmin t-sql «technical note» tempdb tools «trace flag» whitepapers
Tag cloud
backup «best practices» books bug configuration ctp «cumulative update» demo denali dmv ebook humor index indexoptimize integrity kbfix loginproperty maintenance «ms sql server 2008» performance php profiler «reporting services» reviews «service pack» «service pack 2» «service packs» sharepoint «sql 2012» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack sysadmin «system views» t-sql «technical note» tempdb tools «trace flag» troubleshooting upgrade whitepapers