InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 10:40:15 GMT20http://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspxUnless arcserve is doing something different like snapshotting disk files.Differential bitmaps are reset by a full backup in SQL server.Wed, 07 Nov 2012 23:38:29 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspxthanks.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?thanksWed, 07 Nov 2012 18:44:48 GMTchewychewyhttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspx[quote][b]chewychewy (11/7/2012)[/b][hr]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 - differentialSunday - FullIn 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[/quote]Each time a full backup is taken the Differential_Base_LSN is incremented. Failure on thursday would require Wednesday 10pm full and Wednesday 11pm differentialWed, 07 Nov 2012 04:25:23 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspxi had impression that there are two options [quote]I have a daily full db backup via SQL maintenance plan to file system at 10pm.[/quote]AND [quote]I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:Monday to Saturday - differentialSunday - Full[/quote]and thats the case then why there is duplicate backup for sunday Wed, 07 Nov 2012 04:02:57 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspx[quote][b]i think OP needs to go for sunday FULL and last diif backup taekn (whether on tuesday or wednesday)[/quote]will it work ?diff backup should be applied to its earliest full backup , which is Wednesday's full backup .Wed, 07 Nov 2012 03:55:10 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspx[quote][b]Bhuvnesh (11/7/2012)[/b][hr]@sanket why tuesday full back which is not there (for arcserve )see[quote]I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:Monday to Saturday - differentialSunday - Full[/quote] i think OP needs to go for sunday FULL and last diif backup taekn (whether on tuesday or wednesday)[/quote]I mean full backup taken on wed night (10 PM) using maintenance plan + differntial backup taken on wed night using arcserv (11 PM)Wed, 07 Nov 2012 03:36:58 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspx@sanket why tuesday full back which is not there (for arcserve )see[quote]I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:Monday to Saturday - differentialSunday - Full[/quote] i think OP needs to go for sunday FULL and last diif backup taekn (whether on tuesday or wednesday)Wed, 07 Nov 2012 03:31:22 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspx[quote][b]chewychewy (11/7/2012)[/b][hr]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 - differentialSunday - FullIn 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[/quote]No,then you need to restored full backup taken on wed night (10 PM) + differntial backup taken on wed night using arcserv (11 PM) .Wed, 07 Nov 2012 02:46:04 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1381848-391-1.aspxHi 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 - differentialSunday - FullIn 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?thanksWed, 07 Nov 2012 02:36:26 GMTchewychewy