March 15, 2004 at 11:35 pm
I intend to create a copy of my database on another server. To this end I have created a database with options to automatically grow the file and have ran a script to create the tables, stored procedures and the like from the existing databse. When I run the data transformation wizard to transfer the data from the databse t this copy I encounter the error unable to trasfer tables because the primary filegroup is full. Can anyone give me a clue as to what could be the problem. I'm running SQL Server 7.0.
Duzit
March 16, 2004 at 2:59 am
Is the disk full?
The primary filegroup by default contains all the database system tables. It also contains objects not assigned to user filegroups (or not specified). If you autogrowth your database files, then disk space might be the issue.
March 16, 2004 at 3:19 am
No there is plenty of disk space. SQL Server is installed on drive D and the space used for the data files is on F.
Duzit
March 16, 2004 at 4:18 am
Did the error message mention which object failed to allocate space?
Try to create an user filegroup as default and run the script (if create object statements do not have primary hard coded).
March 16, 2004 at 9:11 am
The exact message is as follows :-
Error at destination for row 8548966
Could not allocate space for oblect SYSTEM table ID 32178102 in database TEMPDB because default filegroup is full.
Duzit
March 16, 2004 at 4:18 pm
Put tempdb auto growth may solve the problem.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply