[/quote]

That's pretty much the reason. If your backups and your database are on the same storage / server, what happens when the drive crashes, the server catches fire, someone...

jasona.work (10/17/2016)

---

homebrew01 (10/17/2016)

---

andrew gothard (10/17/2016)

---

Firstly, if you do your backup with the checksum option, this will identify various forms of potential corruption. Restore with verifyonly will also identify a...

First of all, DO NOT USE MAINTENANCE PLANS for any of this. Try what you find at the following URL

https://ola.hallengren.com/[/url][/quote]

ok Noted, thank you sir