On 14. apr. 2011, at 13.57, James Harper wrote:

> It's not. MSSQL is "MicroSoft SQL", so guess which platforms it runs on
> :)
> 
> I'm not sure if a Windows equivalent of 'touch' could work while the
> database files are open, and even if it did, I'd be reluctant to tinker
> with it.

I have a large, dedicated MS SQL server with a couple dozen databases ranging 
from a few MBs to several GBs. I dump them with ClientRunBeforeJob scripts and 
back up the dumps. It's really no different than dumping mysql dbs on the fly. 
I also have management tasks running which dumps transaction logs at regular 
intervals throughout the day and back them up at night.

Check out the SQLCMD.EXE program installed with SQL Server. If you want I could 
post some example scripts?

Or did I misunderstand something?

Tor Willy Austerslått

------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users