Geek Answers Handbook

Backing up SQL Server with MozyPro

Anyone using MozyPro to back up SQL Server databases?

I am concerned about how he backs up. It simply copies the data files as they are. Do not use the backup database command.

Is it safe?

+4
source share
3 answers

MozyPro uses Volume Shadow Service (VSS) to create backups for SQL Server. SQL Server 2005 has been designed so that VSS backups are consistent. Therefore, this is definitely the right way to back up SQL Server databases.

Here is a white paper on how SQL Server 2005 SQL Writer works with VSS.

Microsoft® SQL Server ™ 2005 provides support for creating snapshots of SQL Server data using Volume Shadow Copy Service (VSS). This is achieved by providing VSS (SQL writer), so that a third-party backup application can use the VSS structure to back up database files. This document describes the SQL Writer component and its role in creating VSS snapshots and recovery for a SQL Server database. It also captures information on how to configure and use SQL writer to work with backing up applications in the context of the VSS framework.

Here is the MozyPro manual (PDF) that describes how to restore SQL Server backups created using VSS.

If you do not trust this method, there is nothing stopping you from setting up the backup task and just making Mozy back up * .bak files.

+4
source

Judging by hell, I'm worried with Mozy right now. NO NO NO! Backups work, theoretically, just not for the recovery part. Mozy's powerful incremental backup system results in recovery, which can take several weeks. Apparently. I am still waiting, despite the fact that they are talking about technical support of their level, more than 10 days have passed.

+1
source

https://github.com/candera/hobocopy

WHY DOES HOCCOPY USE THE TEMPERATURE SERVICE?

Since HoboCopy copies VSS snapshots, it can even copy files that are locked by some other program. Further, some programs (for example, SQL Server 2005) are VSS-aware and will write their state to disk in a consistent state until the snapshot is created, allowing some sort of live backup. Files blocked by VSS-unaware programs will still be copied in a "bad reconciliation" state (that is, it appears on disk). This is usually much better than not being able to copy the file at all.

0
source

More articles:


All Articles