| Author |
Topic |
|
Gili
Starting Member
42 Posts |
 Posted - 2005-09-12 : 09:09:08
|
| does anybody familiar with this error msg "Not enough storage is available to complete this operation".??i have Sql Server 2000 sp3a and windows server 2003 standard edition.i search a lot about this issue and i did'nt found anything that can help me about it.i hope here i can find the solution.thanks.Gil. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 09:40:38
|
what kind of operation?maybe you don't have enough disk space?Go with the flow & have fun! Else fight the flow  |
 |
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-12 : 09:43:47
|
| i have left 70 GB so it's not space disk problem and i have 1.75 GB memory. |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-12 : 09:44:42
|
| 70 GB free space . |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 09:50:57
|
| and what is your operation?Go with the flow & have fun! Else fight the flow |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-12 : 14:54:25
|
| my operation is windows server 2003 standard edition,dual cpu,1.75 gb ram,sql server 2000 sp3a.i don't know what to do i check anything... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-12 : 14:56:40
|
| Gili,What are you doing when you get this error?Tara |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-13 : 01:56:48
|
| i recieve this error when i'm execute an dts. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-13 : 04:10:05
|
| does this error happens when you start the sql server's DTS application orwhen you execute a package in the DTS?Go with the flow & have fun! Else fight the flow |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-13 : 04:13:02
|
| it's happen when i execute a package in the DTS. |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-13 : 04:16:58
|
| it's happen when i execute a package in the DTS. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-13 : 04:43:37
|
| and what does this package do?Go with the flow & have fun! Else fight the flow |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-13 : 05:00:25
|
| This package Transfer Data From one database to another database.With Queries insert and update And lookups. |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-09-13 : 10:10:12
|
| well here is some more info this is my QA Server i restore all the database from the production server on the production server there is SQL server 2000 sp3a,4gb RAM and 200 gb hard disk and the same os like the QA server so i don't understand why on the QA server those DTS Process failed. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-13 : 10:35:27
|
| Load a very small amount of data via the DTS package....and log what it's doing...(your error message is too brief).If the DTS works, increase the size of the input data and repeat, until the error occurs.If the DTS fails to work even with the smallest dataset, then the problem is not with the data, but with some activity that is being performed within the data. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-13 : 10:57:09
|
| Could TEMPDB, or the database itself, being set to a fixed size cause this error?Kristen |
|
|
|
gaos
Starting Member
6 Posts |
Posted - 2005-09-15 : 20:16:03
|
| check your transaction log size, and you may need to disable it when loading data.OR you may check your dts property the option tab, make sure fast insert is enabled, otherwise, regular insert will be used and transaction log will be full quickly. |
|
|
|
matik
Starting Member
1 Post |
Posted - 2005-09-20 : 17:09:36
|
| http://support.microsoft.com/kb/889170/it's a bug. |
|
|
|
|
Help i'm stuck