-----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 [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
