SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
I'm sure, that's exactly what Albert Einstein meant in his quote:"Try not to become a man of success but rather to become a man of value", Ola Hallengren becomes a man of value - with his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts.
He made some updates to the maintenance scripts:
- Support for selecting all databases; @Databases = 'ALL_DATABASES'.
- A database that is in single user mode can only be accessed by one user at a time. The new version has a check for this.
- Check in DatabaseBackup that database names are unique in the file system.
- New time limit parameter in IndexOptimize. Set @TimeLimit to for example 300 not to start execution of new commands after 300 seconds. (Ola, that's what I exactly meant! :-))
CU
tosc
| Print article | This entry was posted by Torsten Schuessler on 2009-08-25 at 09:04:41 . Follow any responses to this post through RSS 2.0. |
http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=338
Schlagwort-Wolke
backup «best practices» books «case study» ctp «cumulative update» datetime dmv ebook exams faq humor index indexoptimize integrity kb learning links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reports reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql 2008» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» sqlsrv ssms ssmstoolspack t-sql «technical note» tools training troubleshooting whitepapers




