Which of the following statement is used for changing Recovery Model with T-SQL ?
A. ALTER DATABASE
B. ALTER TABLE
C. ALTER COLUMN
D. None of the mentioned
Answer:A
Which of the following statement is used for changing Recovery Model with T-SQL ?
A. ALTER DATABASE B. ALTER TABLE C. ALTER COLUMN D. None of the mentioned
Explanation:You can use ALTER DATABASE command with the SET RECOVERY option to change the recovery model of a database.