troubleshooting Question

fault SQL backup files that wont restore - how common

Avatar of Pau Lo
Pau Lo asked on
Microsoft SQL ServerDatabasesMongoDB
3 Comments3 Solutions229 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Vitor Montalvão
IT Engineer
Join our community to see this answer!
Unlock 3 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros