General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi all:
>
> When I run a nightly batch, I notice in the SQLdata directory that an MDF file is created that records the logs of transactions that occur while my transaction was running. This MDF file can be very big. Is there a way that I can prevent this MDF from being created or is there no way to prevent it?
>
>Thank you.
Mahmood,
If you are talking about SQL Server, the MDF file is the database file itself. Usually anytime you create a database without any special options two files are created, one with an MDF extension and the other with an LDF extension. The second one is the log file. Obviously you don't want to tamper with the MDF file, the best you can do is to monitor the size and shrink it if necessary (or if possible) using the options in the SQL Enterprise Manager.
HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only