Declare @bkpType char(4)
SELECT CASE(DATEPART(dw, CURRENT_TIMESTAMP))
WHEN 1 THEN Set @bkpType = 'Full'   -- Sunday
ELSE Set @bkpType = 'Diff'
END

EXEC usp_BackupDB 
@bkpType

quote:

---

Originally posted by tkizer

I don't understand why you would have T-SQL do this. Schedule a differential backup in one job, and then have your full backup in another job. It doesn't make sense to do all of this coding when two jobs solves your problem plus is how everyone else handles this.

---

quote:

---

Is there a way to schedule a job Daily & not have it run on Sunday?

---

quote:

---

Or do you suggest that on Sunday I run the Full backup after the Differentail?

---

quote:

---

Originally posted by tkizer

quote:

---

Is there a way to schedule a job Daily & not have it run on Sunday?

---

Yes, you select the weekly option in the job schedule and select all days except Sunday.

quote:

---

Or do you suggest that on Sunday I run the Full backup after the Differentail?

---

No.

---