Help me combating this Error - SQL Server Forums

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

Replication (2005)

Help me combating this Error

Author

Topic

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-10-15 : 02:12:41

I am not able to understand the error thrown while deleting the subscriber at publisher.
The error is as follows :

The transaction log for database 'hotel' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-15 : 09:53:06

What does this command return?

SELECT	log_reuse_wait_desc
FROM	sys.databases
WHERE	name = 'hotel'

E 12°55'05.63"
N 56°04'39.26"

jaynichols
Starting Member

18 Posts

Posted - 2008-10-15 : 16:12:57

To empty the log: backup log hotel with truncate_only

Dirt biking forever!

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-10-16 : 01:15:19

LOG_BACKUP

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-10-16 : 01:17:23

SELECT log_reuse_wait_desc
FROM sys.databases
WHERE name = 'HOTEL'

Throws Result Sets

LOG_BACKUP

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2008-10-18 : 12:15:44

Take the log backup. Sometimes you need to take the two log backups to free up inactive logs.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources