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

differential backup question Expand / Collapse
Author
Message
Posted Wednesday, November 07, 2012 2:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:38 AM
Points: 91, Visits: 391
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
Post #1381848
Posted Wednesday, November 07, 2012 2:46 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 01, 2013 10:17 AM
Points: 323, Visits: 984
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) .



-----------------------------------------------------------------------------
संकेत कोकणे
Post #1381852
Posted Wednesday, November 07, 2012 3:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
@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
Post #1381869
Posted Wednesday, November 07, 2012 3:36 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 01, 2013 10:17 AM
Points: 323, Visits: 984
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)


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1381886
Posted Wednesday, November 07, 2012 3:55 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 01, 2013 10:17 AM
Points: 323, Visits: 984
[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 .


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1381894
Posted Wednesday, November 07, 2012 4:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1381896
Posted Wednesday, November 07, 2012 4:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:51 AM
Points: 5,958, Visits: 12,839
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"
Post #1381906
Posted Wednesday, November 07, 2012 6:44 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:38 AM
Points: 91, Visits: 391
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
Post #1382231
Posted Wednesday, November 07, 2012 11:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:51 AM
Points: 5,958, Visits: 12,839
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"
Post #1382271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse