HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL server 2005 backup statistic

Submitted by: @import:stackexchange-dba··
0
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.

Context

StackExchange Database Administrators Q#1438, answer score: 6

Revisions (0)

No revisions yet.