patternMinor
SQL server 2005 backup statistic
Viewed 0 times
sqlstatistic2005serverbackup
Problem
I'd like to share with you this simple snippet (answering my own question) and I'm also curious how do you control your SQL server backups.
Solution
One of the slickest ways I've seen to control backups is Ola Hallengren's free maintenance script solution:
http://ola.hallengren.com/
It's installed as a series of stored procs in Master that do all kinds of nifty utility tasks. It'll automatically handle newly added databases, leverages third party backup compression tools, and does index rebuilds/defrags too.
http://ola.hallengren.com/
It's installed as a series of stored procs in Master that do all kinds of nifty utility tasks. It'll automatically handle newly added databases, leverages third party backup compression tools, and does index rebuilds/defrags too.
Context
StackExchange Database Administrators Q#1438, answer score: 6
Revisions (0)
No revisions yet.