Primary keys lost after DTS

after performing export/dts from our database server to our hosting server,
the primary keys of each table in the destination server are lost. using the
dts wizard, i use the third option (copy database objects and data) and i di
d
make sure that the copy primary and foreign keys option is on. Can anyone
tell me how to solve the problem?
BTW, i did experience an error during the DTS process. "SetUser permission
denied." but still all database objects were transfered including the
contents except the primary keys. Does it had something to do with the
database account im using to connect to the server, which i think is limited
?In my own view is most clear generate scripts for each kind object (tables,
sp) and then PASTE into QA window and run them.
-Create the intended scripts and create the tables
-Transfer all the data(it's causing errors because of the table dependencies
but no problem at all, retry again all those ended in error)
--
current location: alicante (es)
"ads" wrote:
> after performing export/dts from our database server to our hosting server
,
> the primary keys of each table in the destination server are lost. using t
he
> dts wizard, i use the third option (copy database objects and data) and i
did
> make sure that the copy primary and foreign keys option is on. Can anyone
> tell me how to solve the problem?
> BTW, i did experience an error during the DTS process. "SetUser permission
> denied." but still all database objects were transfered including the
> contents except the primary keys. Does it had something to do with the
> database account im using to connect to the server, which i think is limited?[/col
or]

Primary Key Constraint Violation

I need to insert a text file where might contains duplicate data into
a table with primary keys using a DTS package. is there anyone out
there could help me? I have tried couple way to get around, but still
doesn't work.I would load trhe text file in to a table of the correct structure, but =with no PK constraint. Then use SELECT DISTINCT -- to retrieve the =data you need and insert into final table. (INSERT INTO -- SELECT =DISTINCT -- FROM can by helpful for that part).
Mike John
"Matt" <tkiansoon@.yahoo.com> wrote in message =news:7a4ed84d.0308270840.25fe7496@.posting.google.com...
> I need to insert a text file where might contains duplicate data into
> a table with primary keys using a DTS package. is there anyone out
> there could help me? I have tried couple way to get around, but still
> doesn't work.|||You could load it into a staging table first and then de-dupe it or have a
index with ignore duplicate key on the staging table (but this would slow
the load unless the text file is ordered the same as the index which would
need to be unique clustered) and assumes that the entire row is a duplicate
if the key is.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Matt" <tkiansoon@.yahoo.com> wrote in message
news:7a4ed84d.0308270840.25fe7496@.posting.google.com...
I need to insert a text file where might contains duplicate data into
a table with primary keys using a DTS package. is there anyone out
there could help me? I have tried couple way to get around, but still
doesn't work.

primary filegroup is full?

Hi,
I'm trying to use DTS to import a text file into a table and I get an error
saying that space cannot be allocated for the file because the primary
filegroup is full.
Any ideas how to extend the primary filegroup?
thanksRafale
It looks like during the DTS's execution an autogrow feature kicks in and
it takes some time
Check it out if you have enough available space and try to import the data
with small tranasctions.
"Rafael Chemtob" <rchemtobb@.nospam.yahoo.com> wrote in message
news:%236fCfYeOFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to use DTS to import a text file into a table and I get an
error
> saying that space cannot be allocated for the file because the primary
> filegroup is full.
> Any ideas how to extend the primary filegroup?
> thanks
>|||Yes I hit the same deal a few years ago try to shrink the files and the
tran log in that does not work then you need more hard disk space. aka
another disk drive or nas
*** Sent via Developersdex http://www.examnotes.net ***|||Hi,
Looks like any one of the below 3 reasons had created this error:-
1. You have restricted the file growth
2. Transaction log (LDF) has gone high due to DTS
3. Not enough room in hard disk
The solutions for each of the above problems are:-
1. Remove the restricted growth and monitor the growth while DTS
2. Take Transaction log backup and shrink the LDF file. See Backup LOG and
DBCC SHRINKFILE commands in books online. After shrink start the
DTS
3. Add a new file (NDF) and put it in a hard disk drive where u have more
space and start DTS
Thanks
Hari
SQL Server MVP
"Rafael Chemtob" <rchemtobb@.nospam.yahoo.com> wrote in message
news:%236fCfYeOFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to use DTS to import a text file into a table and I get an
> error
> saying that space cannot be allocated for the file because the primary
> filegroup is full.
> Any ideas how to extend the primary filegroup?
> thanks
>

