Friday, February 24, 2012

Change SQL Server Recovery Model Simple To Full

I would like to change the SQL Server 2000 database recovery model from
simple to full.
I need to executing a log backup immediately before the change permits
recovery to that point. After switching to the simple model, stop executing
log backups.
This log backup is required by the application.
Please help me create T-SQL to backup the log before and after changing the
recovery model from simple to full.
Thank YouCheck sql book online, there are some good examples
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:0989F351-4D39-4E11-8B57-FBF82AF5B681@.microsoft.com...
> I would like to change the SQL Server 2000 database recovery model from
> simple to full.
> I need to executing a log backup immediately before the change permits
> recovery to that point. After switching to the simple model, stop
executing
> log backups.
> This log backup is required by the application.
> Please help me create T-SQL to backup the log before and after changing
the
> recovery model from simple to full.
> Thank You
>

No comments:

Post a Comment