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 |
|
omkar.k28
Starting Member
8 Posts |
 Posted - 2012-01-19 : 08:03:07
|
| Hi all,I am running the sp ,this will inserting the records into one table,due to large data the database getting full ,there is no space for that table ,how to resolve this issue ?give me suggestion on thisWarm RegardsOmkar |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-01-19 : 10:01:55
|
| Have you got Autogrow enabled?----------------------------Junior DBA learning the ropes |
 |
|
|
omkar.k28
Starting Member
8 Posts |
Posted - 2012-01-20 : 01:06:46
|
| The problem is the disk size is getting full.Warm RegardsOmkar |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-01-20 : 06:43:00
|
| Then you should move the database to a disk with more space if possible.You could also shrink the database but this isn't the ideal solution.----------------------------Junior DBA learning the ropes |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-20 : 09:15:59
|
quote:
Originally posted by chris_cs
You could also shrink the database but this isn't the ideal solution.
Can;t see how this would help, SQL will have reused whatever free space it can before extending the file (and discovering that the disk is already full)1) If the batch is a single monolithic HUGE transaction then it may be causing the LOG to expand excessively (compared to normal).2) If it is several smaller transaction then increasing the frequency that the LOG is backed up (e.g. every 2 minutes) may provide enough log space. (Thus (1) can be fixed  by converting the single monolithic transaction into numerous smaller ones as per (2) but then rollback and consistency of the database may be problematic. That's not a problem if it is done when users are not connected and the database can be Restored if the operation fails [i..e with part of the batch committed] for any reason.Bigger disks would be easier |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-01-20 : 11:35:00
|
| That is very true----------------------------Junior DBA learning the ropes |
|
|
|
omkar.k28
Starting Member
8 Posts |
Posted - 2012-01-23 : 05:59:27
|
| thank you for your repliesWarm RegardsOmkar |
|
|
|
|
|
|
How to reduce the data size while inserting