.Ldf and transactions

Can I create a database without an .ldf file
even if I use updates in transactionsAs far as I know, you cannot. DB has to have a transaction file. You can keep the size to a minimum if you set the recovery mode of the db to simple (if you don't care for recovery of the data).
Originally posted by Karolyn
Can I create a database without an .ldf file
even if I use updates in transactions|||that's what I tought,
thks|||The Holy book says :

Microsoft SQL Server 2000 maps a database using a set of operating-system files. All data and objects in the database, such as tables, stored procedures, triggers, and views, are stored within these operating-system files:

Primary
This file contains the startup information for the database and is used to store data. Every database has one primary data file.

Secondary
These files hold all of the data that does not fit in the primary data file. If the primary file can hold all of the data in the database, databases do not need to have secondary data files. Some databases may be large enough to need multiple secondary data files or to use secondary files on separate disk drives to spread data across multiple disks.

Transaction Log
These files hold the log information used to recover the database. There must be at least one log file for each database.|||There are certain transactions that ss2k has to manage like ddl commands and checkpoints. So you will always have a log file.|||If you are curious about what is kept in the log file you can use the dbcc log command.|||I've read in the Online Help
that exists a Virtual Transaction Log in SQL Server|||the transaction log file is made up of many virtual logs - SQL uses these to manage the usage, reusage, growth and shrinking of the transaction log file.|||thx all|||Originally posted by rnealejr
If you are curious about what is kept in the log file you can use the dbcc log command.

HI,

I AM REWIEVING THE FORUM SEEKING A HINT FOR OUR PROBLEM. OUR LOG FILE HAS DRAMATICLY INCREASED WITHIN FEW HOURS... IT HAS HAPPEND TWICE SO FAR.

I AM CURIOUS HOW CAN I REVIEW THE LOG FILE CONTENTS SO THAT TO LOCALISE THE SOURCE OF THAT SUDDEN GROWTH.

IS IT A GOOD WAY TO TRY DBCC? I TRIED TO FIND A PROPER COMMAND ON THE LIST IN BOOKS ONLINE, BUT I AM NOT SURE WHICH ONE I SHOULD USE.

THANKS IN ADVANCE FOR ANY HELP
JACK|||There is no command that I'm aware of that will tell you the SQL of the transactions held in the trans log. There are a few 3rd party tools about that claim to do it - although I have never used them.

There is a dbcc loginfo command which will tell which parts of the log file are active and which are not, although no more detail than that I'm afraid.

Hope this helps|||You can use

dbcc log ('dbname',type) where type is a number between 0-4 to get a general idea. However this will not show you the actual queries that were executed.|||THANKS!

Originally posted by dbabren
There is no command that I'm aware of that will tell you the SQL of the transactions held in the trans log. There are a few 3rd party tools about that claim to do it - although I have never used them.

There is a dbcc loginfo command which will tell which parts of the log file are active and which are not, although no more detail than that I'm afraid.

Hope this helps|||Thanks!

Do You know maybe where I can read more about the logic of each column extracted?

Thanks for futher hints in advance.

Jack

Originally posted by Enigma
You can use

dbcc log ('dbname',type) where type is a number between 0-4 to get a general idea. However this will not show you the actual queries that were executed.|||Do You remember maybe any of those companies www pages?

Thanks a lot in advance.
Jack

Originally posted by dbabren
There is no command that I'm aware of that will tell you the SQL of the transactions held in the trans log. There are a few 3rd party tools about that claim to do it - although I have never used them.

There is a dbcc loginfo command which will tell which parts of the log file are active and which are not, although no more detail than that I'm afraid.

Hope this helps|||Search for Lumigent's Log Explorer at

www.lumigent.com

You can download a trial version of the product.

Originally posted by JackKaton
Do You remember maybe any of those companies www pages?

Thanks a lot in advance.
Jack|||We have recently purchased Diagnostic Manager from NetIq (risking like sounding like an advert!) - thay have a trans log reader in that tool - www.netiq.com. - you get a free 30 day trial!

Altern look on a site like http://www.sql-server-performance.com/ and there should be some links to 3rd party vendors|||Many Thx to all of YOU!

Originally posted by dbabren
We have recently purchased Diagnostic Manager from NetIq (risking like sounding like an advert!) - thay have a trans log reader in that tool - www.netiq.com. - you get a free 30 day trial!

Altern look on a site like http://www.sql-server-performance.com/ and there should be some links to 3rd party vendors|||When a log file suddenly becomes huge, it's usually caused by a transaction that hasn't been committed. Other trannies start piling up behind it too. Always a programmer error.|||It's been a while since I was deep into admin, but isn't there a way to store the database log totally in cache memory? The option was there for speed, though it decreased recoverability.

Then there would be no file on disk.

blindman|||Interesting, enlighten me , oh Grand Poobah blindman! :)|||I must be suffering from Triptophan withdrawal after all that Thanksgiving turkey and gravy.

I was thinking about the "tempdb in ram" option.

blindman