log file too full - 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

General SQL Server Forums

New to SQL Server Administration

log file too full

Author

Topic

dtrivedi
Posting Yak Master

153 Posts

Posted - 2011-05-19 : 08:13:41

my boss emailed me saying a databases log file is full. He didn't give me anymore direction then that ?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-19 : 08:29:54

This is fairly old but should give you the idea
http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-19 : 08:40:16

These may be worth a read too
[url]http://www.sqlservercentral.com/articles/64582/[/url]
http://www.sqlservercentral.com/articles/Transaction+Log/72488/

--
Gail Shaw
SQL Server MVP

dtrivedi
Posting Yak Master

153 Posts

Posted - 2011-05-19 : 13:31:25

great tahnks where do i find the log file name?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-19 : 13:45:49

The error log will tell you which database is having the problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-05-20 : 01:57:40

use [database name]
go

select type_desc,name,size*8 KB,max_size from sys.database_files
where type_desc = 'LOG'

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources