QuestionQ24Verified/Database Management and MaintenanceCopy linkReport a problemAsk AstroTutorSave questionWhich of the following scripts would configure the database recovery model for sys.database?ABCDShow AnswerAnswerExplanationSQL 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 moreALTER DATABASE SET Options (Transact-SQL)View or change the recovery model of a database (SQL Server)Show comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion