New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available
Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.
Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. I love this tool to perform index maintenance on instances with VLDBs - and the best it's free!
New Version Available
A new version of the SQL Server Maintenance Solution is available. You can now perform striped backups across multiple drives in the DatabaseBackup stored procedure. Simply specify multiple directories in the @Directory parameter; for example:
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup, D:\Backup, E:\Backup, F:\Backup', @BackupType = 'FULL',
@Compress = 'Y',
@NumberOfFiles = 4
The new version also supports checking the consistency of a database on the file group level and on the table level. This capability is useful when you have VLDBs.
You can read more about the most recent version of the solution at http://ola.hallengren.com/versions.html or download it at http://ola.hallengren.com/scripts/MaintenanceSolution.sql
And now it's up to YOU!
2012 SQL Server Pro Community Choice Awards
The voting for the 2012 SQL Server Pro Community Choice Awards is now open! This year, the Ola Hallengren SQL Server Maintenance Solution has been nominated in the Best Backup & Recovery Product and Best Free Tool categories. So let us VOTE!!!
Please feel free to contact him if you have any questions. And I tell you, Ola will consider it!!!
I wish you a nice day,
|Print article||This entry was posted by tosc on 2012-09-10 at 10:50:00 . Follow any responses to this post through RSS 2.0.|
backup «best practices» books bug ctp «cumulative update» datetime dmv ebook humor index indexoptimize integrity kbfix links loginproperty maintenance «ms sql server 2008» performance php profiler «reporting services» reviews rtm serverproperty «service pack» «service packs» sharepoint sp_msforeachdb «sql 2012» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server builds» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack «stacia misner» t-sql technet «technical note» tempdb tools troubleshooting version whitepapers