Frankly speaking i haven't come across the software u mentioned. So cant comment how it works.;-)

have u created linked server for asp2.pragmaproducts.com?

i dont think sysdate() is a valid function (unless its a UDF).

try replacing that with convert(varchar, getdate(),112) and it should be fine.

btw, what is the question?

The backup path u've specified should be present on the server (not on the client machine from where u're connecting)

You also might want to download express edition with advance services...

I'm not sure but see if this can help u.

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

Seems you have registered your server in SSMS using IP address of the server.

Try re-registering with actual server name and then proceed to configure distribution..

here is how you create linked server on the source database

sp_addlinkedserver 'Audit_server'

Once that is done, you can setup a test environment by creating a test table in the audit database,...

2000 Enterprise edition supports log shipping through GUI.

I suggest you go through these URL's to have an understanding of what is log shipping in SQL...

http://msdn.microsoft.com/en-us/library/aa175266.aspx answers all ur queries

1. create linked server on the production database pointing to Audit server.

2. In your trigger you can write something like this

insert into AuditServer.AuditDB.owner.AuditTable(list of columns.....)

select col1, col2..... coln from inserted/deleted

Log shipping seems the obvious choice here!! It's easier to implement than others.

What edition of sql server 2000 are you running?

shanila_minnu (6/18/2009)

---

how can we insert rows from a table XYZ of one database to another database table XYZ[/qote]

insert into table1(col1,col2,col3)

select col1, col2, col3 from server2.database2.owner2.table2

You'll need to create linked server...

Thanks for correcting...

Ahh.. thanks for correcting me Lynn:w00t:. for a moment i thought this post was related to 2005.

thang_ngo_2002 (6/18/2009)

---

No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we can...