Thanks a lot Gail.

I tried detaching and attaching but got error while attaching

error:

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'xyz_1'. CREATE DATABASE is aborted.

Msg...

Unfortunately a junior DBA who got access to the server disabled the backup for some reason and forgot to enable....

yes I did run

alter database xyz_1 set online but the...

have some old backup not recent though

thanks.

Any more advice ?

Cheers

I agree with John.

I had to do it when one of my database was used for log shipping and later logshipping was disabled and forgot scheule log backup.. 1 Gb...

Thanks but I had to distribute backups on diffrent drives because of the space issue on single drive so I really cant select all the datbases to backup on the...

Thanks I have done that now will wait and see if job will be successful over the weekend

yes I did and there is enough space on the drive...

is there anyway I can calucate the space required for the reindex?

weekly

Thanks!

Thanks for that but

I am bit confused with which job to be set first or the order of the jobs for Reorganize Index, Database Integrity check, Update Statistics

I feel...

Thanks Muthukkumara,

I could figure out the reason for the job failure from the maintenance plan history as you adviced .The error is..

Executing the query "ALTER INDEX [PK_Act] ON [dbo].[_Act] REORGANIZE...

Thanks!

No I don't have any user tables in System db's.

I do take backup of system db everyday. But why can't we have Reorganize Index,Statistic checks?

Tnaks

I had already posted job history , posting it agin for your refrence...

Date06/11/2010 09:09:00

LogJob History (UserDB.ReorgIndexes)

Step ID1

ServerServername

Job NameUserDB.ReorgIndexes

Step NameReorgIndexes

Duration05:00:39

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

'Executed as user: abz\xyz....

Thank you everyone..

Finally my isue is resolved and there is absolutely no issues with disk space and log backup...

Thanks again!