View and modify scheduled Enterprise Manager SQL backup
Posted on 2008-10-22
Searching pointed me to this question, which was closed, and awarded points, but I don't see an answer.
Can someone please answer where you can view and modify an existing backup in Enterprise Manager?
"06.18.2008 at 03:30PM EDT, ID: 21816184
I am interested in this too.
I have SQL 2000, went into the Enterprise Manager, highlighted the one DB to backup, Tools, Options, Backup. I setup a full daily backup to a folder. Then my backup software will backup that folder. I set this to overwrite every day.
The built in SQL backup does not seem to let you alter a backup you created. As a matter of fact it doesn't seem to even acknowledge that you even made a backup schedule. Looking at Scheduled Tasks I see nothing there either stating a backup like you would with Windows backup.
Perhaps my server is messed up or is this by design? I won't know till tomorrow if my backups work, I guess I could schedule one to happen in the next 5 minutes but this sure seems strange.