Question

Finding the appropriate settings for copying tables within databases

SQL, Database issues, Copy error, SQL error messages

I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs:

"Could not allocate space for object 'ChangeInsuranceTxnHistory' in database 'CC_CCAR' because the 'PRIMARY' filegroup is full."

My database settings are “automatically grow file” and I have checked “unrestricted file growth”. Could you assist me in fixing this?

Either your hard drive is full, or your hard drive is to slow to increase the data files within the timeout period.

Try reducing the size of the growth to a specific number (if in %) of like 256 Megs.