« SQL Server 2008 Failover Clustering
Cumulative update package 4 for SQL Server 2005 Service Pack 3 »

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.

CU
tosc


Qui tacet, consentire videtur

backup, index, integrity, maintenance
SQL Server
 Print article This entry was posted by Torsten Schuessler on 2009-06-22 at 08:37:28 . Follow any responses to this post through RSS 2.0.
No feedback yet
Leave a comment

Your email address will not be revealed on this site.
PoorExcellent
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)
Trackback address for this post

http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=329

Schlagwort-Wolke

«access sql server» awards backup «best practices» books «cumulative update» datetime «dba award» dmv «high availability» «how it works» humor index indexoptimize integrity links loginproperty maintenance mcitp «ms sql server 2008» pdo performance php profiler «reporting services» reviews script serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql pass» «sql server» «sql server 2005» «sql server 2008» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack sys.dm_exec_sessions sys.server_role_members t-sql «technical note» tools troubleshooting webcast whitepapers