QuestionQ24

VerifiedDatabase Management and Maintenance

Which of the following scripts would configure the database recovery model for sys.database?

Explanation

SQL Server changes a database recovery model through the ALTER DATABASE statement with the SET RECOVERY FULL option. UPDATE, TRUNCATE, and DROP DATABASE do not configure database recovery settings. Microsoft documents ALTER DATABASE ... SET RECOVERY FULL as the Transact-SQL method for changing a database recovery model.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!