SQL Server 2005 - Backup, Integrity Check and Index Optimization

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ola Hallengren » SQL Server 2005 - Backup, Integrity Check and...

35 posts, Page 4 of 4

«««1 2 3 4

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Rate Topic

Display Mode

Topic Options

Author

Message

Leeland

Posted Thursday, March 17, 2011 9:53 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:39 AM
Points: 416, Visits: 1,018

After a nice conversation with Ola I think I understand his concept about the script and the reasons for the logic in some points. It does make sense and if you wanted to add notifications to certain aspects it would be easy to modify.

In my opinion it would depend on what you are comfortable with as far as relying on the script to make the correct decision depending on the situation or if you would like to be involved when something unplanned occurs so you can investigate.

Overall I can't believe he did such a nice job with the script and I look forward to trying to use if all works out.

Lee

Post #1079810

Anish-1093520

Posted Wednesday, March 13, 2013 4:10 AM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, June 09, 2013 11:42 PM
Points: 219, Visits: 105

I have been using this solution quite some time now, its super fantastic.

Regards,
Anish

Post #1430283

webrunner

Posted Monday, June 10, 2013 2:44 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 2:08 PM
Points: 2,121, Visits: 2,226

This is a fantastic set of scripts. Thanks to Ola Hallengren for them!

I do have one question, though. I have tried setting the CleanupTime for the backup script to 24 (for 24 hours), yet the server is leaving 2 days' worth of backup files on the server. Should it not leave only 1 copy? Should I set the CleanupTime to 23 (or 25?) hours to leave only 1 day's backup on the server for each database? Sorry if I'm missing something obvious.

Thanks in advance for any help.

- webrunner

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #1461778

Ola Hallengren

Posted Tuesday, June 11, 2013 8:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:38 AM
Points: 168, Visits: 1,768

I calculate the cleanup time before I start backing up the database. The reason for that is to protect against a scenario where you delete a backup that you have just performed. Please send me a mail (http://ola.hallengren.com/contact.html) if you are interested in more details on this.

Another thing is that you may have variations in the time when the backup finishes.

Because of these things you need to set the CleanupTime to 23 or 22 hours in your case.

Ola Hallengren
http://ola.hallengren.com

Post #1462168

webrunner

Posted Tuesday, June 11, 2013 8:44 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 2:08 PM
Points: 2,121, Visits: 2,226

Ola Hallengren (6/11/2013)

Many thanks, Ola. Setting the time to 23 hours seems to have worked. The backup job in question takes about 30 minutes, but that may have been enough time with the 24 setting to prevent deleting the older backup.

- webrunner

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #1462186

« Prev Topic | Next Topic »

35 posts, Page 4 of 4

«««1 2 3 4

Permissions