yes i checked win log & sql error log but there is no error showing.

thanks

I really appreciate your nice conversation.

Thanks for your Comprehensive report.

shafiq.

did you disable in maintenance plan. if you did't disable, disable it from maintenance plan also.

Thanks for your quick response.

thanks for your nice response.

No,once a week full backup is executing.

Thanks for reply.

Shafiq

thanks for reply.

i did not try to uninstall from control panel, upgrade done on the same directory. successfully running both sql sever DB instance.now i want to remove sql server 2005.

thanks for...

Thanks for participation about Full & simple recovery mode.

regards.

shafiq

I know about Full Recovery Model & Simple Recovery model.

there are Five production DB Server. two 24/7 live production server contain one database each DB contain 35 tables. three...

thanks,

i just want to know must be production DB in Full Recovery. am right