Restore trans log(s) from vss snapshot-based backuo

Question

Restore trans log(s) from vss snapshot-based backuo

124420294

Old Hand

Points: 344
More actions
November 4, 2016 at 3:33 am

#151479

Hi,
Is it possible to combine VSS snapshot-based backup with transaction log backups?
Traditionally,people do native full backups, and do more frequent differential and log backups that can then be applied to the full backup during recovery.
In other words, can I take a VSS snapshot, subsequently take a series of transaction log backups, and then during restore, apply those log backups to the snapshot?
Any reply will be appciate!
February 26, 2024 at 3:36 pm

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

124420294 (11/4/2016)
Hi,
Is it possible to combine VSS snapshot-based backup with transaction log backups?
Traditionally,people do native full backups, and do more frequent differential and log backups that can then be applied to the full backup during recovery.
In other words, can I take a VSS snapshot, subsequently take a series of transaction log backups, and then during restore, apply those log backups to the snapshot?
Any reply will be appciate!

No, volume shadow copy backups cannot be combined with SQL Server backups.

😎

124420294 Old Hand Points: 344 More actions · Answer 2

But from below microsoft official docuement, it seems that vss snapshot plus trans log restore is support.

https://technet.microsoft.com/en-us/library/cc966520.aspx

(Full restore with additional rollforwards)

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

124420294 (11/13/2016)
But from below microsoft official docuement, it seems that vss snapshot plus trans log restore is support.
https://technet.microsoft.com/en-us/library/cc966520.aspx
(Full restore with additional rollforwards)

The document you are referring to is an 11 years old "A Guide for SQL Server Backup Application Vendors"!

😎

What version of SQL Server are you using?

124420294 Old Hand Points: 344 More actions · Answer 4

sql server 2016.

if sql 2005 support transaction log roll forward, I think, it should be also supported for 2016.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

124420294 (11/14/2016)
sql server 2016.
if sql 2005 support transaction log roll forward, I think, it should be also supported for 2016.

A VSS file backup is not the same as an SQL Server backup using the VSS writer, what are you using for the backups?

😎

Walter Wildoer Newbie Points: 1 More actions · Answer 6

I agree that this should be possible. This very recent URL points to the function but doesn't explain how to use it:

It is a logical requirement in Azure: Snapshot a server and expect that if you have the logs outside of the VM (in a storage account), restore the VM and then apply the logs from the storage.

Otherwise I backup a VM to Recovery Vault with the database being 90% of the space used in that backup but can't roll forward if I restore the machine. I instead need a second backup of the database and the transaction logs, perhaps also in Recovery alongside the first which I am already paying for. The database server backup is already a costly part because of its size and I have to do it twice.