PRIMARY filegroup is full?

Error Message
- Task reported failure on execution (SQL DTS). Could not allocate space for
object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
filegroup is full.
SQL Server Info
- SQL Server 2000 Standard Edition
- Intel Xeon 3.06 GHz
- 60 GB HDD
Database Properties
- Size 2,426.69 MB
- Space available 1,047.60 MB
- Data files is automatically grow file and unrestricted file growth
- Transaction Log is automatically grow file and unrestricted file growth
- Filegroups is PRIMARY
Please help.
Sam wrote:
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate
> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
> 'PRIMARY filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file
> growth
> - Filegroups is PRIMARY
> Please help.
Could you be running a very large task using DTS that is causing the log
file and data file growth to fill up that last gigbyte of space? Can you
move the log to another drive with more space? How big is the log now?
Can you backup the database or truncate the log file if it's too large?
David G.
|||The data file (employee.mdf) is 1,872 MB.
The transactiona log (employee.ldf) is 556MB.
"David G." <david_nospam@.nospam.com> wrote in message
news:eGF$l40gEHA.3348@.TK2MSFTNGP12.phx.gbl...
> Sam wrote:
> Could you be running a very large task using DTS that is causing the log
> file and data file growth to fill up that last gigbyte of space? Can you
> move the log to another drive with more space? How big is the log now?
> Can you backup the database or truncate the log file if it's too large?
> --
> David G.
>
|||sometime files doesn't grow fast enough, so you get this "database is full" message. I suggest you
pre-allocate storage (also good for performance reasons).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate space for
> object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file growth
> - Filegroups is PRIMARY
> Please help.
>
|||Notice that SQL Server 2000 is only permitted 2GB per database.
Therefore, the database shrinked and able to update via SQL DTS.
Could it add more data files into single database so that each of it consist
2GB?
Please advise.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> sometime files doesn't grow fast enough, so you get this "database is
full" message. I suggest you
> pre-allocate storage (also good for performance reasons).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
for[vbcol=seagreen]
growth
>
|||SQL Server support about 1 million TB size for database. Each file can be 32 TB.
However, MSDE has max size of 2GB for data (transaction log not included). Sam doesn't appear to be
running MSDE as data size is already over 2GB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> Notice that SQL Server 2000 is only permitted 2GB per database.
> Therefore, the database shrinked and able to update via SQL DTS.
> Could it add more data files into single database so that each of it consist
> 2GB?
> Please advise.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> full" message. I suggest you
> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> for
> growth
>
|||I'm using SQL Server 2000 Standard Edition and how much the size of database
(MDF)?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> SQL Server support about 1 million TB size for database. Each file can be
> 32 TB.
> However, MSDE has max size of 2GB for data (transaction log not included).
> Sam doesn't appear to be
> running MSDE as data size is already over 2GB.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
>
|||In SQL Server 2000 Standard Edition, max size for an mdf file is 32 TB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:eBe7WmBhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I'm using SQL Server 2000 Standard Edition and how much the size of database
> (MDF)?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
>

PRIMARY filegroup is full?

