--Yes it is SQL server 2000(MSDE) instance and i know the in msde version database size is 2 GB

-- but after 1105 error database is inaccessible

-- and now I want...

thks gila for ur note

Thks

You mean that need to make 2 bat files one for stop service and another for start.

and schedule like that stop service and after 5 min start. Right....

I don't know exactly but its a client request to just automate to restart SQL services at 5:30AM