We help IT Professionals succeed at work.

fault SQL backup files that wont restore - how common

223 Views
Last Modified: 2017-03-24
Have you ever had situations where a backup of a SQL database would not restore, and if so what kinds of issues can mean a SQL backup cannot restore into a live or test instance. we are reviewing how well our DBA's test restores, so it would be useful to identify how common it is to find that a MSSQL backup file doesn't restore and how routinely a test restore should be performed for critical database backups. For infor these are all 2008 R2 databases.
Comment
Watch Question

John TsioumprisIT Supervisor
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Steve WalesSenior Database Administrator
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION