Database tables interrupted…..

8035 pts.
Tags:
SQL Server
SQL Server errors
Any input at all would be greatly appreciated - All I know is that a companywe provide IT Support to had 4 databases running when the SQL services were shut down on the server. Now the fellow cannot see any of his tables – nothing shows up when he opens SQL, or in his ODBC network connections. (Server has since been rebooted twice) Our SQL genius is out of town at the moment, so I am at a loss on what I can do to help???

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do the databases show up as suspect? Can you post the ERRORLOG from the server?

Without more information, no positive diagnosis can be made.
*********************************************************************************************************************
Thanks for responding. I tried to clean this up for the easiest viewing, without disturbing any of the information that was in the report.

Report created on 8/15/2008 at 6:00 AM

________________________________

Summary for (SERVERNAME)

Server has been running: 0 days and 19 hours

Server Specifications

Details

Performance Summary

Details

Top Processes

Details

Backup: Not configured

Details

Auto-started Services Not Running: 0

Details

Critical Alerts: 2

Details

Critical Errors in the Event Logs: 61

Details

Details of (SERVERNAM)

________________________________

Server Specifications

Operating System: Microsoft(R) Windows(R) Server 2003 for Small Business Server Service Pack 2

Processor: Intel(R) Xeon(R) CPU 3060 @ 2.40GHz, Intel(R) Xeon(R) CPU 3060 @ 2.40GHz

Frequency: 2.4 GHz, 2.4 GHz

Amount of RAM: 3584 MB

Performance Summary

Performance Counters

Today

Last Month

Rate of Growth

Memory in use

1,605 MB

1,655 MB

-3 %

Free disk space (C:)

220,333 MB

224,716 MB

-2 %

Busy disk time (0 C:)

33 %

39 %

-16 %

CPU Use (0)

4 %

7 %

-46 %

CPU Use (1)

2 %

6 %

-59 %

Top 5 Processes by Memory Usage

Process Name – ID

Memory Usage

store – 3800

676 MB

store – 3876

620 MB

store – 3380

620 MB

sqlservr – 1792

199 MB

sqlservr – 436

105 MB

Top 5 Processes by CPU Usage

Process Name – ID

CPU Time

store – 3380

5.7 %

cidaemon – 6068

1.0 %

msiexec – 1944

0.9 %

svchost – 928

0.8 %

svchost – 892

0.7 %

Backup

Result

Last Occurrence

Small Business Server Backup is not configured. To configure backup, click the Backup snap-in in Server Management, and then click Configure Backup.

Not applicable

Auto-started Services Not Running

All services configured to start automatically are running.

Critical Alerts

Issue

Last Occurrence

Total Occurrences

System Up Time

8/14/2008 10:58 AM

2

The server restarted. If this event was not planned, check the Server Performance Report and Event Logs for information that can help explain the event.

You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad.

Critical Errors in Application Log

Source

Event ID

Last Occurrence

Total Occurrences

SQLAgent$SHAREPOINT

324

8/14/2008 3:43 PM

2 *

SQLAgent is not allowed to run.

Source

Event ID

Last Occurrence

Total Occurrences

MSSQL$BKUPEXEC

18456

8/14/2008 2:03 PM

14 *

Login failed for user (username)

Source

Event ID

Last Occurrence

Total Occurrences

MSExchangeIS

1194

8/14/2008 10:53 AM

2 *

Accept clients on external interface MAPIRPC failed with error 0x4b1. For more information, click http://www.microsoft.com/contentredirect.asp.

Source

Event ID

Last Occurrence

Total Occurrences

Windows SharePoint Services 2.0

1000

8/14/2008 10:52 AM

6 *

#50070: Unable to connect to the database STS_Config on (SERVERNAME\)SharePoint. Check the database connection information and make sure that the database server is running.

Source

Event ID

Last Occurrence

Total Occurrences

POPBeamer

6

8/14/2008 9:28 AM

2 *

Host:( mail.namefield.ca Mailbox:client.mailbox) Error: Unable to convert hostname to IP address ( no answer from DNS server ) [3]

Source

Event ID

Last Occurrence

Total Occurrences

dsrestor

1005

8/14/2008 9:20 AM

1

The DSRestore Filter failed to connect to local SAM server. Error returned is <id:0>.

Source

Event ID

Last Occurrence

Total Occurrences

MSExchangeAL

