Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with log and delete
Message
De
08/04/2003 13:03:28
 
 
À
08/04/2003 12:58:04
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00775148
Message ID:
00775155
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform