SQL Server DB Backup

50 pts.
Tags:
Backup
backup database
SQL Server
SQL Server backup
Hello, I am a new member and would like assistance understanding why when I attempt to schedule a SQL Backup it doesn't seem to stick after I close and reopen it. I am doing the following: Windows Server 2003 – Enterprise Edition/SQL Vs. 8 1. SQL Enterprise Manager 2. SQL Server Group 3. Open the appropriate Group (i.e. Local, etc.) 4. Open Management folder 5. Right click Backup 6. Select “Backup database 7. Select DB to backup 8. Use default name 9. Add Description (i.e. HR Database backup, etc.) 10. Select “Database – complete” 11. Remove current Destination 12. Add a Destination 13. Set to Overwrite 14. Check “Schedule” box and click the ellipsis 15. Name the schedule (i.e. PROD1, etc.) 16. Check “Enable” 17. Set the schedule The problem is when I click ok to everything then reopen the backup everything is the same as it was originally (i.e. shedule did not change, default backup file name is the same, etc.). What am i not doing to make my backup save? Thank you. ilfoprog

Answer Wiki

Thanks. We'll let you know when a new response is added.

The backup window isn’t designed to show the already scheduled backups.

Open Management, then open Jobs. Each backup you scheduled will be there as a separate job.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following