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)
 Transaction Log

Author  Topic 

hydtohou
Starting Member

24 Posts

Posted - 2006-02-09 : 15:21:39
I wanted to shrink the Transaction Log file for a Database XXXX

I ran DBCC SHRINKFILE bit it says this

Cannot shrink log file 2 (XXXX_Log) because all logical log files are in use.


I just want to free up some space of a log file.

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2006-02-09 : 15:53:00
Have you tried BACKUP Log?

for more information
http://support.microsoft.com/?id=272318
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-02-09 : 15:56:23
ALTER DATABASE SET SINGLE_USER

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page
   

- Advertisement -