Right now we use a standard Database Maintenance Plan to backup and organize our SQL server databases. However we are running out of disk space because every night it does a full backup of the databases and a few of the databases are quite large > 1 GByte.
Is there a way to perform differential backups daily and full backups once a week (or month) in conjunction with a Database Maintenance Plan? I know how to schedule jobs and perform differential and full backups on this kind of schedule for a single database.
But I'm worried that creating separate jobs for each database to handle the full backup, the differential backup, the backup of the transaction log, compacting the database, (etc) is going to become a nightmare to keep up with 50+ jobs.
I like the Database Maintenance Plan because i can go to one place and manage the backup, reorganization, compacting, etc of all of our databases at once and schedule just a few jobs.
What is the best way to maintain (and especially backup) 10+ databases of decent size?
Thanks in advance,
Shane Kunklecheck google. There are plenty of site containing SQL Server administration tips... (ex: sswug.org)
No comments:
Post a Comment