URGENT! Deleting Transaction Logs on SQL Server

[Juergs]

Our Project Server database transaction log file is growing at a tremedous
rate. It is about 36 gigs.

I noticed when I deleted the log file from Windows Explorer, that my SQL
Project Server wouldn't run.

I am new to this Admin junk and I'd appreciate any help.

Juergs

 

[Juergs]

I found this utility to shrink and backup transactional logs.

All my research suggested that this growth is normal and an Admin just needs
to add this step to their clean-up routine.

http://www.codeproject.com/database/ShrinkingSQLServerTransLo.asp

 

[John M.]

If your intent is to use the Simple recovery model, then all you need to do
is change the database option (right click on database, select properties, go
to options tab, select Simple for recovery model) and then perform a one-time
"shrink" of the database log file (right click on database, select All Tasks
- Shrink Database..., select OK). Under this recovery model, the transaction
log should no longer grow.

On the other hand, if your intent is to enable point-in-time recovery beyond
full/differential back-ups, then the size of the transaction log will depend
on the frequency of your transaction log back-ups (which could be scheduled
as part of a maintenance plan). The transaction log is truncated after each
back-up. The total size of both the current transaction log and the
backed-up transaction logs (hopefully not located on the same disk) should
reach a steady-state based on your rention period (four weeks?).

Hope this helps.

John M.