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

arcserve backup Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2013 5:12 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 7, 2014 12:29 AM
Points: 93, Visits: 407
Hi Guys,

Is the below achievable via arc serve?
Let's say currently I have the below backup strategy:

1. Daily full db backup to filesystem via SQL Maintenance Plan

2. Hourly db transaction logs backup to tape via arc serve.

When comes to restoration, can I just restore the transaction logs backup to file system? (without applying it)

Will need the transaction logs backup files on the filesystem to use it for point in time recovery with (1).

thanks
Post #1407521
Posted Tuesday, January 15, 2013 6:43 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 5:27 AM
Points: 369, Visits: 1,214
Never used that arc tool. For point-in-time restore (full recovery model) you need full backup + unbroken chain of all transaction log backups starting with the one that contains the moment when full backup finished to the transaction log backup containing the moment you want to restore to. You would benefit from including differential backups in your scheme, and adding compression and checksum options. Read about backups.

_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths
Post #1407540
Posted Tuesday, January 15, 2013 8:04 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 7, 2014 12:29 AM
Points: 93, Visits: 407
Hi,

thanks for ur advise.

When doing the below, i supposed the transaction logs chained are not broken as there's no full backup by arc serve.
1. Daily full db backup to filesystem via SQL Maintenance Plan
2. Hourly db transaction logs backup to tape via arc serve.

So i'm just curious with arc serve, is there an options to just restore the transaction logs backup to file system?
After that, I can use the transaction logs backup with the full backup via maintenance plan to perform point in time recovery?

thanks
Post #1407553
Posted Tuesday, January 15, 2013 9:04 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:22 PM
Points: 20,680, Visits: 32,279
chewychewy (1/15/2013)
Hi,

thanks for ur advise.

When doing the below, i supposed the transaction logs chained are not broken as there's no full backup by arc serve.
1. Daily full db backup to filesystem via SQL Maintenance Plan
2. Hourly db transaction logs backup to tape via arc serve.

So i'm just curious with arc serve, is there an options to just restore the transaction logs backup to file system?
After that, I can use the transaction logs backup with the full backup via maintenance plan to perform point in time recovery?

thanks


Full backups and differential backups do not break the log chain.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1407568
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse