View and modify scheduled Enterprise Manager SQL backup
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 problem?
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.
Any advice?
Thanks! "
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 problem?
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.
Any advice?
Thanks! "
ASKER
dtodd
Can you at least see what an existing backup is doing? I take it you cannot except analyze the exported results
Can you at least see what an existing backup is doing? I take it you cannot except analyze the exported results
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
As you have found, you can't alter an existing backup.
What you can do is
a) write the script and put this in a SQL Agent job to schedule it
b) use the maintenance plan wizard to backup databases, cleanup (remove) old backups, etc.
HTH
David