Large Project Server 2003 log file. How to trim,delete, bring downProject Server 2003 and keep WSS

[anovak]

Hey, we've got an old unused Project Server 2003 implementation that
has a log file:

""E:\Data\ProjectServer_1487_log.ldf"."

And its getting so large that the disk is almost full. We aren't
using the app anymore, so is there anything wrong with just deleting
the log file (would another be created)? As a matter of fact, we
could probably just stop Project Server altogether.

We WILL need to keep WSS up because there are a few stand-alone sites
out there.

Could you give me some tips on the quickest way to unplug Project
Server, trim or delete the log file while keeping WSS going?

VERY MUCH APPRECIATED!

Andy Novak
UNT

 

[Project Server Slave]

Andy,

You can run a truncate query on the log to shrink it. I do not have
the query handy, but if you search around you should be able to find
it. You may want to reindex the MDF as well, if its large and/or
slow.

 

[Paul Conroy]

The command you're looking for is

backup log {databasename} with truncate_only

I'd strongly recommend a full bd\log backup before truncating the logs.
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com