In sql server 2005 enterprise edition you have the option for generating reports.If ur using sql express 2005 then upgrade to sql server 2005 express with advanced services ,this advanced...

Mike

Thanks for that tip....

Issue check point that will commit the uncommited transactions.

Backup the databse will do the same.

dbcc shrinkfile('log file path',size)....

If all these are not working then

take a full backup,change the recovery...

Definitely u can choose other locations..Not only in other folders u can also give ur mdf and ldf in other drive also...Alll ur mdf and ldf files are safe even...

The best third party tools is DBARTISIAN.It will definitely help u in all aspects .

Restore Last Full Backup with no recovery

then restore last differential backup with norecovery

finally restore log backup with recovery

There is an option 'NEW QUERY' option in management studio ..use that

check this http://www.exforsys.com/tutorials/sql-server-2005/sql-server-2005-architecture-overview.html

If ur recovery model is SIMPLE then u cant take transaction log backups.Try dbcc shrinkfile(log_name,size)

Check ur CPU usage also check any other jobs or tasks are running at the same time.The issue can also be due to low disk space.