Re: Subversion DB administration

Ryan Schmidt wrote:
>
> On Nov 5, 2007, at 11:53, Hervé MALEVILLE wrote:
>
>> I’m new to SVN (working on Windows platforms, Visual studio 2005). I’m
>> a little bit worried about the DB system (Berkeley) embedded into SVN.
>> Does a simple backup/restore process available? Is this DB system
>> enough reliable? My network support team only work with MS SQL Server.
>> Could this be a problem if we need to execute any maintenance task?
>> Having any experience about such a case?
>
>
> The default repository format in Subversion 1.2.0 and later is no longer
> BerkeleyDB, but FSFS, which doesn't have these problems.
>
> BDB is considered very reliable, but can be harder to maintain than
> FSFS. If you don't know what you're doing, stick with FSFS, which is
> also very reliable. For most people, FSFS should work great.

Even if you use FSFS, you still need a Subversion aware backup of it if people
are doing commits into it at the same time, otherwise the restore may not be an
internally consistent repository.

So regardless of BDB or FSFS, you need to use svnadmin dump or this tool, which
I recommend:

http://svn.collab.net/repos/svn/trunk/tools/backup/hot-backup.py.in

Regards,
Blair

-- 
Blair Zajac, Ph.D.
CTO, OrcaWare Technologies
<blair@orcaware.com>
Subversion training, consulting and support
http://www.orcaware.com/svn/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org