Thank you very much Guys.

  All your suggestions work well.

  Robert

Hi Helen,

  Thanks very much.

The compatibility is 80. I got a wrong database name.

Anyway I know what is invalid input meaning.

  Robert  

close QA, go to EM run restore. The database will show single user.

Robert

Please send me one

Many thanks!

  Robert

Hi all,

  Our system admin called microsoft, he  was asked to

detach and reattach the database. It works. Is that easy?

  Thanks!

  Robert

Hi Allen,

  I run dbcc sqlperf(logspace)

The results shows the log file is there.

12 (dbname) 9.9921875 23.089327 0

Totally we have 13 databases including system databases.

 the one with problem is 12th.

Alzdba,

  This...

Yes, the database is accessable. I can query from EM.

Robert

Sorry I forgot to post the error message:

backup  backup failed to completethe command backup database (dbname) to disk (the share drive).......

spid60  The log for database (dbname) is not available.

spid60  Error:...

Thanks Allen. Yes, actually the drive hosts many database files, log files and even some backups. Only one database backup failed, but the transaction log backup is completed successfully. The...

Thanks for all reply.

We applied the latest sp which is sp3a.

The log file is on the drive which is under dependency.

I checked this article:

http://support.microsoft.com/default.aspx?kbid=828339

And I did dbcc checkdb....

This maybe a bug in sql, try this:         http://support.microsoft.com/default.aspx?scid=kb;EN-US;319701.

restore msdb from QA not from EM.

  Good luch. Thanks!

I think this is a good question, but answer can be changed to:

'at least one userdb set recovery mode to simple'.

In our practice, on our production server, normally we...

Maybe for recovery completion state you chose ...able to restore additional thansaction logs. So after ...completed successfully, waiting for you to restore transaction log.

If you don't have transaction log to...

I have many times for status = 112. It always shows that there

is not enough disk space on the backup device. You might check

your backup device space.

Robert

Sorry, hit the Enter, continue, import everything (all object and Data) from old server. I don't know is there any problem with this way? I think this is the simplist...