May 3, 2008 at 5:26 pm
HI
I RAN ONE DELETE COMMAND ON MY PROD DB AND ITS BEEN 4 HOURS QUERY IS RUNNING AND MY DB LOG SIZE IS CONTINOUSLY INCREASING.MY DRIVE SPACE IS STILL 600GB AND LOG SIZE IS 2.7 GB AS OF NOW..CAN ANYONE TELL ME WHILE RUNNING DML STATEMENT CAN WE SHRINK LOGS...FIRSTLY I DID BEGIN TRANSACTION AND THEN I RAN MY DELETE STATEMENT..AND TRANSACTIONS ARE STILL NOT COMMMITED.......KINDLY ADVICE..................
May 3, 2008 at 7:01 pm
Do you know how much data (rows -->GB) to delete? Deletion needs 2 times of the data size for the log. If you delete 10 GB data, 20 GB space will be used for log.
If you do not know how much data, check either the table size or db size (worst guess), and multiply 2 and see whether you have enough space for the log to grow.
If sp_who2 shows I/O still change, and you estimate space is enough. You can let it finish.
Anyway, deleting a large amount of data in one transaction is not a good option. Check this post.
http://www.sqlservercentral.com/Forums/Topic473776-146-1.aspx
May 4, 2008 at 1:22 pm
Thanks for the kind advise...:)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply