Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL server hangs after nightly maintainence and backup

Posted on 2007-11-27
8
Medium Priority
?
776 Views
Last Modified: 2008-02-04
Hello all
Until recently there were no problems with my companys' SQL server, however lately the services have hung during the night. The backup and maintainence routines are unchanged. Daily maintainence backs up the database's and backup exec does it's job during the night. The application log lists the hang as an EXCEPTION_ACCESS_VIOLATION and I can not get much out of the MSSQL log either only that the maintainence completes and that the exception is caught. No service packs have been applied.

Cheers
Martin
0
Comment
Question by:wyndehamimpact
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 2

Expert Comment

by:lcit
ID: 20357754
Are you doing a full or incremental backup?  Are you using the SQL server agent for Backup Exec?
0
 
LVL 16

Expert Comment

by:SQL_SERVER_DBA
ID: 20358127
select * from master..sysprocesses

look to see what happened prior to hanging
0
 

Author Comment

by:wyndehamimpact
ID: 20358316
Using Back up exec SQL agent

As far as I can see master.sysprocesses only has records since the restart of the MSSQL SERVER and SQLSERVERAGENT.


0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:wyndehamimpact
ID: 20364038
Full backup
0
 

Author Comment

by:wyndehamimpact
ID: 20372746
Ok, so the SQL server crash happens about 15mins after maintainence optimisation is scheduled to start. Deactivating the optimisation, so far, has stopped the problem.
0
 

Accepted Solution

by:
wyndehamimpact earned 0 total points
ID: 20584277
Found the problem. Backup exec was using the SQL server as it's database server. Moved Backup exec database to local MSDE and problem fixed. Incidently default time for Backup exec to maintain the BE database is 4:00am which corrosponded with most of the times the SQL exception was generated, with the exception of those times when the back up ran over.
0
 

Expert Comment

by:AnnieMod
ID: 20813221
PAQ'd and 500 points refunded

AnnieMod
Cleanup Admin
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question