Size Limits?

Question

Post reply

Size Limits?

Doug-363866

Say Hey Kid

Points: 674
More actions
July 29, 2009 at 7:50 am

#134338

Sql server 2005 32 bit.
The MDF file is 27GB, one table within the database is 25GB.
Would this cause an issue. I have SSIS package that loads this database and it is failing.
I can't figure our why as of yet. What are the size limits on tables and database within sql 2005?
Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Rome-828069 Say Hey Kid Points: 673 More actions · Answer 1

Nothing that small. Maybe your package is timing out? What's the error text say?

ps. One Orange Chip Points: 29422 More actions · Answer 2

Doug (7/29/2009)
What are the size limits on tables and database within sql 2005?

16 TB for data file and 2 TB for log file, 524,258 TB for the database. There is no limit on number of rows. It's dependent on the available space. see maximum capacity specifications.

http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx"> http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx

Pradeep Singh

Animal Magic SSChampion Points: 13964 More actions · Answer 3

definately nothing to do with the database size as has been stated. look at the error code in the job history and you should be able to work it out from there. could be a timeout, PK/FK violation etc

Doug-363866 Say Hey Kid Points: 674 More actions · Answer 4

Rome (7/29/2009)
Nothing that small. Maybe your package is timing out? What's the error text say?

An error occurred with the following error message: "Insufficient system storage. The server response was: 4.1.0 ... temporary failure".

Animal Magic SSChampion Points: 13964 More actions · Answer 5

what is the job doing?? does it move any files anywhere possibly to a drive that may be full?? i dont think it will be a problem with the database itself unless the drive the database is on is full and its trying to autogrow?

is there anything in your sql logs that specifiy any other errors?

Doug-363866 Say Hey Kid Points: 674 More actions · Answer 6

Animal Magic (7/29/2009)
what is the job doing?? does it move any files anywhere possibly to a drive that may be full?? i dont think it will be a problem with the database itself unless the drive the database is on is full and its trying to autogrow?
is there anything in your sql logs that specifiy any other errors?

It Truncates Tables and reloads them with fresh ODBC data.

No disk issues all have 80+ gigs free.

What sql logs should I look at?

This error looks like it occured in the SSIS Log when SSIS tried to execute a send mail task.

However one of the tables has zero rows, so something failed.

mineshchristian SSC Rookie Points: 47 More actions · Answer 7

I had the same issue...This was issue with email server itself. So check with your Support team

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 8

Are you trying to load to the free SQL Express edition? That has a 2GB file limit in SQL 2005/2008 and 10GB limit in 2008R2.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 9

Could it be a RAM issue? If you only have a small amount of RAM you may be experiencing swap-outs to disk which could affect time-outs etc. Is there anything else running on the box which is utilising lots of resources?

Mike.