Error Message
- Task reported failure on execution (SQL DTS). Could not allocate space for
object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
filegroup is full.
SQL Server Info
- SQL Server 2000 Standard Edition
- Intel Xeon 3.06 GHz
- 60 GB HDD
Database Properties
- Size 2,426.69 MB
- Space available 1,047.60 MB
- Data files is automatically grow file and unrestricted file growth
- Transaction Log is automatically grow file and unrestricted file growth
- Filegroups is PRIMARY
Please help.Sam wrote:
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate
> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
> 'PRIMARY filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file
> growth
> - Filegroups is PRIMARY
> Please help.
Could you be running a very large task using DTS that is causing the log
file and data file growth to fill up that last gigbyte of space? Can you
move the log to another drive with more space? How big is the log now?
Can you backup the database or truncate the log file if it's too large?
David G.|||The data file (employee.mdf) is 1,872 MB.
The transactiona log (employee.ldf) is 556MB.
"David G." <david_nospam@.nospam.com> wrote in message
news:eGF$l40gEHA.3348@.TK2MSFTNGP12.phx.gbl...
> Sam wrote:
> Could you be running a very large task using DTS that is causing the log
> file and data file growth to fill up that last gigbyte of space? Can you
> move the log to another drive with more space? How big is the log now?
> Can you backup the database or truncate the log file if it's too large?
> --
> David G.
>|||sometime files doesn't grow fast enough, so you get this "database is full"
message. I suggest you
pre-allocate storage (also good for performance reasons).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl..
.
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate space f
or
> object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file growth
> - Filegroups is PRIMARY
> Please help.
>|||Notice that SQL Server 2000 is only permitted 2GB per database.
Therefore, the database shrinked and able to update via SQL DTS.
Could it add more data files into single database so that each of it consist
2GB?
Please advise.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> sometime files doesn't grow fast enough, so you get this "database is
full" message. I suggest you
> pre-allocate storage (also good for performance reasons).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
for[vbcol=seagreen]
growth[vbcol=seagreen]
>|||SQL Server support about 1 million TB size for database. Each file can be 32
TB.
However, MSDE has max size of 2GB for data (transaction log not included). S
am doesn't appear to be
running MSDE as data size is already over 2GB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl..
.
> Notice that SQL Server 2000 is only permitted 2GB per database.
> Therefore, the database shrinked and able to update via SQL DTS.
> Could it add more data files into single database so that each of it consi
st
> 2GB?
> Please advise.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> full" message. I suggest you
> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> for
> growth
>|||I'm using SQL Server 2000 Standard Edition and how much the size of database
(MDF)?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> SQL Server support about 1 million TB size for database. Each file can be
> 32 TB.
> However, MSDE has max size of 2GB for data (transaction log not included).
> Sam doesn't appear to be
> running MSDE as data size is already over 2GB.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
>|||In SQL Server 2000 Standard Edition, max size for an mdf file is 32 TB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:eBe7WmBhEHA.3612@.TK2MSFTNGP12.phx.gbl..
.
> I'm using SQL Server 2000 Standard Edition and how much the size of databa
se
> (MDF)?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
>

PRIMARY filegroup is full?

