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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!