[re: the usual Windows SQL Server MDF and LDF files in use]

>  Can't these filed be backed up via open file file backup
> (VSS/VSP)

Not sure you can back them up even _with_ Windows open file backup
methods--try backing up the perflib stuff.  Microsoft seems to lock
these files with an exclusive write lock that even the volume snap
methods don't get past. 

Even if you could, to what point?  The data are effectively
useless--they are, at best, crash-consistent.  No DBA in his right
mind would think that was an acceptable backup strategy.

Like perfdata* files, I exclude SQL Server (and any other database)
files unless the database will be down and backed up as flat files.


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu