SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


differential backup question


differential backup question

Author
Message
chewychewy
chewychewy
SSC Veteran
SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)

Group: General Forum Members
Points: 238 Visits: 520
Hi Guys,

For example only.

I have a daily full db backup via SQL maintenance plan to file system at 10pm.
I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday - differential
Sunday - Full

In this case, if let's say thursday afternoon have data issue, can i restore with the differential backup taken on wed night <arcserve> + the full backup taken on sunday <arcserve>?
Not supposed to work right?


thanks
sanket kokane
sanket kokane
SSC-Addicted
SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)

Group: General Forum Members
Points: 475 Visits: 1022
chewychewy (11/7/2012)
Hi Guys,

For example only.

I have a daily full db backup via SQL maintenance plan to file system at 10pm.
I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday - differential
Sunday - Full

In this case, if let's say thursday afternoon have data issue, can i restore with the differential backup taken on wed night <arcserve> + the full backup taken on sunday <arcserve>?
Not supposed to work right?


thanks



No,

then you need to restored full backup taken on wed night (10 PM) + differntial backup taken on wed night using arcserv (11 PM) .

-----------------------------------------------------------------------------
संकेत कोकणे
Bhuvnesh
Bhuvnesh
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5196 Visits: 4076
@sanket why tuesday full back which is not there (for arcserve )

see

I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday - differential
Sunday - Full

i think OP needs to go for sunday FULL and last diif backup taekn (whether on tuesday or wednesday)

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
sanket kokane
sanket kokane
SSC-Addicted
SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)

Group: General Forum Members
Points: 475 Visits: 1022
Bhuvnesh (11/7/2012)
@sanket why tuesday full back which is not there (for arcserve )

see

I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday - differential
Sunday - Full

i think OP needs to go for sunday FULL and last diif backup taekn (whether on tuesday or wednesday)





I mean
full backup taken on wed night (10 PM) using maintenance plan + differntial backup taken on wed night using arcserv (11 PM)

-----------------------------------------------------------------------------
संकेत कोकणे
sanket kokane
sanket kokane
SSC-Addicted
SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)SSC-Addicted (475 reputation)

Group: General Forum Members
Points: 475 Visits: 1022
[b]i think OP needs to go for sunday FULL and last diif backup taekn (whether on tuesday or wednesday)



will it work ?

diff backup should be applied to its earliest full backup , which is Wednesday's full backup .

-----------------------------------------------------------------------------
संकेत कोकणे
Bhuvnesh
Bhuvnesh
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5196 Visits: 4076
i had impression that there are two options

I have a daily full db backup via SQL maintenance plan to file system at 10pm.

AND
I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday - differential
Sunday - Full


and thats the case then why there is duplicate backup for sunday

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19784 Visits: 17242
chewychewy (11/7/2012)
Hi Guys,

For example only.

I have a daily full db backup via SQL maintenance plan to file system at 10pm.
I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday - differential
Sunday - Full

In this case, if let's say thursday afternoon have data issue, can i restore with the differential backup taken on wed night <arcserve> + the full backup taken on sunday <arcserve>?
Not supposed to work right?


thanks

Each time a full backup is taken the Differential_Base_LSN is incremented. Failure on thursday would require Wednesday 10pm full and Wednesday 11pm differential

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
chewychewy
chewychewy
SSC Veteran
SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)

Group: General Forum Members
Points: 238 Visits: 520
thanks.

So conclusion is regardless of whether the full backup is perform via sql maintenance plan to disk <option 1> or the tape <eg arcserve> sql agent, a marker will be set on the DB indicating a full backup has been performed. The differential backup will track changes after the last full backup <be it via sql maintenance or tape sql agent> right?

thanks
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19784 Visits: 17242
Unless arcserve is doing something different like snapshotting disk files.
Differential bitmaps are reset by a full backup in SQL server.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search