SQLSERVER saves deleted data at a certain point in time Reprinted from: to save deleted data at a certain point in time, you need to have a complete database backup before that point in time. In addition, your database recovery mode is required: full recovery mode how to view your database recovery mode to full recovery mode, run the following SQL1SELECTrecover
SQLSERVER saves deleted data at a certain point in time Reprinted from: to save deleted data at a certain point in time, you need to have a complete database backup before that point in time. In addition, your database recovery mode is required: full recovery mode how to view your database recovery mode to full recovery mode, run the following SQL 1 SELECT recover
SQLSERVER saves data deleted by mistake at a certain time point
Reprinted from:
To save data deleted by mistake at a certain time point, Hong Kong Space requires you to have a full database backup before that time point.
In addition, for a Hong Kong Vm, your database recovery mode is: "full recovery mode"
How to check whether your database recovery mode is full recovery mode, Hong Kong virtual host, run the following SQL
1 SELECT recovery_model, recovery_model_desc2 FROM sys. databases