|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Yesterday @ 2:05 AM
Points: 147,
Visits: 1,232
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, November 02, 2009 4:35 AM
Points: 1,
Visits: 21
|
|
ola, just wanted to give you big thumbs up for the 3-in-1 DB maintenance script. within our sql environment it's working beyond our expectations.
keep up the good work!
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 7:31 AM
Points: 46,
Visits: 62
|
|
Hello,
I was wondering why the publication date of the article is 0001/01/01 
Anyway, I'm trying to watch the documentation on your website. It seems that it is no more available. Can you place it in the forum please ?
Thanks by advance,
Matthieu
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Friday, September 04, 2009 8:56 AM
Points: 11,
Visits: 53
|
|
I would like to use your script as it is far better than some thing I can write. Thanks for your contribution to DBA world. I would prefer to clean up backup files or tlog backups after 6 days. How could I accomplish this using your script ? Is it possible to add or update for this purpose with your next update?
thanks,
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 2:05 AM
Points: 147,
Visits: 1,232
|
|
You can use the parameter @CleanupTime to delete old backup files. It's in hours so you have to set it to 144 (24 * 6) to keep backup files for 6 days. Please see this example for the transaction log backups.
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'LOG',
@Verify = 'Y',
@CleanupTime = 144
Documentation
http://ola.hallengren.com/Documentation.html
Ola Hallengren
http://ola.hallengren.com
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 2:05 AM
Points: 147,
Visits: 1,232
|
|
I was experiencing downtime on my website yesterday, but it's working again now. I'm sorry for the inconvenience.
The script was first published on SQL Server Central 23 Feb 2008.
Ola Hallengren
http://ola.hallengren.com
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 8:55 AM
Points: 27,
Visits: 73
|
|
Awesome. Two thumbs up for you, Ola. Finally someone post it. I have been using three scripts on agentjob I wrote to do these three things. Better late than never for those who are still missing the boat. I have not run yours yet personally. Anybody find a kink, please post for discussion.
http:/usa.redirectme.net
|
|
|
|
