Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Backup and Housekeeping with Maintenance Plans Expand / Collapse
Author
Message
Posted Tuesday, January 25, 2011 9:31 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:53 PM
Points: 1,030, Visits: 2,791
Comments posted to this topic are about the item Backup and Housekeeping with Maintenance Plans

Gethyn Ellis

gethynellis.com
Post #1053641
Posted Wednesday, January 26, 2011 2:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 19, 2013 9:13 AM
Points: 36, Visits: 134
I usually perform the clean up before the backups, that way, it will make the most efficient use of disk space and backups are less likely to fail due to lack of space.
Post #1053710
Posted Wednesday, January 26, 2011 2:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:53 PM
Points: 1,030, Visits: 2,791
Taggs (1/26/2011)
I usually perform the clean up before the backups, that way, it will make the most efficient use of disk space and backups are less likely to fail due to lack of space.


That's a fair point the only thing I would say to that is make sure you don't leave yourself in a situation where you deleted the backup and don't have a new one. (If you only keep one backup)


Gethyn Ellis

gethynellis.com
Post #1053722
Posted Wednesday, January 26, 2011 3:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:24 AM
Points: 78, Visits: 144
Good article and led me to check our backup plans set up by a contractor. Discovered that there is no clearing of the backup and restore history and msdb has grown from 12Mb to over 3Gb!
Thanks for the heads up.
Post #1053744
Posted Wednesday, January 26, 2011 4:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 19, 2013 9:13 AM
Points: 36, Visits: 134
Yes, We store 2 days SQL backups locally but also copy these backups on to our 3rd party corporate backup system.
Post #1053763
Posted Wednesday, January 26, 2011 4:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:53 PM
Points: 1,030, Visits: 2,791
Martin Hawley (1/26/2011)
Good article and led me to check our backup plans set up by a contractor. Discovered that there is no clearing of the backup and restore history and msdb has grown from 12Mb to over 3Gb!
Thanks for the heads up.


I'm pleased you found it useful.


Gethyn Ellis

gethynellis.com
Post #1053764
Posted Wednesday, January 26, 2011 7:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, August 17, 2011 7:09 AM
Points: 869, Visits: 963
Nice article!
Post #1053838
Posted Wednesday, January 26, 2011 7:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:34 PM
Points: 909, Visits: 4,478
Thank you! I'd not looked at the History Cleanup task, so I didn't know what it might do (yes, I'm rather new to managing an SQL Server, and don't have a mentor)

So, I took a look at a maintenance plan I had set up to backup several DBs on a server, and checked the msdb size. 108GB!! So I added in a History cleanup at the end, and will see if that shrinks it down tonight when the plan executes!

Thank you from a novice!
Jason A.
Post #1053861
Posted Wednesday, January 26, 2011 8:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:39 AM
Points: 5, Visits: 204
Thanq for your article.
Post #1053883
Posted Wednesday, January 26, 2011 8:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:53 PM
Points: 1,030, Visits: 2,791
jasona.work (1/26/2011)
Thank you! I'd not looked at the History Cleanup task, so I didn't know what it might do (yes, I'm rather new to managing an SQL Server, and don't have a mentor)

So, I took a look at a maintenance plan I had set up to backup several DBs on a server, and checked the msdb size. 108GB!! So I added in a History cleanup at the end, and will see if that shrinks it down tonight when the plan executes!

Thank you from a novice!
Jason A.


Jason, just a word of warning make sure that the cleanup task when deleting 108GB of data does not block other scheduled backups occuring, it maybe an idea to cleanup in smaller chunks instead of one large hit.


Gethyn Ellis

gethynellis.com
Post #1053893
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse