Sample Header Ad - 728x90

Database corruption on VM shutdown

1 vote
2 answers
552 views
We moved a SQL Server database to a virtual machine in Azure. Since the database only contains historical data and does not have transactions anymore we want to turn off and turn on the VM on a schedule to reduce costs. As far as I know database corruption can happen if the machine restarts in the middle of a transaction, so I have three questions about this: 1. Can database corruption happen in a database that does not have transaction anymore when the machine is shut down? 2. Is there a correct way to shut down the machine and avoid a corruption scenario? 3. Should we leave this machine running 7 x 24?
Asked by Andres Arango (195 rep)
Jul 7, 2021, 05:47 PM
Last activity: Feb 4, 2024, 04:50 PM