Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Express 2005 instance is not starting up Expand / Collapse
Author
Message
Posted Thursday, March 7, 2013 8:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 12:07 AM
Points: 5, Visits: 6
Hi all,

We get this error when the sql express 2005 instance starts

"Could not allocate space for object 'dbo.LogTable'.'Pk_logTable_Srno' in database 'LogDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup."

There is only one database in the instance and its ldf file is 3.75 MB and mdf file is 11 MB. And also the drive has enough space.

One more things is the system has another instance of SQL Express 2005 running on.

We don't have an idea which caused this error. Any help will be appreciated.

Thanks
Post #1428355
Posted Thursday, March 7, 2013 9:57 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
Sounds like the data file has reached its max size and autogrow has been turned off. Have you tried to expand the file?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1428378
Posted Thursday, March 7, 2013 10:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 12:07 AM
Points: 5, Visits: 6
This is that database properties for file

FileType Filegroup InitialSize(11MB) Autogrowth
--------------------------------------------------------------------
Rows Primary 11 By 1 MB, unrestricted growth
Log Not applicable 4 By 10 percent, restricted growth


Will it be problem with these settings?
Post #1428397
Posted Thursday, March 7, 2013 11:08 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
The log file is set to restricted growth. You may have reached that restricted growth size.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1428400
Posted Thursday, March 7, 2013 11:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 12:07 AM
Points: 5, Visits: 6
The log file restricted 4 MB but the .ldf file is 3.75 MB only. So how to increase the log file size? The sql instance itself is not getting started..
Post #1428408
Posted Thursday, March 7, 2013 11:27 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
Manually grow your log file (it seems your instance is started since you were able to retrieve those db settings already).

USE [master]
GO
ALTER DATABASE [DatabaseName] MODIFY FILE ( NAME = N'DATABASENAME_Log', SIZE = 6MB , MAXSIZE = 20MB)
GO

Another option is to remove that maxsize restriction that you have.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1428411
Posted Thursday, March 7, 2013 11:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 12:07 AM
Points: 5, Visits: 6
Instance is not yet started. I have occupied that ldf and mdf file to another instance data folder and then checked the settings. Now how to proceed to change the settings there?
Post #1428415
Posted Friday, March 8, 2013 12:06 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
The size of that database is not preventing your instance from starting. Check the logs and see if you have another error when you try to start the service for that instance.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1428419
Posted Friday, March 8, 2013 12:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 12:07 AM
Points: 5, Visits: 6
Thanks SQLRNNR. Will try to figure out if there is any other error
Post #1428426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse