Re: SQL server 6.5 unable to start

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 10:19:53 +0100

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: Thank you very much...again
    ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | delete..etc permissions on tempdb. ... |>database which would avoid some of this. ...
    (microsoft.public.sqlserver.security)
  • Re: Can I move tempdb?
    ... Tempdb file name changes take affect after SQL Server is restarted and are ... reference posted by details procedures for moving other database files. ... Model isn't used to determine database file locations. ...
    (microsoft.public.sqlserver.server)
  • Re: The log file for database tempdb is full
    ... What would that query have to do with the tempdb ... which are automatically created in the tempdb database. ... Luckyly it is a test server so I have just ...
    (microsoft.public.sqlserver.server)
  • Re: database tempdb is full: Error: 9002, Severity: 17, State: 6
    ... Whatever size and growth increment you set will be the size it gets ... btw. Preferentially you should never see an actual tempdb data ... The log file for database 'tempdb' is full. ... recovery mode and has free space in both .mdf and .ldf files. ...
    (microsoft.public.sqlserver.server)
  • How many logical volumes for large database?
    ... We are about to migrate a large database server onto new ... Logs, and TempDB. ... First, we had four available SCSI channels, so by creating four arrays each ... course TempDB grows and shrinks as needed. ...
    (microsoft.public.sqlserver.server)