<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
differential backup question
differential backup question
Rate Topic
Display Mode
Topic Options
Author
Message
chewychewy
chewychewy
Posted Wednesday, November 07, 2012 2:36 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:54 AM
Points: 80,
Visits: 312
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
sanket kokane
sanket kokane
Posted Wednesday, November 07, 2012 2:46 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 11:12 PM
Points: 323,
Visits: 973
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
Bhuvnesh
Bhuvnesh
Posted Wednesday, November 07, 2012 3:31 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562,
Visits: 3,453
@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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #1381869
sanket kokane
sanket kokane
Posted Wednesday, November 07, 2012 3:36 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 11:12 PM
Points: 323,
Visits: 973
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
sanket kokane
sanket kokane
Posted Wednesday, November 07, 2012 3:55 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 11:12 PM
Points: 323,
Visits: 973
[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
Bhuvnesh
Bhuvnesh
Posted Wednesday, November 07, 2012 4:02 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562,
Visits: 3,453
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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #1381896
Perry Whittle
Perry Whittle
Posted Wednesday, November 07, 2012 4:25 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 5,244,
Visits: 11,264
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
chewychewy
chewychewy
Posted Wednesday, November 07, 2012 6:44 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:54 AM
Points: 80,
Visits: 312
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
Perry Whittle
Perry Whittle
Posted Wednesday, November 07, 2012 11:38 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 5,244,
Visits: 11,264
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
