> > 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? >
I don't have space on this particular server to dump out 40GB of database (the database itself is about 80MB but there are lots of FILESTREAM images that would be included in the backup stream). I have found that all I need to do is run a 'CHECKPOINT' to ensure all data is written out to the database. Can you post an example Job with a ClientRunBeforeJob? I just get errors every time I try to do it. Thanks James ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
