How to schedule a backup in SQL 7.0

[harrisonj]

List,

I'm trying to schedule an automatic backup for a database (create a "filename.bak") using SQL 7.0. I want it to overwrite the "filename.bak" every night. The problem I have is, after I enter in all my schedule info, close the Enterprize manager, and re-open it, all my schedule info is gone. Additionally, if I schedule a backup to be ran in let's say 5 min from now, and not close Enterprize manager, it still does nothing. The only way I can create my filename.bak is buy running it myself without "scheduling" it.

Here are my steps:
1. Lanuch Enterprize Manager.
2. Expand SQL Server Group.
3. Expand Server
4. Expand Databases
5. Right click on my database name and select "All Tasks" then "Backup database"
6. The Database: is selected from the pulldown.
7. I give it a name.
8. I select "Database-complete".
9. I browse to where I want the filename.bak written. c:\mssql7\backup\filename.bak
10. Select "Overwrite existing media"
11. Click on "Schedule"
12. Open up schedule properties.
13. Select "Recurring"
14. Click on [change]
15. Select "Daily".
16. Check Mon-Tue-Wed-Thu-Fri.
17. Select "Occure once at".
18. Enter in Start date as the current date.
19. Check "No end date".
20. [ok]
21. In the Edit schedule box, "Enabled" is checked.
22. [ok][ok]

What am I doing wrong?

Thanks in advance,
Harrison

 

[JayKusch]

Try looking in Enterprise Manager..SQL Server Agent..Management..Jobs. I there you "should" find a job referencing your backup job. In the job, you should see you backup schedule set.

The behavior you are seeing is expected. The date range will not be set as you have set it in the past since SQL Server thinks this is a new backup operation ... which when invoking the task ... it is.

Thanks

J. Kusch

 

[harrisonj]

J. Kusch,

Thanks, that worked!

---Harrison

 

[Iknowit101]

HUH? so what did you do to fix it? I am new to this and I do not get it. . . .
Did You changed the dates?? and if so, where did you changed them?
I am having the exact same Issues and haven't been able to solve it, our Network admin is gone and I have inherited this w/o any knowledge of SQL, appreciate your help.

It wasn't me, it was someone that looks a lot like me . . . .

 

[JayKusch]

OK ...

Open Enterprise Manager(EM). drill down to SQL Server Agent..Management..Jobs.

In there you "should" find a job referencing your backup job. In the job, open the "Schedule" tab. In this tab, you are able to set the backup schedule for this job.



Thanks

J. Kusch

 

[Iknowit101]

Thank You for your prompt reply, I did check the schedule tab on the job and find out all the jobs that I submited trying to "automate it", everything seems to be find there (recurring job,no end date) and even check the job to write to te event viewer when the job completes but still doesn run automatically.
What else can it be stoping the scheduled jobs from running?
Can it be a permisions Issues? I know we changed the admin password after the guy left, so just a thought . . .
Any more sugestions? Any white papers on this?
Appreciate your help in advance.




It wasn't me, it was someone that looks a lot like me . . . .

 

[JayKusch]

Simple one first ... Is SQL Server Agent running?

If so, try firing off the job manually and look in the job history by right clicking the job and choosing "view job history". Maybe there is something in there that may help us.

Thanks

J. Kusch

 

[Iknowit101]

YES!! You guys rock! That was it, the SQL Server Agent wasn't running, I started it and viola, it works.
Thank you, Thank you, Thank you.
Now that this is working properly I have one more question though, what exactly do I need to Back up? If I look on the DB's there are a few of them, Do I need to back them all up? Is there a way to backup everything I need ??

I got to make sure that I am backing up what I need in case of disaster.

It wasn't me, it was someone that looks a lot like me . . . .