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

Implementing a Flexible Backup Strategy Expand / Collapse
Author
Message
Posted Wednesday, October 6, 2004 11:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 17, 2014 2:05 AM
Points: 47, Visits: 18
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnis
Post #140350
Posted Tuesday, October 19, 2004 6:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 30, 2014 11:47 AM
Points: 91, Visits: 76
The automation and flexibility of this backup strategy appears safe.  I, however, would be concerned with the fact that it never does an incremental backup, which is the only way to truncate the transaction log.  Does anyone else have this same concern, or am I simply missing something?


Post #142352
Posted Tuesday, October 19, 2004 9:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:14 PM
Points: 11, Visits: 59

I think you are quibbling with semantics.

In terms of SQL Server Backups, I was under the impression that the term "Differential" is synonymous with "Incremental".  If you look at your choices in EM, you can choose Complete or Differential, as oppposed, say, to a Full-Text Index, where you can do Full Populations or Incremental Populations.  The Micro$oft team simply wasn't consistent with their terminology. 

The Differential truncates the Transaction Log. 




Post #142408
Posted Tuesday, October 19, 2004 4:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 5, 2014 8:45 AM
Points: 1,035, Visits: 412

Incremental and Differential backups are the same thing, or the terms are used interchangebly.  However, differential backups DO NOT truncate the transaction log, only a transaction log backup does that.  So the first poster is correct, this is not a comprehensive backup solution, but it could easily be made into one...

The design of the DatabasesBackupStrategy table is very poor.  The odd kind of pseudo bit masking with the 'CCCCCCC' and substring function is very awkward and breaks one of the fundamental rules of database design (atomicity.)  With a bit more thought and/or knowledge one could easily improve the design of this system, making it much more flexible.  What if you can't do either a differential or a full backup daily?  What if you want to do more than one per day?  This design will not address these issues and potentially many others.




/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek



*****************/
Post #142483
Posted Wednesday, August 31, 2005 1:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 4, 2006 8:36 AM
Points: 1, Visits: 1
when i execute exec sp_Flex_Db_Backup 'd:\sqlserverbkup' its display this error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '@BACKUPDESCRIPTION'.

what is this error could you trace and tell,
Post #215892
Posted Wednesday, October 19, 2005 10:28 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:52 PM
Points: 290, Visits: 52
"The design of the DatabasesBackupStrategy table is very poor."

Ouch. Might be nicer to say ""The design of the DatabasesBackupStrategy table could be improved upon by doing this...".

Yes, we deal in data, hence truth, but the truth can be presented in friendly terms.


John Scarborough
MCDBA, MCSA
Post #230293
Posted Wednesday, October 19, 2005 11:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 24, 2007 2:53 AM
Points: 28, Visits: 1
Good article.
It's not about everything, but can be extended if needed.
I think about implementing such thing on our customers servers.
I will extend settings table, maybe we'll write GUI and it will be better than 20 backup jobs.
Post #230320
Posted Monday, February 20, 2006 9:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 15, 2007 11:55 PM
Points: 5, Visits: 1
Great article, makes life so much easier for a DBA.
Post #259923
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse