cancel
Showing results for 
Search instead for 
Did you mean: 

How to backup / restore SQL server with BE2012 SDR ?

William_Lawance
Level 6

Hi,

Some articles wrote data and SQL backup should be in different job.

I need to use SDR, is this means SQL need to backup for twice times?

Please advice.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

No.  You do not include SQL backups in your file backup job which you use for SDR restore.  You need to restore the SQL data in a separate job after you have recovered the server using SDR.  You cannot recover a SQL database using SDR.

Do read the SDR chapter in the Admin Guide for a better understanding of what SDR does before relying on it.

View solution in original post

1 REPLY 1

pkh
Moderator
Moderator
   VIP    Certified

No.  You do not include SQL backups in your file backup job which you use for SDR restore.  You need to restore the SQL data in a separate job after you have recovered the server using SDR.  You cannot recover a SQL database using SDR.

Do read the SDR chapter in the Admin Guide for a better understanding of what SDR does before relying on it.