Trans log grows, grows, and won't schrink

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 2000 Forums

SQL Server Administration (2000)

Trans log grows, grows, and won't schrink

Author

Topic

wm
Starting Member

2 Posts

Posted - 2003-11-03 : 12:15:02

The trans log file grows, and won't schrink when I use schrinkdatabase or backup log with truncate_only.
It saids that some transaction are not replicated but this server is not use in replication at all.

Someone help me ?

chadmat
The Chadinator

1974 Posts

Posted - 2003-11-03 : 13:20:36

What version of SQL?

Try DBCC ShrinkFile, and make sure you spell "SHRINK" correctly.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-11-03 : 17:01:04

You can use the system stored procedure sp_helpreplicationdboption to see if SQL thinks any databases are enabled for replication (even if you don't). If the database shows up as enabled for replication and you are SURE it shouldn't be , you can use sp_removedbreplication 'database name' to remove it.

wm
Starting Member

2 Posts

Posted - 2003-11-04 : 08:55:24

Hi,

I use Sql2k advanced with sp3 and Log are saved every 30 minutes

sp_helpreplicationdboption returns this resultset:

name = gescom,
id = 1,
transpublish = 0,
mergepublish = 0,
dbowner = 1,
dbreadonly = 0

DBCC OPENTRAN return

oldest LSN distributed (0:0:0)
oldest LSN not distributed (90:6475:1)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources