Can I backup UP MS SQL 2000 with Windows 2000 NT Backup?

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
>

Can anyone help explain 'XactSequence' in profiler trace

Hi All

Can you explain the column 'XactSequence' in detail in SQL Server 2005 profiler trace?

Thanks in advance.

transaction sequence.

|||

Thanks, can you let me know the difference between transaction sequence and transaction id? Also, for dtc transaction, does it have transaction sequence?

|||

They're not the same. Think of a sql job where you have multiple job steps. So, the jobid is not the same as the jobstepid. It's a 1-to-many relationship.

|||

Thanks. But when will SQL create a XactSequence for the specified SQL transaction? Also, will DTC transaction have XactSequence?