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.
Author |
Topic |
Oliver wang
Yak Posting Veteran
50 Posts |
Posted - 2014-02-24 : 13:12:35
|
Hi Everyone,I got a SQL2k5 instance(clustering). One Database was becoming bigger and bigger(110GB) and on shared disk I got only 10GB. Shrinking is not a perfect option for me because increasing transaction data will eventually eat up the disk all the way. So I tried a buit-in Stored Procedure which can delete old data from a big table(80GB) but the problem was the transaction log increased very fast accordingly and before the stored procedure finished the log file already depleted the remaining disk and the DB was down. I don't have any other available disk. Could you please help me? Thank you very much.regards,Oliver |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-02-24 : 13:20:01
|
Delete your data in smaller chunks so that the VLFs of your log file can be reused. Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|