My day is bad today.

Question

My day is bad today.

forsqlserver

SSCoach

Points: 18902
More actions
September 14, 2011 at 11:54 pm

#243842

My day is bad today.The diferential backup file is not looking which dailly created at 5:00 AM.
In event log event is generated.
Full backup size is 260 GB.
Thanks

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Is there a question here?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

crazy4sql SSCoach Points: 19590 More actions · Answer 2

My day is bad today.The diferential backup file is not looking which dailly created at 5:00 AM.

change the number of your glass 😎

or

take another differential backup instead of searching for nothing :w00t:

----------
Ashish

forsqlserver SSCoach Points: 18902 More actions · Answer 3

We are expecting that file has created and somebody has deleted..Will it not break the sequence chain if I again issue the differential backup...We take the differential backup on daily basis and a full backup on sunday.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

forsqlserver (9/15/2011)
will it not break the sequence chain...

Huh?

If you've got questions, please ask them clearly.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 5

GilaMonster (9/15/2011)
forsqlserver (9/15/2011)
will it not break the sequence chain...
Huh?
If you've got questions, please ask them clearly.

TBH I wish there was an ignore button.

ps. One Orange Chip Points: 29422 More actions · Answer 6

forsqlserver (9/15/2011)
We are expecting that file has created and somebody has deleted..Will it not break the sequence chain if I again issue the differential backup...We take the differential backup on daily basis and a full backup on sunday.

Differential backups contain data from the Last FULL backup till the differential backup completes and does not depend on previous differential backup.

This happens in transaction log backups which are dependent on previous log backup and hence chain must be unbroken.

If someone has deleted diff backup, take a fresh one.

Pradeep Singh

forsqlserver SSCoach Points: 18902 More actions · Answer 7

Pradeep It is really sad ,I know all this still how all this happen,why dba's always think of the breakup of the chain sequence?While in differential backup chain doen't matter.Correct?

Edit: Tlogbackup is not scheduled due to SLA.

Thanks

ps. One Orange Chip Points: 29422 More actions · Answer 8

Differential backups are independent of other differential backups and depend on the previous full backup.

Pradeep Singh

crazy4sql SSCoach Points: 19590 More actions · Answer 9

no matter the number of reply you will get here......if you not going to learn today then many more bad days are coming

----------
Ashish

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 10

crazy4sql (9/15/2011)
no matter the number of reply you will get here......if you not going to learn today then many more bad days are coming

Liked this.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

forsqlserver SSCoach Points: 18902 More actions · Answer 11

forsqlserver

SSCoach

Points: 18902

September 16, 2011 at 1:27 am

#1382406

Thanks ....

Thanks