Maintenance Plan error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Maintenance Plan error

Author

Topic

TRG
Starting Member

3 Posts

Posted - 2009-04-17 : 08:25:48

Hello there!
I have allready i little bit experiance with SQL server 2005... i am in learning proces :)

I run my maintenance plan and get error:
Executing the query
"ALTER INDEX [PK_PIEPRINFPROJ]
ON
[dbo].[pieprInfProj]
REBUILD WITH
( PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON,
SORT_IN_TEMPDB = OFF,
ONLINE = OFF )
"
failed with the following error:
"Could not allocate a new page for database 'dbname' because of insufficient disk space in filegroup 'PRIMARY'.
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.
The statement has been terminated.".
Possible failure reasons:
Problems with the query, "ResultSet"
property not set correctly, parameters not set correctly, or connection not established correctly.

in log file it seems only this index failed to rebuild... the error are talking about hdd space? i don`t understand this error :(

P.S. Sorry for my bad english :)

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-04-17 : 10:36:37

In SQL Server Management Studio
connect to your server
right click on your database and choose properties
in propertywindow go to files
see a) Autogrowth: - is it ok? b) Path: check that harddiskdrive to have enough free space

OK?

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

TRG
Starting Member

3 Posts

Posted - 2009-04-20 : 09:30:44

I have 46,2 GB free space on HDD - Primary, where is database
On Secundary HDD i have 57 GB free space, but i use it for backups

In database->properties>files:
.mdf data initial size 6453MB - Autogrowth enable 50% Restricted File Growth 8,339MB
.ldf size 270MB - Autogrowth enable 10% Unrestricted File Growth

general size on database show 6722,44MB
Space avaiable 518.06MB, whan i run maintanence plan, to check how much it will take, this space shorted to 518.05MB, and general size on database growned to 6811,74MB

can somebody tell me, what is wrong here? :(

TRG
Starting Member

3 Posts

Posted - 2009-04-20 : 11:57:05

hmmm, i just made .mdf in database->properties>files autogrowth too unstricted and everything is fine now... :)
Tnx webfred

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources