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 |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2007-05-24 : 07:23:04
|
| i have a job that is failing and in the log the error message is as follows[Microsoft][ODBC SQL Server Driver][SQL Server]This backup set cannot be restored because the database has not been rolled forward far enough. You must first restore all earlier logs before restoring this log.20i ahve checked on the internet and it tells me what the prob is but not how i can get it fixed |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 09:52:52
|
| Yo have to get all log backups and restore them in right order. |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2007-05-24 : 10:39:52
|
| Why do you have a job that's restoring a database?What is the purpose of the job?-------Moo. :) |
|
|
|
|
|
|
job wont run