Error Message
- Task reported failure on execution (SQL DTS). Could not allocate space for
object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
filegroup is full.
SQL Server Info
- SQL Server 2000 Standard Edition
- Intel Xeon 3.06 GHz
- 60 GB HDD
Database Properties
- Size 2,426.69 MB
- Space available 1,047.60 MB
- Data files is automatically grow file and unrestricted file growth
- Transaction Log is automatically grow file and unrestricted file growth
- Filegroups is PRIMARY
Please help.Sam wrote:
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate
> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
> 'PRIMARY filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file
> growth
> - Filegroups is PRIMARY
> Please help.
Could you be running a very large task using DTS that is causing the log
file and data file growth to fill up that last gigbyte of space? Can you
move the log to another drive with more space? How big is the log now?
Can you backup the database or truncate the log file if it's too large?
--
David G.|||The data file (employee.mdf) is 1,872 MB.
The transactiona log (employee.ldf) is 556MB.
"David G." <david_nospam@.nospam.com> wrote in message
news:eGF$l40gEHA.3348@.TK2MSFTNGP12.phx.gbl...
> Sam wrote:
>> Error Message
>> - Task reported failure on execution (SQL DTS). Could not allocate
>> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
>> 'PRIMARY filegroup is full.
>> SQL Server Info
>> - SQL Server 2000 Standard Edition
>> - Intel Xeon 3.06 GHz
>> - 60 GB HDD
>> Database Properties
>> - Size 2,426.69 MB
>> - Space available 1,047.60 MB
>> - Data files is automatically grow file and unrestricted file growth
>> - Transaction Log is automatically grow file and unrestricted file
>> growth
>> - Filegroups is PRIMARY
>> Please help.
> Could you be running a very large task using DTS that is causing the log
> file and data file growth to fill up that last gigbyte of space? Can you
> move the log to another drive with more space? How big is the log now?
> Can you backup the database or truncate the log file if it's too large?
> --
> David G.
>|||sometime files doesn't grow fast enough, so you get this "database is full" message. I suggest you
pre-allocate storage (also good for performance reasons).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate space for
> object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file growth
> - Filegroups is PRIMARY
> Please help.
>|||Notice that SQL Server 2000 is only permitted 2GB per database.
Therefore, the database shrinked and able to update via SQL DTS.
Could it add more data files into single database so that each of it consist
2GB?
Please advise.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> sometime files doesn't grow fast enough, so you get this "database is
full" message. I suggest you
> pre-allocate storage (also good for performance reasons).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> > Error Message
> > - Task reported failure on execution (SQL DTS). Could not allocate space
for
> > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> > filegroup is full.
> >
> > SQL Server Info
> > - SQL Server 2000 Standard Edition
> > - Intel Xeon 3.06 GHz
> > - 60 GB HDD
> >
> > Database Properties
> > - Size 2,426.69 MB
> > - Space available 1,047.60 MB
> > - Data files is automatically grow file and unrestricted file growth
> > - Transaction Log is automatically grow file and unrestricted file
growth
> > - Filegroups is PRIMARY
> >
> > Please help.
> >
> >
>|||SQL Server support about 1 million TB size for database. Each file can be 32 TB.
However, MSDE has max size of 2GB for data (transaction log not included). Sam doesn't appear to be
running MSDE as data size is already over 2GB.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> Notice that SQL Server 2000 is only permitted 2GB per database.
> Therefore, the database shrinked and able to update via SQL DTS.
> Could it add more data files into single database so that each of it consist
> 2GB?
> Please advise.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> > sometime files doesn't grow fast enough, so you get this "database is
> full" message. I suggest you
> > pre-allocate storage (also good for performance reasons).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> > > Error Message
> > > - Task reported failure on execution (SQL DTS). Could not allocate space
> for
> > > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> > > filegroup is full.
> > >
> > > SQL Server Info
> > > - SQL Server 2000 Standard Edition
> > > - Intel Xeon 3.06 GHz
> > > - 60 GB HDD
> > >
> > > Database Properties
> > > - Size 2,426.69 MB
> > > - Space available 1,047.60 MB
> > > - Data files is automatically grow file and unrestricted file growth
> > > - Transaction Log is automatically grow file and unrestricted file
> growth
> > > - Filegroups is PRIMARY
> > >
> > > Please help.
> > >
> > >
> >
> >
>|||I'm using SQL Server 2000 Standard Edition and how much the size of database
(MDF)?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> SQL Server support about 1 million TB size for database. Each file can be
> 32 TB.
> However, MSDE has max size of 2GB for data (transaction log not included).
> Sam doesn't appear to be
> running MSDE as data size is already over 2GB.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
>> Notice that SQL Server 2000 is only permitted 2GB per database.
>> Therefore, the database shrinked and able to update via SQL DTS.
>> Could it add more data files into single database so that each of it
>> consist
>> 2GB?
>> Please advise.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
>> > sometime files doesn't grow fast enough, so you get this "database is
>> full" message. I suggest you
>> > pre-allocate storage (also good for performance reasons).
>> >
>> > --
>> > Tibor Karaszi, SQL Server MVP
>> > http://www.karaszi.com/sqlserver/default.asp
>> > http://www.solidqualitylearning.com/
>> >
>> >
>> > "Sam" <cybersam88@.hotmail.com> wrote in message
>> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
>> > > Error Message
>> > > - Task reported failure on execution (SQL DTS). Could not allocate
>> > > space
>> for
>> > > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
>> > > filegroup is full.
>> > >
>> > > SQL Server Info
>> > > - SQL Server 2000 Standard Edition
>> > > - Intel Xeon 3.06 GHz
>> > > - 60 GB HDD
>> > >
>> > > Database Properties
>> > > - Size 2,426.69 MB
>> > > - Space available 1,047.60 MB
>> > > - Data files is automatically grow file and unrestricted file growth
>> > > - Transaction Log is automatically grow file and unrestricted file
>> growth
>> > > - Filegroups is PRIMARY
>> > >
>> > > Please help.
>> > >
>> > >
>> >
>> >
>>
>|||In SQL Server 2000 Standard Edition, max size for an mdf file is 32 TB.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:eBe7WmBhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I'm using SQL Server 2000 Standard Edition and how much the size of database
> (MDF)?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> > SQL Server support about 1 million TB size for database. Each file can be
> > 32 TB.
> >
> > However, MSDE has max size of 2GB for data (transaction log not included).
> > Sam doesn't appear to be
> > running MSDE as data size is already over 2GB.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> > news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> >> Notice that SQL Server 2000 is only permitted 2GB per database.
> >> Therefore, the database shrinked and able to update via SQL DTS.
> >>
> >> Could it add more data files into single database so that each of it
> >> consist
> >> 2GB?
> >>
> >> Please advise.
> >>
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> >> in
> >> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> >> > sometime files doesn't grow fast enough, so you get this "database is
> >> full" message. I suggest you
> >> > pre-allocate storage (also good for performance reasons).
> >> >
> >> > --
> >> > Tibor Karaszi, SQL Server MVP
> >> > http://www.karaszi.com/sqlserver/default.asp
> >> > http://www.solidqualitylearning.com/
> >> >
> >> >
> >> > "Sam" <cybersam88@.hotmail.com> wrote in message
> >> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> >> > > Error Message
> >> > > - Task reported failure on execution (SQL DTS). Could not allocate
> >> > > space
> >> for
> >> > > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> >> > > filegroup is full.
> >> > >
> >> > > SQL Server Info
> >> > > - SQL Server 2000 Standard Edition
> >> > > - Intel Xeon 3.06 GHz
> >> > > - 60 GB HDD
> >> > >
> >> > > Database Properties
> >> > > - Size 2,426.69 MB
> >> > > - Space available 1,047.60 MB
> >> > > - Data files is automatically grow file and unrestricted file growth
> >> > > - Transaction Log is automatically grow file and unrestricted file
> >> growth
> >> > > - Filegroups is PRIMARY
> >> > >
> >> > > Please help.
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>

