Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tigpot
Starting Member
6 Posts |
 Posted - 2009-06-01 : 09:20:02
|
| I have two jobs set up in the maint. plan section, one for full backups and one for incremental. I run them both via the sql agent and have them scheduled. The full runs once a week, the incremental every night. This was working for months, now all of a sudden it fails telling me that it can't find the full backup.I have the full backups in a different folder than the incremental, but they were always that way. I built a SP to do the backups instead of the maint. plan, and it works - sort of. My full backup runs on Friday night, and the incremental runs on Saturday, but then fails on Sunday. I have been all over trying to figure out why this is failing now, and I can't come up with anything. Any suggestions? Thanks in advance for any help. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2009-06-01 : 20:16:36
|
| You'll need to post the actual error messages and the code you've written otherwise folks here will be wildly guessing. |
 |
|
|
lightsql
Starting Member
17 Posts |
Posted - 2009-06-02 : 01:32:20
|
| Do you mean to say that after incremental backup failed, no other backups succeeded? Also there is no incremental backup in SQL jobs just differential backup and it requires a full backup. The backup file doesnt have to be on the same location so dont bother yourself with those. Try restarting your full db backup and then proceed with the differential backup. |
|
|
|
|
|
|
backup failing suddenly