8026

8/14/2008 9:20 AM

3 *

LDAP Bind was unsuccessful on directory (servername).local for distinguished name ”. Directory returned error:[0x51] Server Down. For more information, click http://www.microsoft.com/contentredirect.asp.

Source

Event ID

Last Occurrence

Total Occurrences

MSExchangeAL

8250

8/14/2008 9:20 AM

1

The Win32 API call ‘DsGetDCNameW’ returned error code [0x862] The specified component could not be found in the configuration information. The service could not be initialized. Make sure that the operating system was installed properly. For more information, click http://www.microsoft.com/contentredirect.asp.

Source

Event ID

Last Occurrence

Total Occurrences

MSExchangeDSAccess

2102

8/14/2008 9:20 AM

1

Process MAD.EXE (PID=3012). All Domain Controller Servers in use are not responding: (servername).local For more information, click http://www.microsoft.com/contentredirect.asp.

Source

Event ID

Last Occurrence

Total Occurrences

Backup Exec

33152

8/14/2008 6:36 AM

2 *

Small Business Server cannot display a description for this event. For more information, see the Event Log.

Source

Event ID

Last Occurrence

Total Occurrences

MsiInstaller

11706

8/14/2008 6:28 AM

1

Product: Symantec Backup Exec for Windows Servers — Error 1706.No valid source could be found for product Symantec Backup Exec for Windows Servers. The Windows Installer cannot continue.

* The text shown is for the most recent occurrence of this event. For more information, see the Event log.

Critical Errors in Directory Service Log

There were no critical events in the Directory Service Log in the last 24 hours.

Critical Errors in DNS Server Log

There were no critical events in the DNS Server Log in the last 24 hours.

Critical Errors in File Replication Service Log

There were no critical events in the File Replication Service Log in the last 24 hours.

Critical Errors in Internet Explorer Log

There were no critical events in the Internet Explorer Log in the last 24 hours.

Critical Errors in Security Log

Source

Event ID

Last Occurrence

Total Occurrences

Security

537

8/14/2008 11:31 AM

3 *

Logon Failure:

Reason:

An error occurred during logon

User Name:

(username)

Domain:

(Domain name)

Logon Type:

3

Logon Process:

Kerberos

Authentication Package:

Kerberos

Workstation Name:
-

Status code:

0xC00002EE

Substatus code:

0×0

Caller User Name:

-
Caller Domain:

-
Caller Logon ID:

-
Caller Process ID:

-
Transited Services:

-
Source Network Address:

-
Source Port:

-
Source

Event ID

Last Occurrence

Total Occurrences

Security

529

8/14/2008 10:57 AM

6 *

Logon Failure:

Reason:

Unknown user name or bad password

User Name:

(username)

Domain:

(Domain name)

Logon Type:

2

Logon Process:

User32

Authentication Package:

Negotiate

Workstation Name:

(computer name)

Caller User Name:

(SERVERNAME)$

Caller Domain:

(Domain Name)

Caller Logon ID:

(0×0,0x3E7)

Caller Process ID:

380

Transited Services:
-

Source Network Address:

127.0.0.1

Source Port:

0

* The text shown is for the most recent occurrence of this event. For more information, see the Event log.

Critical Errors in System Log

Source

Event ID

Last Occurrence

Total Occurrences

Removable Storage Service

15

8/14/2008 10:00 PM

1

RSM cannot manage library Tape0. The database is corrupt.

Source

Event ID

Last Occurrence

Total Occurrences

TermServDevices

1111

8/14/2008 9:06 PM

11 *

Driver Acrobat PDFWriter required for printer Acrobat PDFWriter is unknown. Contact the administrator to install the driver before you log in again.

Source

Event ID

Last Occurrence

Total Occurrences

Service Control Manager

7011

8/14/2008 9:02 AM

2 *

Timeout (30000 milliseconds) waiting for a transaction response from the NtFrs service.

Source

Event ID

Last Occurrence

Total Occurrences

TermService

1041

8/14/2008 7:04 AM

1

Autoreconnect failed to reconnect user to session because authentication failed. (0×0)

Source

Event ID

Last Occurrence

Total Occurrences

halfinchVRTS

7

8/14/2008 6:36 AM

2 *

The device, \Device\Tape0, has a bad block.

* The text shown is for the most recent occurrence of this event. For more information, see the Event log.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following