End-to-End Analyze Script for Keeping a VSS Database Healthy

RE: End-to-End Analyze Script for Keeping a VSS Database Healthy

Jesse Tilly — Tue, 09 Sep 2003 01:10:00 GMT

Per MSDN's "best Visual Source Safe practices", you should probably run the 'ss physical' command on each repository. This will create a mapping file between every database file and real file in the projects. That way, when analyze says 'aaaaaaa' is corrupt, you know what real file might be impacted.

RE: End-to-End Analyze Script for Keeping a VSS Database Healthy

Ashwin — Wed, 15 Oct 2003 14:18:00 GMT

In VSS some of the files get extension as .vss.tmp for example if the file name is format.asp the file name will be renamed to format.asp.vss.tmp. If I rename the file to format.asp it say that the file is alerady exits, but no file will be there with that name. Can you give me a solution for this. Wating for your responces. Ashwin. You can contact me at ashwinchandra_k@hotmail.com

re: VSS Password Guidelines

Korby Parnell's WebLog — Fri, 23 Jan 2004 00:07:00 GMT

Welcome to my web wanderings :: End-to-End Analyze Script for Keeping a VSS Database Healthy

TrackBack — Wed, 25 Feb 2004 22:15:00 GMT

Welcome to my web wanderings :: End-to-End Analyze Script for Keeping a VSS Database Healthy

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Greif — Fri, 27 Feb 2004 19:53:00 GMT

VBScript to do something similar -

Option Explicit

WScript.Echo("Start - " & strDateStamp & " " & Time)

const VSS_PATH = "C:\sourcesafe\" 'All VSS Databases reside under this folder
const ANALYZE_PATH = """C:\Program Files\Microsoft Visual Studio\Common\VSS\win32\ANALYZE.EXE"""

dim intReturn, strDateStamp, WshShell, FileSys, strDailyBackupFolder

strDateStamp = getDateStamp
set WshShell = WScript.CreateObject("WScript.Shell")
set FileSys = CreateObject ("Scripting.FileSystemObject")

writeVSSDatabases
analyzeDatabases

set WshShell = nothing
set FileSys = nothing

WScript.Echo("End - " & strDateStamp & " " & Time)

Sub writeVSSDatabases
'retreive a directory listing of all VSSDBs (folders containing 'srcsafe.ini')
'dir " + VSS_PATH + "srcsafe.ini /b /s > " + VSS_PATH + "VSS_Databases.txt"
End Sub

Sub analyzeDatabases
WScript.Echo("Enter analyzeDatabases - " & Time)
dim vssfile, txtstream, line, VSSDBPath
set vssfile = FileSys.GetFile(VSS_PATH + "VSS_Databases.txt")
set txtstream = vssfile.OpenAsTextStream (1, -2)

