BackupPC-users

Re: [BackupPC-users] Help backing up Microsoft SQL Server with BackupPC (and WinXPs Shadow Copy Service)

2008-08-20 02:38:21
Subject: Re: [BackupPC-users] Help backing up Microsoft SQL Server with BackupPC (and WinXPs Shadow Copy Service)
From: Adam Goryachev <mailinglists AT websitemanagers.com DOT au>
To: BackupPC User List <backuppc-users AT lists.sourceforge DOT net>
Date: Wed, 20 Aug 2008 16:38:09 +1000
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kurt Tunkko wrote:
> Alan McKay wrote:
>>> 1) Can I [...] do a dump of the
>>> Microsoft SQL Database to a file and backup this file?
>> I don't use MS SQL, but the above works fine on MySQL.
>
> Ok, so I know now its worth to follow this path, but (unfortunately) I
> don't know what are the right commands to do this - and looking into
> 'the book' (backup & recovery) the database chapter was already very
> complicated to me, so if someone knows how to:
>
> - create a dump with microsoft sql server 2005, and

AFAIK, you can use a tool called sqlmaint.exe which comes from
microsoft. It will create the text backup file similar to mysqldump does
for mysql.

> - howto use the shadow copy service on windows

This should be a dedicated question, but I would love to see the answer
to it...

Regards,
Adam

- --
Adam Goryachev
Website Managers
www.websitemanagers.com.au
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIq7vRGyoxogrTyiURAhtBAJ9gzrULHaAUqVt+kzUYvMmf1MoqCgCeM6gU
UuSbUbkT8ioTruEQQ+AAYPA=
=UBW5
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/