SQL Server - 1105 error: primary filegroup is full
Asked By Oliver
26-Jan-10 06:27 AM
Hello,
I am getting that error in a database, its size is 88GB. There is almost
300GB of free disk space in its drive. The datafiles of primary have a
maxsize of 4096MB (almost all file are near of the 4096). The last datafile
of primary filegroup has unlimited like maxsize.
It is SQL Server 2000 SP4. What's the problem? If I try add a datafile, it
shows the same error.
Thanks beforehand.
Cheers...
SQL Server 2000
(1)
Disk
(1)
Database
(1)
OliverI
(1)
Datafiles
(1)
Maxsize
(1)
Triesr
(1)
Uri Dimant replied to Oliver
Oliver
I guess the problem is that SQL Server triesr tries to automatically expand
the database, if you have the autogrow option set. Do you perform any DML
operations when you saw the error? I would suggest to allocate plenty of
space for the database (uncheck autogrow option or enable growing in MB not
percentage ) and monitoring the size of db as well
Oliver replied to Uri Dimant
Thank you very much for your reply Uri.
About your questions:
Yes, I am trying insert rows in the database.
I have autogrow enabled, in MB (no %).
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit when
SQL Express: Failed Reinstall SQL Server Dear Setup Experts: I am trying to reinstall SQL Express after playing with it some. I uninstalled it, and now, it refuses to reinstall in the face. Any ideas what this log file means and how I can get SQL Express installed? I really do not want to have to reinstall my whole system. * ** ** Start of Log File Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068643839 Exit facility code: 1203
migration from SQL 2000 to SQL 2008 SQL Server I am working on to migrate my SQL 2000 database to SQL 2008. I use SSMS to connect 2 SQL Servers and want to backup
Replicating from SQL 2000 to SQL 2008 SQL Server I have 2 instance of SQL Servers. Instance A : SQL Server 2000 Enterprise Edition running on Windows 2003 (32 Bit). Instance B : SQL Server 2008 Enterprise
SQLServer Error: 802, 701, 733 SQL Server SQL Server 2008 on Win2008 R2 x64 Server, 8 GB RAM - running virtualized on VMWare ES-Server Every sunday some maintainance jobs are scheduled to run. Rebuilding indices and statistics fail with There is insufficient memory available in the buffer pool. [SQLSTATE 42000] (SaveAllSchedules) After this the server is no longer reachable: [298] SQLServer Error: 773, SQL Server Network Interfaces: The requested security package does not exist [SQLSTATE 08001] . . . [298] SQLServer Error