Author |
Topic |
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-09 : 10:54:15
|
I have just added a 500G USB drive. I have created a DB on it and am attempting to export data to it. The problem is I keep getting:Could not allocate space for object 'dbo.Matched' in database 'MyDBK' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroupThe drive is empty so there is plenty of room. How do I set auto gro or something so this error goes away? |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-09 : 11:30:23
|
Is your data file set to unrestricted growth? Check this by going into your Database Properties, checking the Auto growth value.It could also be potentially a tempdb problem?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-09 : 13:01:39
|
Keep in mind that fat32 has 4gb file size limit. |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-09 : 19:48:35
|
On the database properties page Files tab the the Data, PRIMARY IS SET TO BY 10 PERCENT UNRESTRICTED. The log file is set to Log, Not Applicable, Autogrowth set for BY 10 PERCENT RESTRICTED growth to 2097152. When I change this to unrestricted it shanges back to the restricted.is this the right place to change this value? Or do I need to do something else? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-09 : 22:41:07
|
Sounds right. What's file system for the disk? |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-09 : 22:57:02
|
I don't know. It is a Western Digital that came pre formated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-09 : 23:29:02
|
Right click the disk and open properties, is it in ntfs or fat32? |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-09 : 23:38:53
|
It is fat32. I know the DB and a lot of the tables are larger than 4G. How do i go about reformating if that is the solution? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-10 : 00:06:38
|
You can convert it to ntfs with convert.exe. |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-10 : 02:23:40
|
That was the solution. Thank you. |
|
|
|