DBCC error 913

Hi
I am receiving following error while running DBCC through scripts on my
database.
Server: Msg 913, Level 16, State 10, Line 1
Could not find database ID 1128543719. Database may not be activated yet or
may be in transition.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Microsoft KB says that it will be rectified by the installing SQL SP3, but
my SQL server is already having SP3 loaded.
Previously only one database was showing this message, now another databases
is starting showing the same.
When I run DBCC manully i am not receiving any such message.
Nedd help.Does the procedure runs whenever SQL Server starts? if so than it's possible
that the database is in recovery state.
If you are still having problems than please post the following information:
1) Script
2) Where/when are you executing this script
3) What is the database doing during that time.
4) Post SP_Who2 snapshot as well.
Also, I would suggest run SQL Profiler and see what's going on.
HTH
Saleem@.sqlnt.com
"Satyaki" wrote:
> Hi
> I am receiving following error while running DBCC through scripts on my
> database.
> Server: Msg 913, Level 16, State 10, Line 1
> Could not find database ID 1128543719. Database may not be activated yet or
> may be in transition.
> Server: Msg 5069, Level 16, State 1, Line 1
> ALTER DATABASE statement failed.
> Microsoft KB says that it will be rectified by the installing SQL SP3, but
> my SQL server is already having SP3 loaded.
> Previously only one database was showing this message, now another databases
> is starting showing the same.
> When I run DBCC manully i am not receiving any such message.
> Nedd help.|||Hi
Thanks for the response.
The script run on schedule.
There is absolutely no problem with the scripts.
This is simple DBCC script I am running on the server every sunday. The
database is online and in live. I can't provide the scripts, but the script
uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog commands on
each database.
As DBCC runs on single user mode, at that time the database is only used by
the DBCC script.
I can't provide sp_who2 as it run late in night.
I think this much information will help you.
"Saleem Hakani" wrote:
> Does the procedure runs whenever SQL Server starts? if so than it's possible
> that the database is in recovery state.
> If you are still having problems than please post the following information:
> 1) Script
> 2) Where/when are you executing this script
> 3) What is the database doing during that time.
> 4) Post SP_Who2 snapshot as well.
> Also, I would suggest run SQL Profiler and see what's going on.
> HTH
> Saleem@.sqlnt.com
> "Satyaki" wrote:
> > Hi
> > I am receiving following error while running DBCC through scripts on my
> > database.
> >
> > Server: Msg 913, Level 16, State 10, Line 1
> > Could not find database ID 1128543719. Database may not be activated yet or
> > may be in transition.
> > Server: Msg 5069, Level 16, State 1, Line 1
> > ALTER DATABASE statement failed.
> >
> > Microsoft KB says that it will be rectified by the installing SQL SP3, but
> > my SQL server is already having SP3 loaded.
> >
> > Previously only one database was showing this message, now another databases
> > is starting showing the same.
> >
> > When I run DBCC manully i am not receiving any such message.
> > Nedd help.|||I assume that you use ALTER DATABASE to set in single user mode... Can you post that command? What
rollback options are you using?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7362432E-A3EA-440E-B0E7-4E6AC29B60C8@.microsoft.com...
> Hi
> Thanks for the response.
> The script run on schedule.
> There is absolutely no problem with the scripts.
> This is simple DBCC script I am running on the server every sunday. The
> database is online and in live. I can't provide the scripts, but the script
> uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog commands on
> each database.
> As DBCC runs on single user mode, at that time the database is only used by
> the DBCC script.
> I can't provide sp_who2 as it run late in night.
> I think this much information will help you.
> "Saleem Hakani" wrote:
>> Does the procedure runs whenever SQL Server starts? if so than it's possible
>> that the database is in recovery state.
>> If you are still having problems than please post the following information:
>> 1) Script
>> 2) Where/when are you executing this script
>> 3) What is the database doing during that time.
>> 4) Post SP_Who2 snapshot as well.
>> Also, I would suggest run SQL Profiler and see what's going on.
>> HTH
>> Saleem@.sqlnt.com
>> "Satyaki" wrote:
>> > Hi
>> > I am receiving following error while running DBCC through scripts on my
>> > database.
>> >
>> > Server: Msg 913, Level 16, State 10, Line 1
>> > Could not find database ID 1128543719. Database may not be activated yet or
>> > may be in transition.
>> > Server: Msg 5069, Level 16, State 1, Line 1
>> > ALTER DATABASE statement failed.
>> >
>> > Microsoft KB says that it will be rectified by the installing SQL SP3, but
>> > my SQL server is already having SP3 loaded.
>> >
>> > Previously only one database was showing this message, now another databases
>> > is starting showing the same.
>> >
>> > When I run DBCC manully i am not receiving any such message.
>> > Nedd help.|||Hi
I had written a script which take one database at a time and alter it to
single user mode and perform DBCC checking.
I am using sp_dboption dbname,'single user',true command.
There is no explicit rollback option set for performing DBCC.
"Tibor Karaszi" wrote:
> I assume that you use ALTER DATABASE to set in single user mode... Can you post that command? What
> rollback options are you using?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7362432E-A3EA-440E-B0E7-4E6AC29B60C8@.microsoft.com...
> > Hi
> > Thanks for the response.
> >
> > The script run on schedule.
> > There is absolutely no problem with the scripts.
> > This is simple DBCC script I am running on the server every sunday. The
> > database is online and in live. I can't provide the scripts, but the script
> > uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog commands on
> > each database.
> > As DBCC runs on single user mode, at that time the database is only used by
> > the DBCC script.
> > I can't provide sp_who2 as it run late in night.
> >
> > I think this much information will help you.
> > "Saleem Hakani" wrote:
> >
> >> Does the procedure runs whenever SQL Server starts? if so than it's possible
> >> that the database is in recovery state.
> >>
> >> If you are still having problems than please post the following information:
> >>
> >> 1) Script
> >> 2) Where/when are you executing this script
> >> 3) What is the database doing during that time.
> >> 4) Post SP_Who2 snapshot as well.
> >>
> >> Also, I would suggest run SQL Profiler and see what's going on.
> >>
> >> HTH
> >> Saleem@.sqlnt.com
> >>
> >> "Satyaki" wrote:
> >>
> >> > Hi
> >> > I am receiving following error while running DBCC through scripts on my
> >> > database.
> >> >
> >> > Server: Msg 913, Level 16, State 10, Line 1
> >> > Could not find database ID 1128543719. Database may not be activated yet or
> >> > may be in transition.
> >> > Server: Msg 5069, Level 16, State 1, Line 1
> >> > ALTER DATABASE statement failed.
> >> >
> >> > Microsoft KB says that it will be rectified by the installing SQL SP3, but
> >> > my SQL server is already having SP3 loaded.
> >> >
> >> > Previously only one database was showing this message, now another databases
> >> > is starting showing the same.
> >> >
> >> > When I run DBCC manully i am not receiving any such message.
> >> > Nedd help.
>
>|||Hi
Sorry, i had given only half of the details you asked for, yes I am using
alter database command
that is
alter database ' + convert(varchar,@.dbname ) + ' set single_user with
ROLLBACK IMMEDIATE
Then I run the command sp_dboption dbname,'Single user',true also.
this command runs inside a cursor and DBCC checkdb commands starts after that.
"Tibor Karaszi" wrote:
> I assume that you use ALTER DATABASE to set in single user mode... Can you post that command? What
> rollback options are you using?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7362432E-A3EA-440E-B0E7-4E6AC29B60C8@.microsoft.com...
> > Hi
> > Thanks for the response.
> >
> > The script run on schedule.
> > There is absolutely no problem with the scripts.
> > This is simple DBCC script I am running on the server every sunday. The
> > database is online and in live. I can't provide the scripts, but the script
> > uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog commands on
> > each database.
> > As DBCC runs on single user mode, at that time the database is only used by
> > the DBCC script.
> > I can't provide sp_who2 as it run late in night.
> >
> > I think this much information will help you.
> > "Saleem Hakani" wrote:
> >
> >> Does the procedure runs whenever SQL Server starts? if so than it's possible
> >> that the database is in recovery state.
> >>
> >> If you are still having problems than please post the following information:
> >>
> >> 1) Script
> >> 2) Where/when are you executing this script
> >> 3) What is the database doing during that time.
> >> 4) Post SP_Who2 snapshot as well.
> >>
> >> Also, I would suggest run SQL Profiler and see what's going on.
> >>
> >> HTH
> >> Saleem@.sqlnt.com
> >>
> >> "Satyaki" wrote:
> >>
> >> > Hi
> >> > I am receiving following error while running DBCC through scripts on my
> >> > database.
> >> >
> >> > Server: Msg 913, Level 16, State 10, Line 1
> >> > Could not find database ID 1128543719. Database may not be activated yet or
> >> > may be in transition.
> >> > Server: Msg 5069, Level 16, State 1, Line 1
> >> > ALTER DATABASE statement failed.
> >> >
> >> > Microsoft KB says that it will be rectified by the installing SQL SP3, but
> >> > my SQL server is already having SP3 loaded.
> >> >
> >> > Previously only one database was showing this message, now another databases
> >> > is starting showing the same.
> >> >
> >> > When I run DBCC manully i am not receiving any such message.
> >> > Nedd help.
>
>|||Several questions:
1) why are you setting the db to single-user mode at all? CHECKDB runs
online. I can only assume you're running repair without looking at any
problems that may be found - this is a very bad idea.
2) You don't need to run DBCC CHECKALLOC as well as DBCC CHECKDB - CHECKDB
incorporates all the functionality of CHECKALLOC
Thanks
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:0B799A97-4BAE-450B-82C8-6A5BD4B1D247@.microsoft.com...
> Hi
> Sorry, i had given only half of the details you asked for, yes I am using
> alter database command
> that is
> alter database ' + convert(varchar,@.dbname ) + ' set single_user with
> ROLLBACK IMMEDIATE
> Then I run the command sp_dboption dbname,'Single user',true also.
> this command runs inside a cursor and DBCC checkdb commands starts after
that.
> "Tibor Karaszi" wrote:
> > I assume that you use ALTER DATABASE to set in single user mode... Can
you post that command? What
> > rollback options are you using?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > news:7362432E-A3EA-440E-B0E7-4E6AC29B60C8@.microsoft.com...
> > > Hi
> > > Thanks for the response.
> > >
> > > The script run on schedule.
> > > There is absolutely no problem with the scripts.
> > > This is simple DBCC script I am running on the server every sunday.
The
> > > database is online and in live. I can't provide the scripts, but the
script
> > > uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog
commands on
> > > each database.
> > > As DBCC runs on single user mode, at that time the database is only
used by
> > > the DBCC script.
> > > I can't provide sp_who2 as it run late in night.
> > >
> > > I think this much information will help you.
> > > "Saleem Hakani" wrote:
> > >
> > >> Does the procedure runs whenever SQL Server starts? if so than it's
possible
> > >> that the database is in recovery state.
> > >>
> > >> If you are still having problems than please post the following
information:
> > >>
> > >> 1) Script
> > >> 2) Where/when are you executing this script
> > >> 3) What is the database doing during that time.
> > >> 4) Post SP_Who2 snapshot as well.
> > >>
> > >> Also, I would suggest run SQL Profiler and see what's going on.
> > >>
> > >> HTH
> > >> Saleem@.sqlnt.com
> > >>
> > >> "Satyaki" wrote:
> > >>
> > >> > Hi
> > >> > I am receiving following error while running DBCC through scripts
on my
> > >> > database.
> > >> >
> > >> > Server: Msg 913, Level 16, State 10, Line 1
> > >> > Could not find database ID 1128543719. Database may not be
activated yet or
> > >> > may be in transition.
> > >> > Server: Msg 5069, Level 16, State 1, Line 1
> > >> > ALTER DATABASE statement failed.
> > >> >
> > >> > Microsoft KB says that it will be rectified by the installing SQL
SP3, but
> > >> > my SQL server is already having SP3 loaded.
> > >> >
> > >> > Previously only one database was showing this message, now another
databases
> > >> > is starting showing the same.
> > >> >
> > >> > When I run DBCC manully i am not receiving any such message.
> > >> > Nedd help.
> >
> >
> >|||Thank you Paul
To answer your queries:
1. Yes, I am running DBCC Checkdb with repair_rebuild option. I will
definitly try to change the same.
2. I will check that.
But why this error is comming?, is it a bug, because when i run DBCC checkdb
on the database manually it is not giving any error. Can you help me?
Regards
"Paul S Randal [MS]" wrote:
> Several questions:
> 1) why are you setting the db to single-user mode at all? CHECKDB runs
> online. I can only assume you're running repair without looking at any
> problems that may be found - this is a very bad idea.
> 2) You don't need to run DBCC CHECKALLOC as well as DBCC CHECKDB - CHECKDB
> incorporates all the functionality of CHECKALLOC
> Thanks
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:0B799A97-4BAE-450B-82C8-6A5BD4B1D247@.microsoft.com...
> > Hi
> > Sorry, i had given only half of the details you asked for, yes I am using
> > alter database command
> > that is
> > alter database ' + convert(varchar,@.dbname ) + ' set single_user with
> > ROLLBACK IMMEDIATE
> > Then I run the command sp_dboption dbname,'Single user',true also.
> >
> > this command runs inside a cursor and DBCC checkdb commands starts after
> that.
> >
> > "Tibor Karaszi" wrote:
> >
> > > I assume that you use ALTER DATABASE to set in single user mode... Can
> you post that command? What
> > > rollback options are you using?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > > news:7362432E-A3EA-440E-B0E7-4E6AC29B60C8@.microsoft.com...
> > > > Hi
> > > > Thanks for the response.
> > > >
> > > > The script run on schedule.
> > > > There is absolutely no problem with the scripts.
> > > > This is simple DBCC script I am running on the server every sunday.
> The
> > > > database is online and in live. I can't provide the scripts, but the
> script
> > > > uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog
> commands on
> > > > each database.
> > > > As DBCC runs on single user mode, at that time the database is only
> used by
> > > > the DBCC script.
> > > > I can't provide sp_who2 as it run late in night.
> > > >
> > > > I think this much information will help you.
> > > > "Saleem Hakani" wrote:
> > > >
> > > >> Does the procedure runs whenever SQL Server starts? if so than it's
> possible
> > > >> that the database is in recovery state.
> > > >>
> > > >> If you are still having problems than please post the following
> information:
> > > >>
> > > >> 1) Script
> > > >> 2) Where/when are you executing this script
> > > >> 3) What is the database doing during that time.
> > > >> 4) Post SP_Who2 snapshot as well.
> > > >>
> > > >> Also, I would suggest run SQL Profiler and see what's going on.
> > > >>
> > > >> HTH
> > > >> Saleem@.sqlnt.com
> > > >>
> > > >> "Satyaki" wrote:
> > > >>
> > > >> > Hi
> > > >> > I am receiving following error while running DBCC through scripts
> on my
> > > >> > database.
> > > >> >
> > > >> > Server: Msg 913, Level 16, State 10, Line 1
> > > >> > Could not find database ID 1128543719. Database may not be
> activated yet or
> > > >> > may be in transition.
> > > >> > Server: Msg 5069, Level 16, State 1, Line 1
> > > >> > ALTER DATABASE statement failed.
> > > >> >
> > > >> > Microsoft KB says that it will be rectified by the installing SQL
> SP3, but
> > > >> > my SQL server is already having SP3 loaded.
> > > >> >
> > > >> > Previously only one database was showing this message, now another
> databases
> > > >> > is starting showing the same.
> > > >> >
> > > >> > When I run DBCC manully i am not receiving any such message.
> > > >> > Nedd help.
> > >
> > >
> > >
>
>|||Something's definitely screwed up as database IDs can't go that high. I
suggest you contact Product Support (http://support.microsoft.com)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:BF60B134-A8E3-4CB6-9F01-E7D1F50FA79C@.microsoft.com...
> Thank you Paul
> To answer your queries:
> 1. Yes, I am running DBCC Checkdb with repair_rebuild option. I will
> definitly try to change the same.
> 2. I will check that.
> But why this error is comming?, is it a bug, because when i run DBCC
checkdb
> on the database manually it is not giving any error. Can you help me?
> Regards
>
> "Paul S Randal [MS]" wrote:
> > Several questions:
> > 1) why are you setting the db to single-user mode at all? CHECKDB runs
> > online. I can only assume you're running repair without looking at any
> > problems that may be found - this is a very bad idea.
> > 2) You don't need to run DBCC CHECKALLOC as well as DBCC CHECKDB -
CHECKDB
> > incorporates all the functionality of CHECKALLOC
> >
> > Thanks
> >
> > --
> > Paul Randal
> > Dev Lead, Microsoft SQL Server Storage Engine
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > news:0B799A97-4BAE-450B-82C8-6A5BD4B1D247@.microsoft.com...
> > > Hi
> > > Sorry, i had given only half of the details you asked for, yes I am
using
> > > alter database command
> > > that is
> > > alter database ' + convert(varchar,@.dbname ) + ' set single_user with
> > > ROLLBACK IMMEDIATE
> > > Then I run the command sp_dboption dbname,'Single user',true also.
> > >
> > > this command runs inside a cursor and DBCC checkdb commands starts
after
> > that.
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > > > I assume that you use ALTER DATABASE to set in single user mode...
Can
> > you post that command? What
> > > > rollback options are you using?
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > >
> > > >
> > > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > > > news:7362432E-A3EA-440E-B0E7-4E6AC29B60C8@.microsoft.com...
> > > > > Hi
> > > > > Thanks for the response.
> > > > >
> > > > > The script run on schedule.
> > > > > There is absolutely no problem with the scripts.
> > > > > This is simple DBCC script I am running on the server every
sunday.
> > The
> > > > > database is online and in live. I can't provide the scripts, but
the
> > script
> > > > > uses regular DBCC checkdb, DBCC checkalloc and DBCC checkcatalog
> > commands on
> > > > > each database.
> > > > > As DBCC runs on single user mode, at that time the database is
only
> > used by
> > > > > the DBCC script.
> > > > > I can't provide sp_who2 as it run late in night.
> > > > >
> > > > > I think this much information will help you.
> > > > > "Saleem Hakani" wrote:
> > > > >
> > > > >> Does the procedure runs whenever SQL Server starts? if so than
it's
> > possible
> > > > >> that the database is in recovery state.
> > > > >>
> > > > >> If you are still having problems than please post the following
> > information:
> > > > >>
> > > > >> 1) Script
> > > > >> 2) Where/when are you executing this script
> > > > >> 3) What is the database doing during that time.
> > > > >> 4) Post SP_Who2 snapshot as well.
> > > > >>
> > > > >> Also, I would suggest run SQL Profiler and see what's going on.
> > > > >>
> > > > >> HTH
> > > > >> Saleem@.sqlnt.com
> > > > >>
> > > > >> "Satyaki" wrote:
> > > > >>
> > > > >> > Hi
> > > > >> > I am receiving following error while running DBCC through
scripts
> > on my
> > > > >> > database.
> > > > >> >
> > > > >> > Server: Msg 913, Level 16, State 10, Line 1
> > > > >> > Could not find database ID 1128543719. Database may not be
> > activated yet or
> > > > >> > may be in transition.
> > > > >> > Server: Msg 5069, Level 16, State 1, Line 1
> > > > >> > ALTER DATABASE statement failed.
> > > > >> >
> > > > >> > Microsoft KB says that it will be rectified by the installing
SQL
> > SP3, but
> > > > >> > my SQL server is already having SP3 loaded.
> > > > >> >
> > > > >> > Previously only one database was showing this message, now
another
> > databases
> > > > >> > is starting showing the same.
> > > > >> >
> > > > >> > When I run DBCC manully i am not receiving any such message.
> > > > >> > Nedd help.
> > > >
> > > >
> > > >
> >
> >
> >