arcserve backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » arcserve backup

arcserve backup

Rate Topic

Display Mode

Topic Options

Author

Message

chewychewy

Posted Tuesday, January 15, 2013 5:12 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:15 AM
Points: 72, Visits: 286

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

Vedran Kesegic

Posted Tuesday, January 15, 2013 6:43 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:08 AM
Points: 342, Visits: 1,072

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.

_____________________________________________________
XDetails Addin - for SQL Developers and DBA
blog.sqlxdetails.com - Transaction log myths - debunked!

Post #1407540

chewychewy

Posted Tuesday, January 15, 2013 8:04 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:15 AM
Points: 72, Visits: 286

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