Posted by Erland Sommarskog on 01/27/07 20:53

rsyring@gmail.com (rsyring@gmail.com) writes:
> I have a TSQL script that restores a production database to my local
> development machine. Every time I do a restore, I have to go into
> Enterprise Manager and set the recover model to simple to prevent
> Windows XP Backup from having shadow copy problems (that is a rant in
> and of itself). I would like to just add a statement at the bottom of
> the script to do this, but have yet to find the proper commands
> documented. It seems that the instructions that come with the server
> only mention enterprise manager.

ALTER DATABASE db SET RECOVERY SIMPLE


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: backup/restore of Tables ONLY (please)
• Prev in forum: Re: Specified SQL server not found. [SQLSTATE 42000]
• Thread view: Re: Setting recover model with TSQL

[Reply to this message]