Thank you.

Thank you.So it is basically done for each database.

"separate IO subsystems" does it mean multiple processors?

Thanks

For First Scenario:

Restore Full Backup done at 9 Pm followed by T-logs till 1:15AM

For Second Scenario:

It would be the same?

I am running it from sql agent job, it doesn't give any error.

I am trying to run both commands in single step in a job

I tried this:

osql /U a /S A\B -d AB /P 1 /Q "exec test" /o \\C1122$\D$\test.rpt -w 500

osql /U a /S A\B -d AB /P 1 /Q "exec test"...

This is my trigger:

CREATE TRIGGER TRG_A

ON _A

AFTER INSERT, UPDATE

AS

insert into _B

SELECT * FROM inserted

where c is not null

How do I incorporate in this?

Thank you.

Thank you I am new to this. Can you provide details?

What needs to be done to copy the old record before change.

For one that has been updated I used trigger to insert into new table.

But How do I also insert...

Thank you I was able to do it.

Can I do join inside trigger?If I had to join inserted with other table from different database is it possible?

CREATE TRIGGER TRG_A

ON _A

AFTER INSERT, UPDATE

AS

insert into _B

SELECT *...

Thank you so much.

Sorry for not being clear.

I need all the values in A,B and C in table B.

Only if Col C is updated to some non-null values.