Hello SQL Experts,
I am currently facing an issue while merging multiple files in my database, and I could really use your expertise to overcome this challenge. The error message I am encountering is as follows:
"Could not allocate a new page for database 'KRISHNA_ANALYTICS_6' due to insufficient disk space in filegroup 'PRIMARY'. To resolve this, I need to create the necessary space by either dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup."
My database contains a total of around 14 million rows, and this error is occurring due to the large size of the tables I am trying to merge. I understand that managing such a massive dataset can be complex, but I'm hoping that with your guidance, we can find a solution together.
Please help me in resolving this issue, and if any further information is required, I'll be happy to provide it.
Thank you in advance for your time and assistance.