Thursday, February 16, 2012

Change recovery model using TSQL

Id like to change the recovery models of my dbs to Full using TSQL. How can
I do so ? It seems possible using EM. But I wanted to try using TSQL..
ThanksTry;
alter database MyDB
set recovery full
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%2339YqjXDFHA.1392@.tk2msftngp13.phx.gbl...
Id like to change the recovery models of my dbs to Full using TSQL. How can
I do so ? It seems possible using EM. But I wanted to try using TSQL..
Thanks

No comments:

Post a Comment