Friday, December 9, 2011

SQL Server Error 1101 Could Not Allocate A New Page For Database

ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup . Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. 

Workaround / Solution: 
Step 1: Make sure there is enough Hard Disk space available where data files are stored on server.

Step 2: Turn on AUTOGROW for file groups. 

Step 3: Shrink the data file through below command

USE AdventureWorks;
GO
DBCC SHRINKFILE (DataFile1, 5);
GO
1101 sql. 1101 sql error. 1101 sql server authentication. error. error 1101. error 1101 sql server. error 1101. error number: 1101. error: 1101.lock request time out period exceeded. (microsoft sql server. error: 1101). lock request time out period exceeded. microsoft sql server error 1101. login error. login failed. login failed for user. login failed for user 'sa'microsoft sql server 2005 error 1101. microsoft sql server error 1101. microsoft sql server error 1101. mssqlserver error 1101. server error. server failover. server fix. server log. sql 1101 error. sql error 1101. sql error 9002. sql server 2005 error 1101. sql server 2008 error 1101. sql server 2012 error 1101. sql server error 1101. sql server error 1101. Could not allocate a new page for database because of . Microsoft SQL Server. Error: 11001‎. sql 2008 agent not starting Error code = 0x8007000b‎ . ODBC with SQL Server - Error 1101 & error 6.‎ . Unable to create a new data source using SQL Server.. ODBC Error. Error SQL Native Client. connection error . Fatal Error: 1101. SQLServerAgent could not be started.

0 comments:

Post a Comment