Posted by duraisridhar on 10/02/52 11:30

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_history table if your plan logs to the
> database.
>
> Otherwise there should be log files in the LOG directory.
>
> HTH -- Mark D Powell --

• Next in forum: Re: Record , Row number
• Prev in forum: Re: unique constraint to a column from another table
• Thread view: Re: Find the Data Bases which can not be Backed up are some resons

[Reply to this message]