Hi,

It might be the same as you describing. Thanks for support.

🙂

Regards,

Anurag Tripathi.

Hi,

Thanks for your continuous support.

I have recreated the Job and itis running fine as of now.

Regards,

Anurag Tripathi

Hi,

The above job is not for taking a Database backup. Infact, I have made one Maint plan which is having two steps:

1) First step execute the Rebuilt the all user...

Hi,

Job is crated by Database Maintenance plan.

Below is the box configuration:

Microsoft Windos 2003 with SP1,

MSSQL2005 Standard Edition with SP2

Please let me know if you are in need more info.

Regards,

Anurag

Hi,

You can use this script,It might have helped you.

From a command prompt, enter: sqlservr.exe -c -m for confirming that SQL Instance is in single user mode.

Then u can go through...