• Actually I dont know. this job is automated my Windows team 2 years ago and in the production there are morethan 50 jobs are running on 24*7 basis. Moreover, production Database didn't get any problem with restarting services coz at that time .mdf and .ldf file are in minimal size. when i got this problem i checked the database and log file log size is 170 gb. what i came to know that Database will be in recovery mode still it has to recover 170 GB of data.