?
Solved

Acronis TI Echo Server (build8,203) - SQL backup errors but image completes.

Posted on 2009-04-16
3
Medium Priority
?
721 Views
Last Modified: 2016-10-27
My setup: Server 2003 latest sp, ATIEchoS (build8,203), SQL 2005 SP3 upgraded 4-6 weeks ago.

I was not having this issue before the SQL 2005 sp3 upgrade from sp2 that I ever noted in my event logs. Now my app log reports these nightly with the following error types(.txt attached have detailed examples of errros) although Acronis reports that the image completes successfully per the log the next a.m.

Event ID errors SOURCES: SQLWriter(Evt ID 24583), MSSQLSERVER(Evt ID 18210 & 3041), SQLVDI(Evt ID 1), VSS.... @ 8:00:33 pm est when the acronis schedule task starts nightly, which is set with the backup enabled for VSS DB support.

How reliable are my images? Thoughts?  Thx
CW-appEvtLogLIst.bmp
CWFL-VSS-EVTDETAILS.txt
AppEventLog-Acronis-VSS-SQL-Erro.txt
0
Comment
Question by:dee30
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
ComputerTechie earned 1500 total points
ID: 24171955
We run this command before running the backup on our

sc stop sqlserveragent
@ECHO OFF
SET NUM=1
:LOOP
IF %NUM% == 6000 GOTO END1
SET /A NUM=NUM+1
GOTO LOOP
:END1
@ECHO ON
sc stop mssqlserver
@ECHO OFF
SET NUM=1
:LOOP2
IF %NUM% == 6000 GOTO END2
SET /A NUM=NUM+1
GOTO LOOP2
:END2
@ECHO ON
after backup is done we run this
 
sc.exe start mssqlserver
@ECHO OFF
SET NUM=1
:LOOP
IF %NUM% == 6000 GOTO END
SET /A NUM=NUM+1
GOTO LOOP
:END
@ECHO ON
sc.exe start sqlserveragent
both are in a batch file and ran with our acronis backup server.
We found we could backup our mssql server faster this way.
You could also put in an ticket with acronis they are quick to respond to new issues.
CT
0
 

Author Comment

by:dee30
ID: 24172160
If i do the above i'm stopping sql and preventing users from using the CRM app while the image is running.   That all said has anyone seen these errrors and been told to ignore them?  I asked b/c i've read things on google.com indicating so, but I wanted to ask around for more insights!
0
 

Author Closing Comment

by:dee30
ID: 31571018
Thanks for taking the time.
0
Question has a verified solution.

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

Check out what's been happening in the Experts Exchange community.
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.

839 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