Re: How VSS Works with NTBackup
- From: "Frank McCallister SBS MVP" <anonymous>
- Date: Sun, 10 Jun 2007 16:38:43 -0500
A better solution to SQL Database Backup is to go into SQL Enterprise Manager and schedule a Backup to run prior to the daily SBS total backup so that SBS Backup will backup the SQL .bak files which proveide a better restore capability for SQL Databases.
--
Frank McCallister SBS MVP
MCP Microsoft Small Business Specialist
COMPUMAC
"Richard K" <RichardK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D579E1AD-A38D-4FF9-B3E4-5FFF41F29629@xxxxxxxxxxxxxxxx
Hopefully a simple question rethorical question here. Tell me if I.
understand this correctly.
First the obvious, when I do a nightly backup of my entire drive I assume
all files are backed up, excluding any files that may not have an exclusive
lock (such as Exchange and SQL databases). This is where VSS comes into
play. If the nightly backup tries to backup open files and fails it then
goes to the most recent VSS shapshot to grab a copy of the files. Thus if i
do the normal 7am - 12pm snapshots and I do backups at 10pm... if it fails on
one of my SQL mdf/ldf files it will then to to the 12pm snapshot for those
files, thus I would only be out as much as 10 hours of data (10pm vs 12pm
snapshot). I also need to make sure that VSS is turned on for the volume
getting backed up (c: drive) which I'm pretty sure SBS turns on by default
but I have verified.
Do I have this right or am I misunderstanding something? Also does VSS do a
complete volumn snapshot or only data contained in a share? I would think
since there is a hidden c$ share that the entire c: would be snapshotted.
Thanks!
-Richard K
- Prev by Date: Re: SBS 2k3 testing , demo evaluation ect
- Next by Date: Re: Security Certificate for SBS 03
- Previous by thread: active directory migration
- Next by thread: Re: How VSS Works with NTBackup
- Index(es):
Relevant Pages
|
