Appendix C. Database Maintenance

In this appendix, we will see how to perform maintenance tasks on SourceSafe databases such as undoing user checkouts, changing the team version control model, locking, archiving, restoring, and running database maintenance tools.

Undoing User Checkouts

Sometimes, there are cases when users forget to check in files for a long period of time. If the database is configured not to allow multiple checkouts (exclusive checkout model) and other users need to modify the file, they are unable to do so. In these cases you, as database administrator, can resolve the situation by undoing the checkout on the file.

To do so log in to the database using the Visual SourceSafe Explorer using the Admin account.

Then, right-click on the file left checked out and use the Undo Check Out command.

If the user has many files checked out you can use the search by status function to search for the files checked out to that user. To be able to perform this operation, you must have a working folder set for the project that contains the file.