Saturday, February 25, 2012

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

No comments:

Post a Comment