Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup not showing in schedule

Status
Not open for further replies.

tfstom

Programmer
Sep 28, 2002
190
US
I am using Sql Server7 and Windows NT.

I am try to do some testing and am trying to set up 3 backups: 1 full, 1 differential and 1 transaction log.

I set up the Full backup and it showed up fine in the Jobs window of EM.

I then have tried about 6 times to do the Differential and it seems to take file, but it never shows up in the Jobs window.

I am trying to set it up using "Northwind Database-Differential Backup" (I also tried "Northwind Database-Dif Backup") backing it up to the "Northwind_Differential" device. I set it up for "Database Differential", to run daily every 6 hours from 6:00 AM to 6:00:59 PM.

It seems to take it fine, but it never shows up on the Jobs window in EM.

Anyone know what I am doing wrong?

Thanks,

Tom.

 
We need a bit more detail.

You say that...I set it up for "Database Differential", to run daily every 6 hours from 6:00 AM to 6:00:59 PM.

Where did you do that?

Differentials are not covered in the database maintenance plans and their jobs must be manually created.

When you say... It seems to take fine... what form are you looking at in EM? (If you're using EM)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top