could be a third party backup tool. If the backup has never completed there would be no record in msdb.

whats the exact error?

any chance they do 'cold' server backups with sql services down, then you could restore the actual database files (to a DIFFERENT location)

soofy21 (4/19/2009)

---

Hi Krishna,

Yes, I have the required permission. I used my domain login and also I tried with my SQL Login. I have to transfer only few tables and not...

...and it comes with a voucher for 15% off the exam fee.

service packs in 2005 cannot be 'backed out'. You would have to uninstall\reinstall SQL.

If you find you need fixes post the cut off point of SP3, you would not need...

I'm not a big fan of multiple instances because to me there is an administration overhead, to me its one of those cases of just because you can do it...

you can go direct to SP3. I would only apply any post SP3 CU's if you are experiencing the problems they resolve.

thanks for feeding back.

found it....see this thread

http://www.sqlservercentral.com/Forums/Topic485250-357-1.aspx#bm485257

been a while since I did a cluster but if you use net stop cluster will failover rather than stop, you need to stop via cluster admin by offlining SQL

Also...

If the file does not exist who knows what may be missing as well. If this install has never run you have nothing to lose, I would uninstall\reinstall.

An error log should be created each time it tries to start, any further info in those?

check out application view in eventvwr as well.

sounds like it might not be able...

have you got any of the old errorlogs? They list the version number on startup.

Does not help you this time round but this is a prime example of why you...

In case the instruction to alter the database to simple mode is held in stored proc code somewhere (I've been the victim of similar things in third party apps) there...

became slow suddenly? has anything been changed? Ask this question twice if they say no, people have strange ideas about what does or doesn't constitute a change.

Hey Barry, your avatar...