SQL Server DB size Question

This is how it work

.mdf is the actual database file

.ldf is the transaction log file.

The transaction log file store all the transaction since the last checkpoint. In case you need to roll back the database when a disaster strikes, the system will use the transaction log to undo the database change.

You can configure your database to truncate the log file at any interval you want.

For our MS SQL service. We do not limit the transaction log size and we truncate your log every day.

You'll only pay for the mdf size

Hope this helps.

quote:Originally posted by bdwest

I just upgraded my account so I could experiment with a SQL server database. I have really no SQL server experience. I took an existing Access DB and used the upsize wizard from within Access. The original Access DB was 11 mb. The Sql server .mdf file is 24 mb and the .ldf file is a whopping 168 mb. This seems crazy. I understand I need both the .mdf and .ldf files. I really don't want to pay for 200mb of SQL server storage for a 11mb access database. Is this just the nature of SQL server databases. Can you reduce the size of the .ldf file.

I am running the SQL server 2000 desktop engine sp3.

Thanks
</blockquote id="quote"></font id="quote">