|
Replies:
7
-
Pages:
1
-
Last Post:
Dec 17, 2009 7:47 AM
by: jphillips
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
35
Registered:
12/14/09
|
|
|
|
VSS in 4.2 DPP
Posted:
Dec 14, 2009 2:04 AM
|
|
|
Hi Guys
First post on the forum, I was just wondering;
In version 3.x, there was a checkbox with the option to enable or disable VSS for your job.
In version 4.x, this checkbox is no longer present.
I am researching the backup of our SQL servers and was wondering how I would enable VSS?
Is it a case of ensuring that the Volume Shadow Copy Service is set to automatic within Windows Services?
|
|
|
Posts:
62
Registered:
9/7/07
|
|
|
|
Re: VSS in 4.2 DPP
Posted:
Dec 14, 2009 8:44 AM
in response to: goodchildc
|
 |
Helpful |
|
|
The recommendation in Ranger 4.2 is to utilize VSS thru the VMWare tools on the actual VM, and to enable guest quiescing when setting up the backup job in the Ranger GUI.
To enable VMWare's VSS, do the following:
Log into the VM you are going to backup, in this case a SQL box.
Go to Add/ Remove Programs
Locate VMWare Tools
Click on the modify button.
This will bring up the VMWare tools.
From this view, you can install VMWare's VSS on the VM.
Once VSS is installed, you can go into the Ranger GUI to create the backup job.
When you get to the options, you should check the box to enable guest quiescing.
|
|
|
Posts:
35
Registered:
12/14/09
|
|
|
Posts:
62
Registered:
9/7/07
|
|
|
|
Re: VSS in 4.2 DPP
Posted:
Dec 15, 2009 8:26 AM
in response to: goodchildc
|
|
|
Running backups with quiescing disabled is not an 'incorrect' function, however, utilizing VSS offers more db specific protections in that VSS freezes the db during snapshotting to help prevent corruption during the snapshotting process. Disabled guest quiescing prevents VMWare from freezing the VMs OS during the snapshotting process.
|
|
|
Posts:
35
Registered:
12/14/09
|
|
|
|
Re: VSS in 4.2 DPP
Posted:
Dec 16, 2009 10:08 AM
in response to: goodchildc
|
|
|
Thanks for your replies mate, much appreciated.
So from past experience, what options have you guys selected when backing up a full MSSQL Database Server (not the MSDE engine)?
At the moment I have been backing up with quiescing disabled, as per the document I found and linked above, but I am beginning to think this may not be the best way?
I am going to be testing the restore of one of our SQL servers tomorrow so I will let you know how I get on.
thanks again for the reply 
|
|
|
Posts:
62
Registered:
9/7/07
|
|
|
|
Re: VSS in 4.2 DPP
Posted:
Dec 16, 2009 1:51 PM
in response to: goodchildc
|
 |
Answered |
|
|
For a SQL db server in Ranger 4.2, we would recommend enabling quiescing, and installing the VMWare VSS tool for use when backing up.
|
|
|
Posts:
35
Registered:
12/14/09
|
|
|
|
Re: VSS in 4.2 DPP
Posted:
Dec 17, 2009 12:32 AM
in response to: jphillips
|
|
|
jphillips thanks for your help :)
Just for your information, I restored my backup with quescing disabled and it did return to a crash consistent state (Windows asked why the server had shutdown unexpectedly)
I am backing up with quiescing enabled now, how should I expect the server react when powering on? Normal boot (splash screen etc) or as described above?
|
|
|
Posts:
62
Registered:
9/7/07
|
|
|
|
Re: VSS in 4.2 DPP
Posted:
Dec 17, 2009 7:47 AM
in response to: goodchildc
|
|
Helpful |
|
|
Yes.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
