SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Disk is running out!!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Oliver wang
Yak Posting Veteran

China
50 Posts

Posted - 02/24/2014 :  13:12:35  Show Profile  Reply with Quote
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

Sweden
30277 Posts

Posted - 02/24/2014 :  13:20:01  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000