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
Last activity: Feb 4, 2024, 04:50 PM