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.
| 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. |
 |
|
|
|
|
|