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 12345»»»

Restart Log Backups Expand / Collapse
Author
Message
Posted Wednesday, June 27, 2012 8:58 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Restart Log Backups






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1322249
Posted Thursday, June 28, 2012 12:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 12,206, Visits: 9,169
Got burned by this one. Very interesting question, good job Steve.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1322287
Posted Thursday, June 28, 2012 12:37 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 12:58 AM
Points: 1,904, Visits: 2,771
too quick on the trigger - owned.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1322293
Posted Thursday, June 28, 2012 12:59 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:08 AM
Points: 3,448, Visits: 4,406
Happy to be enlightened about that myth. It definitely worth two points.
Post #1322301
Posted Thursday, June 28, 2012 1:57 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 6:25 AM
Points: 716, Visits: 755
Agggghhhhh

Good question and a very good learning point, thanks
Post #1322315
Posted Thursday, June 28, 2012 2:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:33 AM
Points: 1,128, Visits: 756
Good Question, explanation scripts were good :)
Post #1322325
Posted Thursday, June 28, 2012 4:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 9:52 AM
Points: 1,319, Visits: 176
Good question.

However just because I could get away with a differential backup, the 'once bitten twice shy' part of me would always go for a full backup unless there was some overriding driver (time to backup?) pushing me to take a differential backup. It simplifies any future recovery of the database (full backup plus log file(s) vs full backup plus differential backup plus log files).

Call me old fashioned if you like.
Post #1322353
Posted Thursday, June 28, 2012 5:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:35 AM
Points: 1,625, Visits: 2,034
Thanks for the question Steve. I was surprised to see the number of incorrect answers. I hardly ever administer DBs, mostly design and programming. Maybe the lack of certainty about the right answer helped in this case. It made me slow down and think it through. Too bad I don't do that in all cases.

(Edited to fix non-spellcheckable typo.)


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1322368
Posted Thursday, June 28, 2012 6:11 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:34 AM
Points: 3,352, Visits: 1,478
I got led astray by the error message. Since it said there was no current database backup, I thought that meant you couldn't do a differential backup at all (since there was no full backup to "diff" against). Moral - error messages don't always say what they mean...
Post #1322382
Posted Thursday, June 28, 2012 6:16 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:34 AM
Points: 3,352, Visits: 1,478
Duncan Pryde (6/28/2012)
I got led astray by the error message. Since it said there was no current database backup, I thought that meant you couldn't do a differential backup at all (since there was no full backup to "diff" against). Moral - error messages don't always say what they mean...


To follow on from this point, the message you get when performing a diff backup against a database where a full backup has not been taken is:

Msg 3035, Level 16, State 1, Line 1
Cannot perform a differential backup for database "xyz", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Seems quite similar to the log backup message in the way it refers to a current database backup, but this time actually means that there is no current backup.
Post #1322385
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse