Error: 1101, Severity: 17, State: 10

Error: 1101, Severity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There
are no more pages available in filegroup DEFAULT. Space
can be created by dropping objects, adding additional
files, or allowing file growth..
Does anybody know the quick fix to this? Thx.Rose,
Tempdb has filled up its space or has filled the disk
where it was created.
This leads to an MSDN article on expanding databases with
some specific comments on tempdb.
http://tinyurl.com/hoh4
Since tempdb is recreated each time you start the server
a restart will clear the current problem. However, you
should try to find out what was happening that filled
tempdb and try to prevent it from happening again.
Russell Fields
>--Original Message--
>Error: 1101, Severity: 17, State: 10
>Could not allocate new page for database 'TEMPDB'. There
>are no more pages available in filegroup DEFAULT. Space
>can be created by dropping objects, adding additional
>files, or allowing file growth..
>Does anybody know the quick fix to this? Thx.
>.
>|||Rose,
>> Does anybody know the quick fix to this?
How about the one mentioned in the error message itself? Did you check if
there is enough space in the filegroup?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rose Mbatuchic" <simacy6@.yahoo.com> wrote in message
news:0bd401c35059$82aec8b0$a401280a@.phx.gbl...
> Error: 1101, Severity: 17, State: 10
> Could not allocate new page for database 'TEMPDB'. There
> are no more pages available in filegroup DEFAULT. Space
> can be created by dropping objects, adding additional
> files, or allowing file growth..
> Does anybody know the quick fix to this? Thx.

error while running initial snapshot using internet

Hi There,
I am trying to apply initial snapshot to our client who are going to
access through internet. I publishe data and check available using ftp.
While synchronizing from subscriber i am receving following error
message.
the schema script '\\TESTSERV01\C$\Program Files\Microsoft SQL
Server\MSSQL\REPDATANEW\ftp\TESTSERV01_Ultraline Master-SQL_Ultraline
Master-SQLpubfilter\20040413094943\WellTownships_1.sch' could not be
propagated to the subscriber. The step failed.
===
Where, WellTownships is a table.
Any help please.
Thanks.
Indra.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
what is your virtual directory name?
Whatever it is your client path to this folder from the ftp root should be
the virtual directory name + /ftp.
Then make sure the IUSER_Account (or the NT account if you are using an FTP
account other than anonymous) has read rights to the files and folders
underlying the virtual directory path.
"Indra Timilsina" <itimilsina@.savannaenergy.com> wrote in message
news:uURk2kZIEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Hi There,
> I am trying to apply initial snapshot to our client who are going to
> access through internet. I publishe data and check available using ftp.
> While synchronizing from subscriber i am receving following error
> message.
> the schema script '\\TESTSERV01\C$\Program Files\Microsoft SQL
> Server\MSSQL\REPDATANEW\ftp\TESTSERV01_Ultraline Master-SQL_Ultraline
> Master-SQLpubfilter\20040413094943\WellTownships_1.sch' could not be
> propagated to the subscriber. The step failed.
>
> ===
> Where, WellTownships is a table.
> Any help please.
> Thanks.
> Indra.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

error while importing text file into sql server 2000

hi all,

While importing into sql server 2000 from a text file i am getting an error message like not enough disk space available to perform this operation but there is enough space (around 18gb). Please advice why this is happenning as my work is stuck

thanks and regards

jk

This is a guess since you didn't give much detail, but try setting your BLOBTempStoragePath and BufferTempStoragePath properties to a location on the drive where this 18GB is available. These paths default to the drive where SSIS was installed, which is usually a system drive and may be close to full.
|||

thanks for the reply , could u please explane it in details as i am new to sql server 2000 the problem i am facing is that , when i try to import a text file into a DB it is showing ERROR 'not enough storage space.'

The text file is been exported from another DB using some date constrains. I have tried restoring DB just to check weather this is because of storage space problem but it works fine but when i try to import data the above error is shown . Please advice

thanks and regards

jk

|||This no longer sounds like a SQL Server 2005 Integration Services question. If it is, please provide details about your scenario and error. If not, you're probably best served by doing some web searches first and then posting your question in a more appropriate forum.