thanx to all of you... for spending ur time... helping me out...

Thank you very much lowell... 🙂

hey paul..

if you dont mind...can you please elobarate...

hey Lowell

that was awe some... thank u very much.. 🙂

they said we have way of doing it..without disabling/deleting the FK..

I asked for the answer...but he said..."it is good if you find out urself"..:crying:

Is there any way to know a perticular transaction log has been restored or not??????:crazy:

thank you very much quick clarification..

I will try it out and post the update..:-)

i am applying log backups with NO RECOVERY

that WITH STANDBY is not going to break the following restorations???

using osql u can run a query or procedure on any sql server to which you have access...

osql -S -U -P -w8000 -d -iS:\Data\Scripts\SDLKMove.sql -oSDLKMoveScript.txt

run this in command prompt..

we can use osql for this purpose... or even try (xp_cmdshell)

check if you have started the sql server agent service with a domain account instead of LocalSystem account.. If yes, the check is that domain account is having appropriate...

I have tried transactional replication.. (with push subscription)

but it is tooooo long time to replicate the intial subscription..

it is replicationg 1 lack rows for 5mins... where as I have lacks...

as I said the servers are spread over the internet.. we cannpt have shared locations.. between them..

I read some where that to implement Logshipping/Trasactional replication we need to start the 2 SQL Server services with same domain account...

as my systems are remotely distributed I cannot fullfil...

I read some where that to implement Logshipping/Trasactional replication we need to start the 2 SQL Server services with same domain account...

as my systems are remotely distributed I cannot fullfil...