Pau Lo
asked on
backup query configuration
I am not a SQL DBA but I presume when you setup a new database you also setup a job on how often to backup the database and where to write the backup to. Is there anyway for SQL 2005 to detail exactly what backup schedule is setup, and where the backup is being written to. A query would be useful so it can be done in bulk over several systems.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do you manually do backups then scott isnt that prone to human error ie forgetting?
Of course not. Who would do something as critical as backups manually? (Other than the IRS Exchange admins, I guess :-).)
ASKER
Can you elaborate on your backup procedures for sql then and why they are more effective then using maintenance plans?
ASKER
Or the problems with mps in general and why dbas dont use them
MPs are too generic and too broad. They're also error prone, particularly when you select specific db(s) to process. If one of the dbs is dropped or renamed, often the entire plan fails or, worse, simply skips the remaining dbs.
DBAs use procs/scripts to do backups and other maintenance tasks. Probably the best-known version is Ola Hallengren. I don't use them, because they are not table-driven, but many do.
DBAs use procs/scripts to do backups and other maintenance tasks. Probably the best-known version is Ola Hallengren. I don't use them, because they are not table-driven, but many do.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER