Solved

Backing up Sybase database Server using Veeam

Posted on 2014-09-30
3
1,071 Views
Last Modified: 2016-02-25
Hi,

We use Veeam (7.0.0.771) to backup our VMware guests. Our main application server hosts a Sybase database (SQL Anywhere 11).

As far as I am aware SQL Anywhere 11 does not support Microsoft VSS (12 does..) and therefore when Veeam backs up the VM Guest the Sybase database is in a inconsistent state.

I am thinking that I could possibly run a pre-job Veeam script to backup the database using the SQL anywhere 11 native tools and then backup the server (including the backed up database). However, I do not know how to write such script.

Has anyone had similar issues and how can I resolve this?

Thanks, Greg
0
Comment
Question by:spen_lang
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
pgm554 earned 500 total points
ID: 40353466
Says it does support VSS:

http://dcx.sybase.com/1101/en/dbadmin_en11/da-backup-dbs-5615940.html

The VSS Writer is called dbvss11.exe and it is started by default.
0
 

Author Comment

by:spen_lang
ID: 40353988
That's interesting, it does not seem to be running on our server. Do you know how to start it?
0
 
LVL 30

Expert Comment

by:pgm554
ID: 40357284
See if it is in the services in startup and set to run automatically.
Otherwise I would run it as a pre run in Veem to make sure the service is started.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Join & Write a Comment

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

759 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now