Re: How VSS Works with NTBackup
- From: "Paul Shapiro" <paul@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Jun 2007 23:02:01 -0400
I can't point you to a document, but my understanding is that SQL 2000 + SPx
(I forgot which SP you neeed), enabled VSS to backup an open database even
if it's set to Full mode instead of Simple. The same is true for SQL 2005.
VSS interaction is now integrated into SQL Server so VSS can request SQL
Server to reach a consistent on-disk state and then hold off any further
updates until VSS is able to take a db snapshot. If the databases aren't too
large, this is almost instantaneous, and can work even while users are
active. If for some reason it doesn't work correctly you'll see errors in
the Error Log, either from SQL Server or VSS.
Part of the confusion is that VSS is the component that does the shadow file
backups AND it's the component that talks to SQL and Exchange to coordinate
a consistent backup of a running system. These are two separate tasks, even
though they're both done by VSS.
"Richard K" <RichardK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23DB8838-CF7B-4C36-9794-9B7DA7113ED8@xxxxxxxxxxxxxxxx
No problem on the SQL part because I already schedule backups to create
.bak
files. My real concern is with Exchange files and even my WSUS,
MonitoringReporting and Companyweb SQL databases since they are MSDE and I
have not set up backups
I have been successfully using BackupAssist instead of the SBS backup
because of the greater functionality and it uses NTBackup as it's core
engine
to do the backups, they just add more bells and whistles to the process.
If anyone can point me to info on just how VSS works then I'll do the time
to understand it better. I just have not found a great source if info
yet.
Thanks!
"Frank McCallister SBS MVP" wrote:
That is correct for SQL 2000 I believe but I THINK that was changed in
2005
and might have changed in a SP to 2000.
--
Frank McCallister SBS MVP
MCP Microsoft Small Business Specialist
COMPUMAC
"Kevin Weilbacher [SBS-MVP]" <kweilbacMVP@xxxxxxx> wrote in message
news:#Q5qhD8qHHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
to add on to Frank's remark --- I think you need to put SQL into simple
recovery mode --- is that correct Frank?
--
Kevin Weilbacher [SBS-MVP]
"The days pass by so quickly now, the nights are seldom long"
"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
.
- References:
- Re: How VSS Works with NTBackup
- From: Kevin Weilbacher [SBS-MVP]
- Re: How VSS Works with NTBackup
- From: Frank McCallister SBS MVP
- Re: How VSS Works with NTBackup
- From: Richard K
- Re: How VSS Works with NTBackup
- Prev by Date: RE: Event 529 - Internal or External
- Next by Date: RE: Windows XP laptop losing network connection to shared folder
- Previous by thread: Re: How VSS Works with NTBackup
- Next by thread: SBS 2003 Setup.exe vs. Vista
- Index(es):
Relevant Pages
|