do while txtstream.AtEndOfStream <> true
line = txtstream.ReadLine
VSSDBPath = trim(Left(line, InStrRev(line, "\"))) & "data\"

WScript.Echo("Processing - " & VSSDBPath)
WScript.Echo("Verify backup folders.")
createDailyBackupFolder VSSDBPath

WScript.Echo("Locking database.")
lockVSSDB VSSDBPath

WScript.Echo("Disconnecting all sessions.")
disconnectSessions

WScript.Echo("Analyzing database.")
analyzeVSSDB VSSDBPath

WScript.Echo("Unlocking database.")
unlockVSSDB VSSDBPath
loop

txtstream.Close

set vssfile = nothing
set txtstream = nothing
WScript.Echo("Exit readVSSDatabases - " & Time)
End Sub

Sub createDailyBackupFolder(strVSSDBPath)
'create a daily backup folder
End Sub

Sub lockVSSDB(strVSSDBPath)
'create admin.lck file in VSSDBPath's data\loggedin directory
End Sub

Sub unlockVSSDB(strVSSDBPath)
'admin admin.lck file in VSSDBPath's data\loggedin directory
End Sub

Sub disconnectSessions
'Disconnect all network sessions to the server
End Sub

Sub analyzeVSSDB(strVSSDBPath)
'Execute the analyze utitliy against VSSDB
End Sub

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Joey — Sun, 28 Mar 2004 12:20:00 GMT

Thanks alot to Greif for the excellent VBScript - you'v helped me alot!
Another question to you all that might not be directly connected to the Blog's main idea but is very important as well...
Can I make an archive in VSS by a ranged date?
In example: I want to archive only the files that were last accessed/updated in the past month, is that possible???
Thanks ahead for you'r tremendouse contribution!

-- Joey

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

mvm — Sun, 11 Apr 2004 14:06:00 GMT

I think you can. ssarc.exe has the option "-v", the same as for ss.exe. "-v" option can specify a range of date.

see more in SSUSEXP.CHM, the user manual.

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Steve — Tue, 14 Mar 2006 16:09:10 GMT

I'm not expert on scripts, and know almost nothing about Source Safe, but I think the above may help me with a small problme I'm encountering.

I've consistently got users staying logged in to Source Safe, or leaving files open, through my Backup window. This causes the backup to consistently skip the SourceSafe files in use.

With tweaking, may I use the above script to disconnect users from the database so that I may back it up properly?

Thanks,
Steve

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Judd — Thu, 29 Jun 2006 04:29:09 GMT

Any one out there knows why it would take 14 hrs to run analyze on a DB with the -f (rebuild cache) and without the -f it run in 2 min?
Thanks again for all helpfull contributuion!!!!

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sun, 27 Aug 2006 00:02:25 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sun, 27 Aug 2006 02:09:02 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sun, 27 Aug 2006 08:11:03 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sun, 27 Aug 2006 11:56:05 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sun, 27 Aug 2006 20:07:27 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Dick — Mon, 28 Aug 2006 02:09:17 GMT

good site
wellcome to our
http://bmw.dkblog.org

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

management project software — Sat, 02 Sep 2006 00:31:06 GMT

Thank you so much for this great post about <a href="http://eteamz.active.com/moneymanagement/files/management-project-software.html"">http://eteamz.active.com/moneymanagement/files/management-project-software.html" title="management project software">management project software</a> and [URL=http://eteamz.active.com/moneymanagement/files/management-project-software.html]management project software[/URL]

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

mortgage payment — Wed, 06 Sep 2006 00:02:13 GMT

Very interesting and good point about <a href="http://eteamz.active.com/moneymanagement/files/mortgage-payment.html"">http://eteamz.active.com/moneymanagement/files/mortgage-payment.html" title="mortgage payment">mortgage payment</a> and [URL=http://eteamz.active.com/moneymanagement/files/mortgage-payment.html]mortgage payment[/URL]

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

hair loss — Fri, 08 Sep 2006 09:40:21 GMT

Thanks for the great tips about <a href="http://paulsmall.bravehost.com/hair-loss.html"">http://paulsmall.bravehost.com/hair-loss.html" title="hair loss">hair loss</a> and [URL=http://paulsmall.bravehost.com/hair-loss.html]hair loss[/URL]

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

hair loss — Fri, 08 Sep 2006 09:40:21 GMT

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

hair loss — Fri, 08 Sep 2006 09:40:21 GMT

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

hair loss — Fri, 08 Sep 2006 09:40:21 GMT

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sat, 16 Sep 2006 11:14:59 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Poll Pitt — Sat, 16 Sep 2006 14:09:30 GMT

I am so [url=http://access.2surf.eu]lucky[/url] on having what I have! And good luck in yours [url=http://2access.2surf.eu]search[/url].
Just visit [url=http://access.122mb.com]my site[/url].

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

replicarolex — Sat, 16 Sep 2006 19:36:22 GMT

[URL=http://http://replicarolexwatch.ir.pl]replica-rolex-watch[/URL]<a href="http://http://replicarolexwatch.ir.pl">replica rolex watch</a>

VSS 6.0(x) Info, Links, Articles, code, and other resources.

Lance's Whiteboard — Thu, 28 Sep 2006 19:11:36 GMT

After years of automating Visual SourceSafe(VSS), I am beginning to post and organize all my knowledge

re: End-to-End Analyze Script for Keeping a VSS Database Healthy

Kevin — Tue, 17 Apr 2007 21:40:59 GMT

Here is an alternative script that I am working on. This VSS maintenance script uses PowerShell.

Korby Parnell s Social Software Wunderkammer End to End Analyze | Indoor Grills

Korby Parnell s Social Software Wunderkammer End to End Analyze | Indoor Grills — Mon, 01 Jun 2009 22:26:19 GMT

PingBack from http://indoorgrillsrecipes.info/story.php?id=4147

Korby Parnell s Social Software Wunderkammer End to End Analyze | Green Tea Fat Burner

Mon, 08 Jun 2009 05:19:39 GMT

PingBack from http://greenteafatburner.info/story.php?id=4412

Korby Parnell s Social Software Wunderkammer End to End Analyze | Weak Bladder

Korby Parnell s Social Software Wunderkammer End to End Analyze | Weak Bladder — Tue, 09 Jun 2009 21:53:24 GMT

PingBack from http://weakbladder.info/story.php?id=4669

Korby Parnell s Social Software Wunderkammer End to End Analyze | Cast Iron Cookware

Fri, 12 Jun 2009 05:53:07 GMT

PingBack from http://castironbakeware.info/story.php?title=korby-parnell-s-social-software-wunderkammer-end-to-end-analyze

Korby Parnell s Social Software Wunderkammer End to End Analyze | Hair Growth Products

Sat, 13 Jun 2009 15:24:27 GMT

PingBack from http://hairgrowthproducts.info/story.php?id=233

Korby Parnell s Social Software Wunderkammer End to End Analyze | debt consolidator

Fri, 19 Jun 2009 17:54:32 GMT

PingBack from http://mydebtconsolidator.info/story.php?id=14313