Solved

Backing up Sybase database Server using Veeam

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
virtualized environment servers or physical environment servers? 6 65
esx multi vlans 3 64
Session that filled up my transaction logs 1 40
PowerShell Default Ports 3 28
This is an issue that we can get adding / removing permissions in the vCSA 6.0. We can also have issues searching for users / groups in the AD (using your identify sources). This is how one of the ways to handle this issues and fix it.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

863 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

19 Experts available now in Live!

Get 1:1 Help Now