Re: DBCC error 913

From: satyaki (satyaki_at_discussions.microsoft.com)
Date: 09/13/04 

Date: Sun, 12 Sep 2004 21:17:11 -0700

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.
>
>
>

Relevant Pages

  • Re: DBCC error 913
    ... You don't need to run DBCC CHECKALLOC as well as DBCC CHECKDB - CHECKDB ... >> I assume that you use ALTER DATABASE to set in single user mode... ... >>> This is simple DBCC script I am running on the server every sunday. ...
    (microsoft.public.sqlserver.server)
  • Re: torn page
    ... It is not required to make the SQL Server to start in single user mode. ... the DBCC with Rebuild option to sinlge user. ... How to make database to single user:- ...
    (microsoft.public.sqlserver.server)
  • Re: DBCC error 913
    ... I assume that you use ALTER DATABASE to set in single user mode... ... > This is simple DBCC script I am running on the server every sunday. ... >> Does the procedure runs whenever SQL Server starts? ...
    (microsoft.public.sqlserver.server)
  • Re: DBCC error 913
    ... 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. ... >> This is simple DBCC script I am running on the server every sunday. ... >> database is online and in live. ...
    (microsoft.public.sqlserver.server)
  • RE: DBCC error 913
    ... This is simple DBCC script I am running on the server every sunday. ... database is online and in live. ... >> is starting showing the same. ...
    (microsoft.public.sqlserver.server)
Loading