Hello,

on one of our Clients there is an instance of Microsoft SQL Server running.

When backing up the machine, the error log shows:

Remote[1]: rsync: send_files failed to open: <FILENAME>  (in root):
Device or resource busy (16)

with <FILENAME>s:

"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/master.mdf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/mastlog.ldf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/model.mdf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/modellog.ldf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/msdbdata.mdf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/msdblog.ldf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/tempdb.mdf"
"c/Programme/Microsoft SQL Server/MSSQL.1/MSSQL/Data/templog.ldf"

While knowing little about database, I know that I need to shutdown SQL
Server during the backup but then the machine would be not functional
during this time.

Questions:
1) Can I use Windows XP Shadow-Copy feature or do a dump of the
Microsoft SQL Database to a file and backup this file? Maybe something like:
a) stop sql server
b) make a snapshot/shadow copy
c) start sql server
d) backup client

2) another question regarding the shadow copy feature
(http://en.wikipedia.org/wiki/Shadow_Copy) - can I use this to make a
snapshot of a windows xp professional client and then backup this
snapshot via rsyncd?

kind regards from berlin

- Kurt





-------------------------------------------------------------------------
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/