Recovery model setup using Tsql

hi,
i need to change my recovery model to SIMPLE but using TSQL and once
installationn is finished i need to revert back to FULL
can anyone Help.
--
SunnyHi
ALTER DATABASE test SET RECOVERY FULL
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:B1DD8BA0-1BE1-434C-9A12-6E3F043E1FE6@.microsoft.com...
> hi,
> i need to change my recovery model to SIMPLE but using TSQL and once
> installationn is finished i need to revert back to FULL
> can anyone Help.
> --
> Sunny|||ALTER DATABASE dbname SET RECOVERY SIMPLE
...
ALTER DATABASE dbname SET RECOVERY FULL
Note that transaction log backups now takes are useless (SQL Server should g
ive an error message but
it doesn't, fixed in 2005), until you first do a database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:B1DD8BA0-1BE1-434C-9A12-6E3F043E1FE6@.microsoft.com...
> hi,
> i need to change my recovery model to SIMPLE but using TSQL and once
> installationn is finished i need to revert back to FULL
> can anyone Help.
> --
> Sunnysql