Automate Visual SourceSafe Backup
I work with Source Safe as a source control repository in my current job where I also acted as a Configuration Manager for Capability Maturity Model (CMM) compliance. One of my job description is to manage sourcesafe database. Recently I was getting tired of manually backing up the source safe database by going into the source safe administration and going through manual back up procedure. So I decided to automate the procedure. What I end up doing is creating a batch file and creating a schedule task on my windows machine so that it wouldn't require any manual intervention and could run on weekends. My goals for this process were to
1. Automate the process so it occurs once a week. 2. Generate backup files that are identified by date (ie. '08-20-2000 Project Backup.ssa').
Step 1:
Create a batch file which looks like this
rem ******************************************
rem This file is used to run backup on a specified Source Safe database or individual project.
rem You can use windows scheduler service to schedule this task run periodically preferablly
rem once a week. I have set up 'VSS' folder on my local drive with 'backup' as a subfolder. This
rem batch file will create a new file within the 'backup' named as current date.
rem **********************************************
@TITLE Backing up source safe databases
FOR /F "tokens=2-4 delims=/ " %%i IN ('date /t') DO SET DATE=%%i-%%j-%%k
cd\
cd program files\microsoft visual studio\vss\win32
ssarc -yAdmin,sourcesafeadminpassword -d- -i-y -sC:\source_safe repository c:\VSS\backups\%DATE% mybackup.ssa $/
@ECHO Finished backups
* replace sourcesafeadminpassword with your password
* replace "-sC:\source_safe repository" with the location of your source safe repository.
* replace "c:\VSS\backups" with your choice of location for backup.
* $/ represents the whole source safe tree. You can include a project name if you want to back only a particular project.
Step 2:
Automate the batch file with the window scheduler service.
After following the above two steps you should be good to go and your backups will be saved in the location that you have specified in the batch file. I will write more about the batch file and explaining various parameters later.

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment]
Just downloaded this from riaforge. The main thing I liked (that DevNotes is lacking) is the ability to add notes to specific pages.
I have an existing system which I'm now adding major new features to and I'd like to use a system similar to this that I can attach to the footer for clients to use. How easy would it be to integrate cfprototype with my existing code?
Thanks,
James
# Posted By James Buckingham | 5/29/08 8:47 AM
I tried responding directly to your email address but it bounced back. Anyways here is my response
"
James,
I am glad that you liked the application however I think your comment got posted under the Visual Source Safe post. I am not sure if cfprototype is suitable for integrating into existing applications. It is primarily meant to create quick html pages of the desired application. At least that's how we use it at work. We'll create a prototype for any new feature first and once it is approved only then we proceed with actual development kinda like FLiP.
Let me know if you have any question. I will be using this application for my presentation at CFUnited, so the code will likely to change.
Thanks
"
# Posted By Qasim Rasheed | 5/31/08 1:08 AM
[Add Comment]