About tempdb

Hi

Being new to SQL server I would like some information regarding the tempdb database.

I user SQL Server 2000.

At present I appear to be backing up my tempdb but it has been failing since way back. It gives me this error when trying to bakup the database:

Executed as user: NT AUTHORITY\SYSTEM. Backup and restore operations are not allowed on database tempdb. [SQLSTATE 42000] (Error 3147) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Can someone give me a basic grounding as to what the tempdb is used for and should I back it up or not?

Thanks in advance

Neil.Sorry ignore this post

about SQL Suspect status

my corporate database appear Suspect status!
and i run sp_resetstatus then stop
last i restart SQL!
but it appear following information:
Could not locate row in sysobjects for system catalog 'Sysobjects' in
database 'NVS1'. This system catalog should exist in all databases. Run DBCC
CHECKTABLE on sysobjects in this database.
what should i do ?Hi Allen,
Your database appears to be corrupted. Do you have backup?
Also you may want to do a hardware diagnostic to look for possible hardware
problem.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||First Thanks your reply!
But,My backup every night! one day has lost!
My God! my salary is reducing? can you help me?
can you give me a plan about how backup so huge database!?
"Yih-Yoon Lee [MS]" <yihyoonl@.online.microsoft.com> wrote in message
news:$tOtmU$YDHA.396@.cpmsftngxa06.phx.gbl...
> Hi Allen,
> Your database appears to be corrupted. Do you have backup?
> Also you may want to do a hardware diagnostic to look for possible
hardware
> problem.
> Sincerely,
> Yih-Yoon Lee [Microsoft]
> Microsoft SQL Server Support
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

about setup

Just appear 'configuration tools' and 'documentation and tutorials' after installed katmai June CTP

OS: WinXP sp2

any idea about this? many thanks

resetup failed,error code is :-2147467259 Message:Unspecified error
Log shown below:
MSI (s) (CC:04) [21:03:16:062]: Note: 1: 1708
MSI (s) (CC:04) [21:03:16:062]: Product: Microsoft SQL Server "Katmai" Tools -- Installation failed.

MSI (s) (CC:04) [21:03:16:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (CC:04) [21:03:16:093]: MainEngineThread is returning 1603
MSI (s) (CC:24) [21:03:16:203]: Destroying RemoteAPI object.
MSI (s) (CC:70) [21:03:16:203]: Custom Action Manager thread ending.
=== Logging stopped: 6/27/2007 21:03:16 ===
MSI (c) (AC:1C) [21:03:16:234]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (AC:1C) [21:03:16:234]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/27/2007 21:03:16 ===

Also, I already uninstalled workstation component of 2005

What's this matter? thanks

|||Well, I think the solution was came from mverun
My VS8 was installed in non-default folder