Re: DBCC error 913

From: Paul S Randal [MS] (prandal_at_online.microsoft.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 10:09:24 -0700

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

Relevant Pages

  • 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)
  • Re: DBCC error 913
    ... I had written a script which take one database at a time and alter it to ... There is no explicit rollback option set for performing DBCC. ... >> As DBCC runs on single user mode, at that time the database is only used by ...
    (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: Disaster freeing space in 200GB database
    ... Run DBCC UPDATEUSAGE to make sure you are seeing accurate information. ... DBCC SHRINKFILE since it gives me a finer degree of control. ... Senior Database Administrator ... data file increased by the amount of data deleted. ...
    (microsoft.public.sqlserver.server)