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)
 filegroup error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-19 : 09:25:41
Matthew writes "I'm getting an error using DTS to bulk copy large datasets from an AS400/DB2 to SQL7. The error is 'Cannot allocate space...on 'PRIMARY' filegroup. I couldn't find a reference to it in books online. I've got plenty of space on the destination drive. Any suggestions?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-02-19 : 09:35:12
Check the database you're importing into, to see if it has a maximum size (instead of unlimited growth). From Enterprise Manager, right-click the database and choose Properties. Check both the data and log files, and either set them to unlimited growth, or increase the maximum file size.

Go to Top of Page
   

- Advertisement -