Shrinking SSEE Transaction Logs

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Shrinking SSEE Transaction Logs

Author

Topic

domo
Starting Member

23 Posts

Posted - 2008-03-25 : 05:58:04

I'm using SSEE as part of SharePoint 2003. The transaction logs are growing rapidly but don't appear to clear down.

As its SSEE I've been so far unable to connect using Management Studio or Enterprise Manager, so using DBCC Shrinkfile isn't an option.

Can someone please help? I'm surprised that when installing SP I didn't get the option to choose a db type or location.

domo
Starting Member

23 Posts

Posted - 2008-03-25 : 07:11:31

Okay - I've managed to connect using Management Studio.

I'm using the following in a (failing) attempt to reduce the transaction logs.

use master
go
backup log "WSS_Content_xxxxxxxxxxxxxxxxxxxxxxx" with truncate_only
use "WSS_Content_xxxxxxxxxxxxxxxxxxxxxxx"
go
DBCC SHRINKFILE ('WSS_Content_xxxxxxxxxxxxxxxxxxxxxxx_log.LDF',1)
go

Syntax appears okay but the following error is returned:

Msg 8985, Level 16, State 1, Line 1
Could not locate file 'WSS_Content_xxxxxxxxxxxxxxxxxxxxxxx_log.LDF' for database 'WSS_Content_xxxxxxxxxxxxxxxxxxxxxxx'.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-25 : 23:42:49

Have to use logical file name there. By the way, you should set job to do log backup if the db is not in simple recovery mode.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources