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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-08-03 : 02:17:22
|
| Hi One Database Server has Drive 500 gb of freeSpace.Suddenly one bulk operation Started in database server,it will run more than One Hour. This Bulk operation Will Take more than 500 gb Space.we couldn't stop the Bulk operation,As a DBA How Can manage this Problem.--Ragu |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-03 : 02:24:55
|
| Will it take 500 gb in the data file or the log file?If data, nothing you can do other than get more disk space.If log, you can change recovery model to simple or bulk-logged (though neither may solve your problem depending...) or you could do the inserts in smaller batches (say a few thousand MBs at a time).Also, is this a one-off, or an ongoing process? |
 |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-08-03 : 03:03:42
|
quote:
Originally posted by russell
Will it take 500 gb in the data file or the log file?If data, nothing you can do other than get more disk space.If log, you can change recovery model to simple or bulk-logged (though neither may solve your problem depending...) or you could do the inserts in smaller batches (say a few thousand MBs at a time).Also, is this a one-off, or an ongoing process?
Thanks Russell --Ragu |
|
|
|
jagdonru
Starting Member
3 Posts |
Posted - 2011-08-17 : 09:47:48
|
| have you tried adding more data file from another drive? |
|
|
|
|
|
|
Drive Space Problem