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


differential backup question


differential backup question

Author
Message
chewychewy
chewychewy
Right there with Babe
Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)

Group: General Forum Members
Points: 730 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 Eights!
SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)

Group: General Forum Members
Points: 839 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
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13406 Visits: 4077
@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 Eights!
SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)

Group: General Forum Members
Points: 839 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 Eights!
SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)SSC Eights! (839 reputation)

Group: General Forum Members
Points: 839 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
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13406 Visits: 4077
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
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54657 Visits: 17693
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
Right there with Babe
Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)Right there with Babe (730 reputation)

Group: General Forum Members
Points: 730 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
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54657 Visits: 17693
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