Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL data - - .mdf
Message
From
17/10/2001 18:43:09
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00569358
Message ID:
00569962
Views:
16
>>>Take a look at TRUNCATE LOG in SQL Server Help.
>>>
>>>>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.
>>
>>AFAIK truncating the log will affect the LDF file, not the MDF. Also is TRUNCATE LOG a SQL Server 2000 command? There is no such command in SQL7.
>
>You are right, it will only affect the LDF file.
>
>The command to truncate the Log file exists in SQL 7 as well. Yet, I don't remember the exact name :( - I always used it from the Enterprise Manager. I haven't check SQL 2000.

The command to truncate the log in SQL7 is BACKUP LOG myDatabaseName WITH TRUNCATE_ONLY, haven't tried it but it should work on SQL2000 too.

As you have noticed already, it is easier to do it through the EM, unless you have to do it on a schedule.
Previous
Reply
Map
View

Click here to load this message in the networking platform