thx a lot..it worked..

Hi

I was thinking to use MERGE because you are basically merging 2 records. As I of the mentioned in 3 rules, we can delete any of the record, provided it...

Thanks Much , it helped me fulfill my requirement..

ya, trying to;-)

I can't thanks more. Works as i needed.

for the benefit of those who fall across this thread, here is I solved this:

I created a proc on main server which was schedule and it will delete the records...

I actually needed what above query returned but thank you for trying it out.

Perfect..perfect..

Thanks So much. it worked. But I think the order by clause should have been:

Order BY m_date desc

So that I get current month at top.

oh, ok. Sorry I should have mentioned it. There will be where caluse , SO that the query only picks current one year data.

So there will always be 12 months...

Sorry, I couldn't follow yesterday. So Answering all questions in single reply:

Select @@Version (pls note only edition is different)

source : Microsoft SQL Server 2008 R2 (RTM) -...

ok, I am attaching the error image..

Yes, I tried. I got error: RESTORE HEADERONLY is terminated abnormally.

That will be a life saver. Can it be implemented using inbuilt log shipping of sql server or I need to prepare any customized scripts?

Any link on this will be...

but log shipping will require my database of ServerB to be in restoring mode always, isn't it? And hence I won't be able to access that.I can affford serverB to...