diff backup during full backup

Question

diff backup during full backup

tony28

SSCertifiable

Points: 7112
More actions
September 27, 2017 at 1:26 am

#349354

Hello,
I have only question for thinking.
if you have full backup which is sometimes more than 24 hours, for example 35 or more. Now will not thinking about slow disk system, i know 🙂
And in this time sometimes is execute also differential backup.. is there any problem with this ?
And which full backup i will use in case of restore ? This during diff or previous last week ?
thanks 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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

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

The differential backup will be blocked by the full, and hence will only execute after the full backup has completed, and hence it'll be obvious which diff you'd use to restore.

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

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 2

tony28 - Wednesday, September 27, 2017 1:26 AM
Hello,
I have only question for thinking.
if you have full backup which is sometimes more than 24 hours, for example 35 or more. Now will not thinking about slow disk system, i know 🙂
And in this time sometimes is execute also differential backup.. is there any problem with this ?
And which full backup i will use in case of restore ? This during diff or previous last week ?
thanks 🙂

As you allude to, it would seem that your backup system may have a bit of a problem and so you have piqued my interest. How big is this database?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

tony28 SSCertifiable Points: 7112 More actions · Answer 3

Hello,
thanks for response.

before was full backup every day, and that was little problem, also with backup system for tape. because like I wrote , every day backup and take more than 24hours., so sometimes fall down.

two different jobs with same schedule.
mon - sat > 4,30PM > diff
sun > 4,30PM > full

There are lot of databases , about 400GB, 200GB and then few small > 80,40,20 GB ...

So also with two jobs is possible that diff will wait for full backup ?

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

tony28 - Thursday, September 28, 2017 10:26 PM
So also with two jobs is possible that diff will wait for full backup ?

GilaMonster - Wednesday, September 27, 2017 2:21 AM
The differential backup will be blocked by the full, and hence will only execute after the full backup has completed

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

tony28 SSCertifiable Points: 7112 More actions · Answer 5

GilaMonster - Thursday, September 28, 2017 11:16 PM
tony28 - Thursday, September 28, 2017 10:26 PM
So also with two jobs is possible that diff will wait for full backup ?
GilaMonster - Wednesday, September 27, 2017 2:21 AM
The differential backup will be blocked by the full, and hence will only execute after the full backup has completed

everytime ok 🙂 thanks