primary table full - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

primary table full

Author

Topic

Steel_m
Starting Member

25 Posts

Posted - 2008-12-19 : 12:35:08

Hi all, I keep getting prompted with a 'primary table full' message when importing files from ms access to sqlserver. The file growth is not restricted and i have space availabe on the drive. Please help me fix this

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-19 : 12:37:06

It probably couldn't expand fast enough for your import. Manually grow your file through the GUI or via ALTER DATABASE command.

Here's a recent script that I used to grow a file manually:


DECLARE @sql nvarchar(500), @size int

SET @size = 68863

WHILE @size <= 80063
BEGIN
	SET @sql = 'ALTER DATABASE dbName MODIFY FILE (NAME = dbName_Data, SIZE = ' + CONVERT(varchar(5), @size) + ' MB)'
	SET @size = @size + 100
	WAITFOR DELAY '00:00:05'
	EXEC (@sql)
END

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Steel_m
Starting Member

25 Posts

Posted - 2009-01-02 : 09:53:50

Sorry for the late reponse. I tried ur solution but its saying I have a license limit of 2048 mb per database. DO you know how i can get around this ?

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2009-01-02 : 10:10:15

what version / edition of sql server are you using? MSDE? if so, it has a 2gb limit and that's that

Em

Steel_m
Starting Member

25 Posts

Posted - 2009-01-02 : 16:24:42

Im using sql server 2003

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-02 : 16:27:13

There is no such thing as SQL Server 2003.

Show us the output of SELECT @@VERSION.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Steel_m
Starting Member

25 Posts

Posted - 2009-01-02 : 16:47:11

my bad. Its sql server 2000 8.00.760

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-02 : 17:19:11

Please post the entire and exact output of SELECT @@VERSION.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Steel_m
Starting Member

25 Posts

Posted - 2009-01-07 : 09:11:13

Its Microsoft SQL 2000 - 8.00.760 (Intel X86) I am importing the tables from ms access

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2009-01-07 : 09:13:18

that is not the entire output of select @@version. try again

Em

Steel_m
Starting Member

25 Posts

Posted - 2009-01-07 : 13:30:18

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-07 : 13:38:15

You are using MSDE. That edition has a 2GB database size limit, so that's why are you getting the error. You'll need to upgrade your edition or delete some data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Steel_m
Starting Member

25 Posts

Posted - 2009-01-07 : 15:03:35

thanks for the advice. I actually will need to add more data. I guess i will have to make the system admin aware

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources