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 |
|
archanasql
Starting Member
27 Posts |
 Posted - 2008-07-31 : 14:15:48
|
| HI ,backup Job is failing for couple of months and getting an errorFailed:(0) One or more selected databases no longer exist on serverWhen we saw the maintenance plan we observed that the databases are moved to another server.Please advice |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-31 : 14:22:17
|
| It is clear in error. |
 |
|
|
archanasql
Starting Member
27 Posts |
Posted - 2008-07-31 : 14:58:01
|
| How to resolve this error ?How do i remove the database from the maintenance plan which is causing error ? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-07-31 : 15:34:59
|
| Should be a start.In case any new ones have cropped up, you should probably add those in, as well. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-31 : 22:56:05
|
| Open maintenance plan in ssms and go to full backup subplan, edit it to uncheck removed db from list. |
|
|
|
|
|
|
SQL JOb Failing