Low Disk space

Question

Post reply

Low Disk space

gprbobby

Grasshopper

Points: 17
More actions
January 5, 2010 at 6:18 am

#136341

I need to run an insert query on a db which would insert millions of records in a table. The log file for the db is growing around 3GB and query gets cancelled due less disk space. The recovery model of the database is set to simple. Please advice me a possible way to execute the query.
Thanks,
Purushotham

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

You could try excuting in smaller transactions/batches allowing the log to be recycled and not use all the space.

Gethyn Elliswww.gethynellis.com

mohd.sql Old Hand Points: 384 More actions · Answer 2

hi friends,

getting the following error try to help me out...

kindly check E: of server 10.16.167.46 as it has low disk space and it's below threshold value.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

gprbobby (1/5/2010)
I need to run an insert query on a db which would insert millions of records in a table. The log file for the db is growing around 3GB and query gets cancelled due less disk space. The recovery model of the database is set to simple. Please advice me a possible way to execute the query.

You can insert data into chunks , same as shown in link ( this link is for delete , you can use same logic for INSERT ) http://www.sqlservercentral.com/articles/Top/63301/

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

mohd.sql (9/15/2010)
hi friends,
getting the following error try to help me out...
kindly check E: of server 10.16.167.46 as it has low disk space and it's below threshold value.

1) Find & delete or move files that are not needed

2) Find cause of low space

3) Add more disk space

4) Don't hijack threads, especially old ones.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

1. Try to move some unnecessary files from the disk if any to another disk.

2. Break the large transaction into multiple smaller transactions.

3. If the transaction is doing bulk inserts, switch to the Bulk Logged recovery model.

Thank you,

Best Regards,

SQLBuddy