'PRIMARY' filegroup is full (yet another)

Hello,
I am getting this error on the database msdb when trying to update a DTS
package.
When I look at msdb, it is set to automatically grow and autoshrink is off.
I changed the auto-grow on the MDF file to 10% but that didn't help.
I then tried changing the space allocated - on the Data Files tab in the
Properties menu after right-clicking the database in Enterprise Manager. As
soon as I hit "OK", the size changes back to the original (too small) value
and nothing has changed. What else could be wrong, and why can't I change
the size'
Thanks
LesTry changing the size using ALTER DATABASE and see if you get any error message. Also see if you
have autoshrink turned on for the database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
> Hello,
> I am getting this error on the database msdb when trying to update a DTS
> package.
> When I look at msdb, it is set to automatically grow and autoshrink is off.
> I changed the auto-grow on the MDF file to 10% but that didn't help.
> I then tried changing the space allocated - on the Data Files tab in the
> Properties menu after right-clicking the database in Enterprise Manager. As
> soon as I hit "OK", the size changes back to the original (too small) value
> and nothing has changed. What else could be wrong, and why can't I change
> the size'
> Thanks
> Les|||With an 'is it plugged in question' (because all your factors were within
SS)--is there enough room on the disk?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Tibor Karaszi" wrote:
> Try changing the size using ALTER DATABASE and see if you get any error message. Also see if you
> have autoshrink turned on for the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
> news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
> > Hello,
> >
> > I am getting this error on the database msdb when trying to update a DTS
> > package.
> >
> > When I look at msdb, it is set to automatically grow and autoshrink is off.
> > I changed the auto-grow on the MDF file to 10% but that didn't help.
> >
> > I then tried changing the space allocated - on the Data Files tab in the
> > Properties menu after right-clicking the database in Enterprise Manager. As
> > soon as I hit "OK", the size changes back to the original (too small) value
> > and nothing has changed. What else could be wrong, and why can't I change
> > the size'
> >
> > Thanks
> > Les
>|||Hello,
I used the ALTER DATABASE command and it increased the PHYSICAL size of the
file on disk. However it had no effect on the "Space Allocated (MS)" figure
and the database still refuses to expand. Autoshrink os OFF and always has
been.
I tried increasing the MAXSIZE - this also had no effect. This is extremely
frustrating - the server is basically ignoring my instructions. Could it be
a security issue? (although I am getting no warning or error messages). The
owner of the database is sa.
There is 50GB of space left on the disk - no problem there.
We are now stuck in a situation where we cannot modify our DTS packages.
Any help appreciated.
Les
"Tibor Karaszi" wrote:
> Try changing the size using ALTER DATABASE and see if you get any error message. Also see if you
> have autoshrink turned on for the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
> news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
> > Hello,
> >
> > I am getting this error on the database msdb when trying to update a DTS
> > package.
> >
> > When I look at msdb, it is set to automatically grow and autoshrink is off.
> > I changed the auto-grow on the MDF file to 10% but that didn't help.
> >
> > I then tried changing the space allocated - on the Data Files tab in the
> > Properties menu after right-clicking the database in Enterprise Manager. As
> > soon as I hit "OK", the size changes back to the original (too small) value
> > and nothing has changed. What else could be wrong, and why can't I change
> > the size'
> >
> > Thanks
> > Les
>|||I seemed to have got this to work by creating a second file to the PRIMARY
filegroup for the msdb database. However I would still be interested in any
theories as to why I couldn't get the single file to work.
I should mention we are having software RAID problems on this server - I
don't think they are a factor because I am getting no related error messages.
Les
"Les Russell" wrote:
> Hello,
> I used the ALTER DATABASE command and it increased the PHYSICAL size of the
> file on disk. However it had no effect on the "Space Allocated (MS)" figure
> and the database still refuses to expand. Autoshrink os OFF and always has
> been.
> I tried increasing the MAXSIZE - this also had no effect. This is extremely
> frustrating - the server is basically ignoring my instructions. Could it be
> a security issue? (although I am getting no warning or error messages). The
> owner of the database is sa.
> There is 50GB of space left on the disk - no problem there.
> We are now stuck in a situation where we cannot modify our DTS packages.
> Any help appreciated.
> Les
> "Tibor Karaszi" wrote:
> > Try changing the size using ALTER DATABASE and see if you get any error message. Also see if you
> > have autoshrink turned on for the database.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> > Blog: http://solidqualitylearning.com/blogs/tibor/
> >
> >
> > "Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
> > news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
> > > Hello,
> > >
> > > I am getting this error on the database msdb when trying to update a DTS
> > > package.
> > >
> > > When I look at msdb, it is set to automatically grow and autoshrink is off.
> > > I changed the auto-grow on the MDF file to 10% but that didn't help.
> > >
> > > I then tried changing the space allocated - on the Data Files tab in the
> > > Properties menu after right-clicking the database in Enterprise Manager. As
> > > soon as I hit "OK", the size changes back to the original (too small) value
> > > and nothing has changed. What else could be wrong, and why can't I change
> > > the size'
> > >
> > > Thanks
> > > Les
> >
> >

PRIMARY file group is full

Hi there,

I've just run some DTS packages on my test sqlserver (Which has limited
hard disk space and memory) and all the tasks have failed, due to
'PRIMARY' file group is full

Is there a query or script I can run to resolve this problem??

M3ckon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!m3ckon (anonymous@.devdex.com) writes:
> I've just run some DTS packages on my test sqlserver (Which has limited
> hard disk space and memory) and all the tasks have failed, due to
> 'PRIMARY' file group is full
> Is there a query or script I can run to resolve this problem??

Could send a query to whomeever holds you money to get more hardware.

The message says that SQL Server cannot autogrow the database, because
there is not space on the disk. By default SQL Server grows by 10%, so
if your database is 20 GB, SQL Server tries to grow 2 GB. If you think
you can fit your data into these 2 GB, then you lower that number to
squeeze out the rest from your disk.

Else you will have to try to free up some disk space. If the log for
the database is on the same disk, and you could live with simple
recovery, you could change to simple recovery, and then issue
BACKUP LOG db WITH TRUNCATE_ONLY. You have also have to do a DBCC
SHRINKFILE on the log. But before you do any of this, check how big
your log is.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp