Please Fix it problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Please Fix it problem

Author

Topic

kishore.1002
Starting Member

2 Posts

Posted - 2011-04-28 : 11:45:42

Hi,

I have a table in a database, i have to delete some rows in that table without increasing the Log file.

How can I resolve this issue, Please help me.

kishore

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-28 : 12:29:27

Delete in small batches, such as 500-1000 rows at a time. Loop until you are done.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources