Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I noticed that a newly imported database on SQLServer 2005 had configured itself (without my knowledge) to perform daily backups; but it's not deleting old files and quickly filling up the disk.

I don't know how the backup job got configured (maybe that's something that gets transferred when you move a database?) but I'm having trouble modifying it.

The backup runs as part of SQL Server Agent job called "Daily Backups". This job runs a package called "(SSIS Packages)\Maintenance Plans\Backup Plan" -- which I can't find. The "Management\Maintenance Plans" area for my server is empty.

I imagine I could delete the existing plan and re-create it manually, but I was hoping to just modify what was already there, since all that's missing is deleting old files.

share|improve this question
add comment

3 Answers

up vote 1 down vote accepted

the plan would have been on the server already. Did you restore MSDB? this would be the only case when the backup job would be moved to a new server, as msdb is the store for sql server agent jobs.

share|improve this answer
add comment

Just create new task (with Maintenance Cleanup task) to delete old backups/logs and set schedule appropriate time (e.g after your backup is finished)

share|improve this answer
add comment

How did you import it? I have never had a database import (attach, backup restore) add a maintenance plan. Never. Now, that said - it could possibly try to do that once the db starts using a stored procedure.

share|improve this answer
    
I know. Weird. Imported using backup-restore mechanics. That's why I assumed it's a "default" thing. –  tylerl Mar 21 '10 at 9:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.