Hi all -
Recieve the message
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 09/08/2005
Time: 10:13:47 AM
User: N/A
Computer: JackBox
Description:
17052 :
Could not adjust the space allocation for file 'Jack_Data_1'.
The machine is win2K sp4 running sql2K sp3. Could not find this error on
support.microsoft.com - could anyone explain the meaning?
Thanks.
TitoHi
Maybe something like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;254253
What maintainance are you carrying out?
You may want to stop autoshrink if it is on!
John
"Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
news:uRupdzJtFHA.3328@.TK2MSFTNGP11.phx.gbl...
> Hi all -
> Recieve the message
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 09/08/2005
> Time: 10:13:47 AM
> User: N/A
> Computer: JackBox
> Description:
> 17052 :
> Could not adjust the space allocation for file 'Jack_Data_1'.
>
> The machine is win2K sp4 running sql2K sp3. Could not find this error on
> support.microsoft.com - could anyone explain the meaning?
> Thanks.
> Tito
>|||John - Thanks for the link - I really did try the site first, but only got
off-point results.
I did have autoshrink turned on - it is now off - thanks. I also re-index
and integrity check it nightly.
Dave
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23W2cPtKtFHA.3548@.TK2MSFTNGP11.phx.gbl...
> Hi
> Maybe something like:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;254253
> What maintainance are you carrying out?
> You may want to stop autoshrink if it is on!
> John
> "Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
> news:uRupdzJtFHA.3328@.TK2MSFTNGP11.phx.gbl...
> > Hi all -
> >
> > Recieve the message
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 09/08/2005
> > Time: 10:13:47 AM
> > User: N/A
> > Computer: JackBox
> > Description:
> > 17052 :
> > Could not adjust the space allocation for file 'Jack_Data_1'.
> >
> >
> >
> > The machine is win2K sp4 running sql2K sp3. Could not find this error
on
> > support.microsoft.com - could anyone explain the meaning?
> >
> > Thanks.
> >
> > Tito
> >
> >
>|||Hi
I think the message would probably appear whilst an activity was happening
therefore that is why I think it may be autoshink. You don't say how
reguarly this occurred but if you monitor the event file for this you may
see if it happens again.
John
"Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
news:OK%23qYrLtFHA.1136@.TK2MSFTNGP12.phx.gbl...
> John - Thanks for the link - I really did try the site first, but only got
> off-point results.
> I did have autoshrink turned on - it is now off - thanks. I also re-index
> and integrity check it nightly.
> Dave
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23W2cPtKtFHA.3548@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Maybe something like:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;254253
>> What maintainance are you carrying out?
>> You may want to stop autoshrink if it is on!
>> John
>> "Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
>> news:uRupdzJtFHA.3328@.TK2MSFTNGP11.phx.gbl...
>> > Hi all -
>> >
>> > Recieve the message
>> >
>> > Event Type: Information
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 09/08/2005
>> > Time: 10:13:47 AM
>> > User: N/A
>> > Computer: JackBox
>> > Description:
>> > 17052 :
>> > Could not adjust the space allocation for file 'Jack_Data_1'.
>> >
>> >
>> >
>> > The machine is win2K sp4 running sql2K sp3. Could not find this error
> on
>> > support.microsoft.com - could anyone explain the meaning?
>> >
>> > Thanks.
>> >
>> > Tito
>> >
>> >
>>
>
Showing posts with label allocation. Show all posts
Showing posts with label allocation. Show all posts
Sunday, February 19, 2012
Tuesday, February 14, 2012
Corrupted sysindexes
After running the command dbcc checkdb, which is part of a weekly job the following returned
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
Considering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>
|||I'm going to create a DTS package and move the database over to anthor DB.
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend.
There was no going back because a number of days had pasted.
Doing the above DTS method, there is no loss in data.
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
Considering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>
|||I'm going to create a DTS package and move the database over to anthor DB.
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend.
There was no going back because a number of days had pasted.
Doing the above DTS method, there is no loss in data.
Corrupted sysindexes
After running the command dbcc checkdb, which is part of a weekly job the following returne
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2)
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdConsidering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>|||I'm going to create a DTS package and move the database over to anthor DB
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend
There was no going back because a number of days had pasted
Doing the above DTS method, there is no loss in data.
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2)
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdConsidering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>|||I'm going to create a DTS package and move the database over to anthor DB
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend
There was no going back because a number of days had pasted
Doing the above DTS method, there is no loss in data.
Subscribe to:
Posts (Atom)