Find the Data Bases which can not be Backed up are some resons

hi all.,
How  can I find the Data Base which can't backed up for reasons
like Data Base is in the middle of the Restore  before
i start Backup Process .


Regards.,

Sri

This probably isn't the best method to use but via Enterprise Manager
under Management you can view the maintenance plan history for the
backup plan and look for the red X by the database name that indicates
a failure for the operation against that database.

You might try selecting directly from the
msdb.dbo. sysdbmaintplan_histo
ry table if your plan logs to the
database.

Otherwise there should be log files in the LOG directory.

HTH -- Mark D Powell --

Hii Mark.,

Thanks for ur reply .

Can I Get the DataBase which couldn't be backuped using  executing
Query or procedure  .

I am new to Db management , hence pardon me if any mistakes .

Regards.,

Sridhar

Mark D Powell  wrote:
> This probably isn't the best method to use but via Enterprise Manager
> under Management you can view the maintenance plan history for the
> backup plan and look for the red X by the database name that indicates
> a failure for the operation against that database.
>
> You might try selecting directly from the
> msdb.dbo. sysdbmaintplan_histo
ry table if your plan logs to the
> database.
>
> Otherwise there should be log files in the LOG directory.
>
> HTH -- Mark D Powell --