Tag:SQL Server database recovery
-
Configure SQL Server database recovery mode (2 methods)
The following two methods of configuring SQL Server database recovery mode are mainly introduced. Setting recovery mode with T-SQL You can use it“ALTER DATABASE”Command plus“SET RECOVERY”Statement to modify the recovery mode of the database. For example, the following query statement sets the“AdventureWorks”The recovery mode of the database is set to full recovery mode. ALTER DATABASE […]