Comprehensive data protection for all workloads
Post Reply
Magvai
Lurker
Posts: 1
Liked: never
Joined: Jul 26, 2018 4:02 am
Full Name: Konstantin
Contact:

Backup VM MS SQL Server using AAP, but excluding database fi

Post by Magvai » Jul 27, 2018 10:10 am

Hello!

Situation:

I set up the Veeam task for the VM with MS SQL Server. In the task, I enabled AAP with transaction log processing in copy only mode, but in the file exceptions setting indicated that I want to exclude the VM directory that contains the database files. The job successfully worked, I restored the target VM from the backup, made sure that the excluded database is in the recovery recovery state (its files are missing). Next, I tried to restore this database from a backup VM using the Restore application item and got an error: failed to retrieve the security descriptor from "C: \ folder1 \ Volume1 \ SQL_DB \ datafile.mdf". The system can not find the file specified.

Questions:

1. Does Veeam back up the MS SQL Server database as DBMS does (by executing BACKUP DATABASE at the instance level)? Or is Veeam backing up the database at the level of the database files, just copying them, relying on VSS?

2. Why when I exclude database files from AAP processing I still see the database as available for recovery in Veeam Explorer for Microsoft SQL Server, but can not recover?

3. Are there any documents detailing the procedure for backing up the MS SQL Server database using Veeam?

PTide
Product Manager
Posts: 5364
Liked: 473 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup VM MS SQL Server using AAP, but excluding databas

Post by PTide » Jul 31, 2018 10:16 am

Hi,

1. Veeam puts the database in a consistent state using VSS, takes a snapshot, and the whole content of the snapshot (including the database) is copied into a backup file.

2. When you exclude a database it is skipped by VSSWRITER thus the database is in inconsistent state in a snapshot and cannot be recovered.

3. Yes, there are several of them:

- SQL Server Backup & Restore Strategies
- User Guide
- MSSQL backup Best Practices

Thanks

Post Reply

Who is online

Users browsing this forum: Google [Bot], Jan.Maue and 58 guests