Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with log and delete
Message
From
08/04/2003 13:03:28
 
 
To
08/04/2003 12:58:04
Victor Chigne
Inteliventas
Peru
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00775148
Message ID:
00775155
Views:
18
No, you'll have to switch to Simple Recovery. If you're deleting all the rows in a table, you could use TRUNCATE TABLE, that command is logged minimally logged in SQL Server.

Roman

>Dear sirs:
>
>I have to delete at least 1 and a half million rows of one table in my data base, the problem is that my log file grows to much in the process. Is there a way to stop the log while the delete is going on?
>
>Thank you in advance
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729
Previous
Reply
Map
View

Click here to load this message in the networking platform