Solved

Backing up Sybase database Server using Veeam

Posted on 2014-09-30
3
1,265 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
[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
  • 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

688 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