Re: DBCC error 913

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

Date: Sun, 12 Sep 2004 21:29:02 -0700

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: problem with DBD::Oracle
    ... Next, if it runs from the command line, then you most likely have a permissions issue with either the Perl script itself, or the Oracle.so library. ... Oracle database that is on a different machine. ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • Re: mysql connection failing as CGI
    ... some new hosting which comes with a MySQL database but I'm struggling ... to get it working with any perl scripts; the hosting support are being ... The problem basically is that when the script is run as a CGI script it ... the command line it runs fine. ...
    (comp.lang.perl.misc)
  • 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)
  • mysql connection failing as CGI
    ... some new hosting which comes with a MySQL database but I'm struggling ... to get it working with any perl scripts; the hosting support are being ... The problem basically is that when the script is run as a CGI script it ... the command line it runs fine. ...
    (comp.lang.perl.misc)
  • Re: How do I Edit a list of files associated with a product ?
    ... So it succesfully adds the product and the files in a database and the filesystem. ... and you have done something like that or you know a url or script that does that, ... Just build an edit command with the selected file name and ... you better check out the syntax for the exec command since it has additional parameters. ...
    (comp.lang.php)