RE: Best Method to Backup VSS
"Hugh Wade" <[email protected]> Fri, 16 Apr 2004 10:29:21 -0700
| Newsgroups | gmane.comp.version-control.vss.sourceoffsite.classic |
|---|---|
| Message-ID | <EE97BFE9DBFF9A43AE9D0C8FC46197B90363B8C4@RED-MSG-30.redmond.corp.microsoft.com> |
This is a multi-part message in MIME format. ------=_NextPartTM-000-46e8d431-4ca0-48a8-8a2c-c5fbff2c1460 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C423D8.6C802430" ------_=_NextPart_001_01C423D8.6C802430 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable VSS is just a fancy fileshare and can be backed up as such. The key is to make sure that no users are in the database while backing it up. In the case of plain VSS on a fileshare, it is best to have a backup script that unshares the VSS folder before kicking off the backup util. If the server is running SOS, you should stop the SOS service before running the backup. Linda might have more info on SOS specific backup strategies. =20 If there are users in the database when a backup occurs, the names.dat file can be skipped. If you have to restore a DB and are missing the names.dat you will loose every long filename in the DB and have to rename them by hand. I have walked many customers through this recovery. It is extremely painful. Please test your backups. :-) =20 -Hugh =20 =20 =20 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Arlen Baker Sent: Thursday, April 15, 2004 12:14 PM To: [email protected] Subject: Re: [SOS-LIST] Best Method to Backup VSS =20 The MSFT article is the source of my question. =20 They *imply* that you should NOT use ssarc since they mention the difference between incremental and full backups. =20 To me, that says to use MSFT Backup or another 3rd party tool. =20 =20 ----- Original Message -----=20 From: Hugh Wade <mailto:[email protected]> =20 To: Arlen Baker <mailto:[email protected]> ; [email protected]=20 Sent: Thursday, April 15, 2004 11:33 AM Subject: RE: [SOS-LIST] Best Method to Backup VSS =20 There are some caveats to backing up VSS correctly. Take a look at the backup section of the best practices doc: =09 http://msdn.microsoft.com/library/?url=3D/library/en-us/dnvss/html/vssbes= t .asp =20 -Hugh =09 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Arlen Baker Sent: Thursday, April 15, 2004 9:17 AM To: [email protected] Subject: [SOS-LIST] Best Method to Backup VSS =20 What does everyone use to backup their VSS databases with? =20 ssarc? =20 MSFT Backup Utility? =20 Other??? =20 Thanks ------_=_NextPart_001_01C423D8.6C802430 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal; font-family:Arial; color:navy;} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>VSS is just a fancy fileshare and = can be backed up as such. The key is to make sure that no users are in the = database while backing it up. In the case of plain VSS on a fileshare, it is best = to have a backup script that unshares the VSS folder before kicking off the = backup util. If the server is running SOS, you should stop the SOS service = before running the backup. Linda might have more info on SOS specific backup = strategies.<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>If there are users in the database = when a backup occurs, the names.dat file can be skipped. If you have to restore = a DB and are missing the names.dat you will loose every long filename in the = DB and have to rename them by hand. I have walked many customers through this recovery. It is extremely painful. Please test your backups. = </span></font><font size=3D2 color=3Dnavy face=3DWingdings><span = style=3D'font-size:10.0pt;font-family: Wingdings;color:navy'>J</span></font><font size=3D2 color=3Dnavy = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span= ></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>-Hugh<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> [email protected] [mailto:[email protected]] <b><span = style=3D'font-weight:bold'>On Behalf Of </span></b>Arlen Baker<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, April 15, = 2004 12:14 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> = [email protected]<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> Re: [SOS-LIST] = Best Method to Backup VSS</span></font><o:p></o:p></p> </div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>The MSFT article is the source of my = question.</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>They *imply* that you should NOT use ssarc since they mention</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>the difference between incremental and full = backups.</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>To me, that says to use MSFT Backup or another 3rd = party tool.</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> </div> <blockquote style=3D'border:none;border-left:solid black = 1.5pt;padding:0in 0in 0in 5.0pt; margin-left:4.7pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>= <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>----- Original Message ----- = <o:p></o:p></span></font></p> </div> <div style=3D'font-color:black'> <p class=3DMsoNormal style=3D'background:#E4E4E4'><b><font size=3D2 = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold'>From:</span= ></font></b><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'> <a href=3D"mailto:[email protected]" title=3D"[email protected]">Hugh = Wade</a> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><b><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial;font-weight:bold'>To:</span></font></b><font size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'> <a href=3D"mailto:[email protected]" = title=3D"[email protected]">Arlen Baker</a> ; <a href=3D"mailto:[email protected]" title=3D"[email protected]">[email protected]</a>= <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><b><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial;font-weight:bold'>Sent:</span></font></b><font = size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'> = Thursday, April 15, 2004 11:33 AM<o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><b><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial;font-weight:bold'>Subject:</span></font></b><font = size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'> RE: = [SOS-LIST] Best Method to Backup VSS<o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> </div> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>There are some caveats to backing = up VSS correctly. Take a look at the backup section of the best practices = doc:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><a href=3D"http://msdn.microsoft.com/library/?url=3D/library/en-us/dnvss/htm= l/vssbest.asp">http://msdn.microsoft.com/library/?url=3D/library/en-us/dn= vss/html/vssbest.asp</a><o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>-Hugh<o:p></o:p></span></font></p> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabIndex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> <a href=3D"mailto:[email protected]">sos-list-admin@lists.= sourcegear.com</a> [mailto:[email protected]] <b><span = style=3D'font-weight:bold'>On Behalf Of </span></b>Arlen Baker<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, April 15, = 2004 9:17 AM<br> <b><span style=3D'font-weight:bold'>To:</span></b> <a href=3D"mailto:[email protected]">[email protected]= om</a><br> <b><span style=3D'font-weight:bold'>Subject:</span></b> [SOS-LIST] Best = Method to Backup VSS</span></font><o:p></o:p></p> </div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>What does everyone use to backup their VSS databases = with?</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>ssarc? </span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>MSFT Backup Utility? = </span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>Other???</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>Thanks</span></font><o:p></o:p></p> </div> </blockquote> </div> </body> </html> ------_=_NextPart_001_01C423D8.6C802430-- ------=_NextPartTM-000-46e8d431-4ca0-48a8-8a2c-c5fbff2c1460--