I need a script that I can change the SQL Server 2000
database from Recovery Model: Full to Simple.
Please help me with this task?
Danalter database FOO set recovery simple
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:17ea901c449a8$fffd24d0$a501280a@.phx
.gbl...
> I need a script that I can change the SQL Server 2000
> database from Recovery Model: Full to Simple.
> Please help me with this task?
> Dan|||alter database [your database] set recovery full
Eric Li
SQL DBA
MCDBA
Dan wrote:
> I need a script that I can change the SQL Server 2000
> database from Recovery Model: Full to Simple.
> Please help me with this task?
> Dan|||Oops, should be set recovery simple
Eric Li
SQL DBA
MCDBA
Eric.Li wrote:
> alter database [your database] set recovery full
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment