It is going to be for finacial system reporting and with 4CPU ,8GB RAM and 100GB disk.My company's turnover is huge I am suspecting this Virtual Machine...

Thanks a lot guys ,will have my Storage team look into the issue

Thanks Pardeep..but this is happening every now and then Microsoft confirmed it's hardware issue so we built a new server with new SAN but still no luck 🙁

Thanks a lot everyone!

Thanks a ton Leo for the detailed explanation.

The old server is on cluster and now company has decided to go ahead with standalone server...

I agree with the risk involved copying...

thanks a lot guys,these articles are of great help.

I am looking for log at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG

no entries for the whole day the last entry I could see was yesterday morning at 7.05 am but log backup...

Thanks Pradeep

Thanks but if the SQL server is not configured for the memory then it will end up utilizing all the available memory without leaving anything to Operating System?

Thanks a lot for your inputs

Actually on UAT server one db was offline and other was suspect while posting I didn't mention about two db's just mentioned about the status sorry about that .

Thanks...

Thanks Gail.

I could restore the database from the backup.

Could you tell me how can I check for the I/O errors?

thanks a lot Adam.

The database was restored with trailing space we renamed it and log backups are fine now.

Thanks a ton!

Yes the db is TestManager and maintenance plan does create a subfolder for log backup as 'TestManager'

The same path is working fine for other two database log backup.

but only for...

Thank you very much all!

Finally I have restored the databases from some old backups and able to resolve the issue. The server is internal production server so we manage to...