|
Home > Archive > Microsoft SQL Server forum > October 2005 > Find the Data Bases which can not be Backed up are some resons
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Find the Data Bases which can not be Backed up are some resons
|
|
| duraisridhar@gmail.com 2005-10-27, 9:25 am |
| 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
| |
| Mark D Powell 2005-10-27, 5:28 pm |
| 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 --
| |
| duraisridhar@gmail.com 2005-10-29, 7:23 am |
| 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 --
|
|
|
|
|