Sanjay,

It could be your reporting/SSMS component has an open connection to the database therefore when restoring the log file it is unable to obtain an exclusive connection to the database...