Advice on Switching 7 Recovery Models

The databases I just took over are on SQL Server 7.0 with NO SQL Server Serv
ice Packs installed. Several application (not system) databases have FULL r
ecovery specified and several use SIMPLE. The manager wants to implement Fu
ll Recovery on all the appl
ication databases. He also does not want to install any service packs unles
s something is broken that a service pack will fix. Currently there is noth
ing broken.
I have read that the switch from SIMPLE to FULL Recovery is not as simple as
it appears. What are the implications? What makes it challenging? Can I
just remove the truncate on checkpoint option and chnage the database mainte
nance plans to start backin
g up tran logs?
Thanks for your insight.Hi,
(In SQL 7.0 there is no concept of recovery model)
So if you remove the "Truncate Log on checkpoint" option on database will
enable the logging. There is no impication in disabling this option, only
problem is you have to monitor the growth of transaction log file. The file
growth will be very high if you have any batch operations.
After disabling the Truncate log on checkpoint do,
1. Perform a Full database backup of database (After enabling this option
you have perform a full backup to recreate the backup chain)
2. After that change the database maintenance plan to perform a transaction
log backup
3. Weekly monitor the growth of Transaction log file, if the physical file
size is high then do a DBCC SHIRNKFILE (refer books online)
to shrink the physical file.
Thanks
Hari
MCDBA
"?" <anonymous@.discussions.microsoft.com> wrote in message
news:0EA95DE2-9AED-4F5B-ACCD-55E743371C21@.microsoft.com...
> The databases I just took over are on SQL Server 7.0 with NO SQL Server
Service Packs installed. Several application (not system) databases have
FULL recovery specified and several use SIMPLE. The manager wants to
implement Full Recovery on all the application databases. He also does not
want to install any service packs unless something is broken that a service
pack will fix. Currently there is nothing broken.
> I have read that the switch from SIMPLE to FULL Recovery is not as simple
as it appears. What are the implications? What makes it challenging? Can
I just remove the truncate on checkpoint option and chnage the database
maintenance plans to start backing up tran logs?
> Thanks for your insight.
>|||Thank you very much!