How to clear trancation log memory

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

General SQL Server Forums

New to SQL Server Administration

How to clear trancation log memory

Author

Topic

manojKumar
Starting Member

4 Posts

Posted - 2010-09-08 : 04:58:19

Hi guys,
Im a fresher and new to this sql administration

I want to clear the log file memory of a database . At present it completes it maximum size limit of 2 Mb.

I tried to clear it by taking a transaction log backup, but the size remains same..

please show me solution ..

Thanks, in advance
Manoj

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-08 : 06:14:19

Log backups won't change the size of the file. It just makes the space in the file reusable.
Take a look through this article - [url]http://www.sqlservercentral.com/articles/64582/[/url]

--
Gail Shaw
SQL Server MVP

manojKumar
Starting Member

4 Posts

Posted - 2010-09-08 : 07:16:34

Hi Shaw,
thanks for the nice link,its very helpful for me. But didnt tell any thing about freeing up the memory of log file.
Is it possible to free up the memory of the log file ?

Regards
Manoj

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-08 : 07:19:53

Log files don't have a memory. I don't understand what you're asking.

--
Gail Shaw
SQL Server MVP

manojKumar
Starting Member

4 Posts

Posted - 2010-09-08 : 08:18:47

im using this query to see the memory of log file (i.e., .ldf file)

select file_id,type,type_desc,name,size,max_size
from sys.database_files

1 0 ROWS manoj 43008 -1
2 1 LOG manoj_log 1817448 268435456

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-08 : 08:33:34

Log files do not have a memory.

That query shows the type, name, size and maximum size of the files. What about the type, name, size and maximum size of those files is concerning you?

--
Gail Shaw
SQL Server MVP

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 2010-09-10 : 06:42:11

Hmmmm, I'm pretty unclear about what he's after too, but maybe he's talking about reducing the size of the file?? Manoj, try issuing a DBCC Shrinkfile on the ldf.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-10 : 07:28:24

Except that shrinking a log file is a very bad idea for a number of reasons.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources