anyone? Thanks in advance!
BJnot natively. A good way to do it is to use backup the database to disk
using BACKUP DATABASE commands and then have the NTBackup job pick these
files up later.
Obviously you might have timing / synch issues here but you could create a
batch job that uses OSQL to perform the Backup commands and then launches
NTBackup (with params to automatice) and run this via Windows Task
Scheduler.
Or could do the other way round from a SQL Agent job , ie backup databases
and then launch NTBackup as the next step.
Alternatively could have a batch that stops SQL Server , NTBackup (to pick
up mdf, ldf), Starts SQL Server. But obviously server is down when this
happens
cheers,
Andy
"BJ" <lmelogra@.optonline.net> wrote in message
news:OYlTN3LjEHA.704@.TK2MSFTNGP09.phx.gbl...
> anyone? Thanks in advance!
> BJ
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment