Script performs routine maintenance and visual sourcesafe database backup. A log file listing the output of all actions taken in this script(vssmaintvssmaint-.log) is generated. If the script is run more than one in one day, the log file is appended.email the logfile to VSS administrator.

Microsoft Visual SourceSafe

Disclaimer

The free software programs/documentation are provided by assad.ca may be freely distributed, provided that no charge above the cost of distribution is levied, and that the disclaimer is always attached to it.

The programs are provided as is without any guarantees or warranty. Although the author has attempted to find and correct any bugs in the free software programs, the author is not responsible for any damage or losses of any kind caused by the use or misuse of the programs. The author is under no obligation to provide support, service, corrections, or upgrades to the free software programs.

	Visual SourceSafe Admin & Maintenance Script

Key Features:

• VSS Database backups ( 5 latest copies)
• Auto Locking & folder sharing/unsharing
• Database analysis and repair
• Email Notification

Description:
Script performs routine maintenance and visual sourcesafe database backup.A log file listing the output of all actions taken in this script(vssmaintvssmaint-.log) is generated.If the script is run more than one in one day, the log file is appended.email the logfile to VSS administrator.

A) The VSS database is locked

B) The network drive is unshared and reshared after all task ate complated.

C) If optional argument -copy is provided, copy the data folder as data.bak before analyze utility is exectued.

D) Analyzing the data folder to look for signs of database corruption due to network or operating system problems and fixing the errors (using VSS Analyze utility). The Analyze utility is exextued up to three times (if any problem found) to correct problems. (Analyze utility generates its log info in databackupanalyze.log,which is also copied to a log file generated by this script)

E) Archiving the database (using SourceSafe achieve utility).
If Archive switch is active (file archive_on is present) do archive otherwise skip. Latest 5 copies of previous archive files are maintained on local drive. It would be wise to have weekly tape backup incase the local drive failure. The root folder where the backups are stored is ..archivebackups and each archive file is stored in a seperate folder named as backup.bak0... backup.bak5, where backup.bak0 folder contains the latest.

F) Cleaning the "Temp" folder (VSS usually places files in its Temp folder while running, and deletes them before quitting. Some circumstances, such as having to restart, can cause files to remain in the Temp folder a waste of disk space). Empty the temp folder (path specified in srcsafe.ini)

G) Send emails or Net Send Notification to Administrator and attach log files as body.

Download:

The trigger is executed after a a new baseline is recomended (post op trigger). Its scans the first member of every row of an array @arrayOfstreamNameAndEmails and a stream name is atched, its sends out notiification to the emails ids listed. The trigger send email one by one but you can put the $smtp->datasend("CC: $emailton") and remove foreach statment.
If the emails are sent to a single domain , if the mails are send to different domains comment the line "$emailids =~ s/,/@$emaildomain,/gx;" and in the array list provide the full email ddresses.
The email message is formated for html message.The email provides the description /coments assigned to each baseline.It lists the composite baseline and all dependent beselines. All foundation baselines are numbered and dependent baselines are not numbered.