Re: SQL server 6.5 unable to start

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 16:32:14 +0530

Hi,

To add on to Tibors post,

Steps

1. Start the SQL server in Minimal mode (-c -f)

2. Execute the below script in ISQLW

  sp_configure 'tempdb in ram (MB)',20
  go
  reconfigure with override

3. Restart SQL server in Normal mode

4. Once the SQL Server comes up again then execute the below script

5. sp_configure 'tempdb in ram (MB)',0
      go
      reconfigure with override

6. Restart SQL server in Normal mode

After this you can expand the tempdb by adding new devices.

Thanks
Hari
MCDBA

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:u9d7s6mCEHA.4080@TK2MSFTNGP09.phx.gbl...
> There is no repair option in 6.5 for CHECKDB.But you don't need one. Just
> put tempdb in RAM (start in minimum mode, sp_configure to put in ram).
When
> you them put it on disk again, it will allocate default database size from
> default database device.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "David" <anonymous@discussions.microsoft.com> wrote in message
> news:a34201c40a6b$df8fd3e0$a601280a@phx.gbl...
> > Hi Hari,
> >
> > I had the error "Unable to find database table id=2,
> > name 'tempdb'" in isql window after running the
> > sp_configure command.
> >
> > FYI my tempdb has it's 700mb data file (device 5) in C:
> > drive and it's 100mb log file (device 6) in D: drive.
> >
> > I had run the DBCC checkdb, checktable and it states that
> > it could not locate row sysobject table in tempdb. I am
> > not able to use the tempdb database.
> > Does SQL 6.5 supports "DBCC checkdb ('tempdb',
> > FAST_REPAIR)". It does not seems to recognise the
> > FAST_REPAIR option.
> >
> > Is there anyway to fix the sysobject table?
> >
> > thanks
> >
> > >-----Original Message-----
> > >Hi,
> > >
> > >It seems that there is some problem in TEMPDB database (
> > Device might be
> > >missing) . To overcome this,
> > >
> > >1. Start the SQL server in Minimal mode (-c -f)
> > >2. Execute the below script in ISQLW
> > >
> > > sp_configure 'tempdb in ram (MB)',20
> > > go
> > > reconfigure with override
> > >
> > >3. Restart SQL server in Normal mode
> > >4. After this Recreate the TEMPDB database or
> > >
> > >What is a device?
> > >
> > >A file in which databases are stored. One database can be
> > stored on several
> > >devices. There are two types of devices: database
> > devices, which store
> > >databases, and dump devices, which store backups of a
> > database
> > >
> > >
> > >Have a look into the below article
> > >
> > >http://support.microsoft.com/default.aspx?scid=kb;en-
> > us;193453
> > >
> > >Thanks
> > >Hari
> > >MCDBA
> > >
> > >
> > >
> > >
> > >
> > >"David" <none@pacific.net.sg> wrote in message
> > >news:O7cp8WiCEHA.1548@TK2MSFTNGP12.phx.gbl...
> > >> I had started my SQL server 6.5 in WinNT 4 server
> > (SP6a) in minimum mode.
> > >> After shutting it down, I restarted it on the service
> > GUI.
> > >> Apparently it could not be started and run into this
> > problem (See log
> > >below)
> > >>
> > >> 2004/03/14 15:56:29.87 spid1 Clearing temp db
> > >> 2004/03/14 15:56:29.87 kernel udread: Operating
> > system error 6(The
> > >handle
> > >> is invalid.) on device '' (virtpage 0xffffffff).
> > >> 2004/03/14 15:56:29.87 spid1 Error : 840, Severity:
> > 17, State: 2
> > >> 2004/03/14 15:56:29.87 spid1 Device '(vdn 0xff not
> > found)' (with
> > >physical
> > >> name '', and virtual device number 255) is not
> > available. Please contact
> > >> System Administrator for assistance.
> > >> 2004/03/14 15:56:29.87 kernel Failed to create temp db
> > >>
> > >> What is device ''?
> > >> Appreciate if anyone can help
> > >>
> > >>
> > >
> > >
> > >.
> > >
>
>

Relevant Pages

  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... You cannot set the recovery model in tempdb. ... Columnist, SQL Server Professional ... We would then have to issue an alter database ...
    (microsoft.public.sqlserver.server)
  • Re: db library error ?
    ... Tibor Karaszi, SQL Server MVP ... > the following error message apeared: ... > The log file for database 'tempdb' is full. ...
    (microsoft.public.sqlserver.server)
  • RE: ASPState Bug/Security issue
    ... I accept that my *state* doesn't persist after sql server ... after a sql server restart EVEN IF YOU DON'T CARE THAT ... Microsoft's guidelines for how to access tempdb properly, ... to resolve it is to use persiststate version. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Error Granting DB / Role Access
    ... Jasper Smith (SQL Server MVP) ... > the database or object owner (within tempdb) even though they have DBO ...
    (microsoft.public.sqlserver.security)
  • Re: Computed columns in temp tables
    ... create the function in tempdb whenever SQL Server is started. ... will not just disappear from tempdb once you have created it, ... >> Now using another database u can call this function during temp table ... >>> How can I create a function in tempdb while inside a stored procedure? ...
    (microsoft.public.sqlserver.datamining)