thnx , the only question here , is there any way i can restore publisher differential backup on top of my already existing subscriber database?

Any taker pls?

Just to be clear i am thinking below steps

remove subscription

take differential back up on publisher

create subscription on the basis of differential back up above

restore differentail backup of publisher on subscriber(this...

Thanks for reply, just to clarify

it commits the transaction for priciple but keep the T-Log intact and continue to grow since Mirror is not available?

or it does not commit...

sorry for confusion actually

for production A to C Logshipping will work and i am thinking of separate instances for Pre-production on C and D and as per requirement i...

Thanks but below first step will only start first job and if it starts successfuly it will go to next step but my requirement is if first job completes successfully...

Thanks , it looks either MOM or full text was the culprit , it worked now ...

Account is in NT admin group , also is there any way to check which user connection is active when SQL comes in single user mode?

Thanks..

Thanks Guys ,but still i am not able to connect after putting the server in single user mode and getting below error ,i tried several times also made sure my...

I am using domain service account and there was no issue with until yesterday suddenly all replication jobs start failing and when i tried to create other new job i...

Thanks Guys , got the answer...

Thanks for looking ,but it does not talk about the permissions i am looking , any other pointers?

Thanks , also after running the upgrade advisor getting below in error reports

Object reference not set to an instance of an object

FTMULTIPLEINSTANCES

any body knows what does it mean?

My customer is coming up again , does any body know for sure?

Thanks....

Great ,also one more question ,i know dbcc updateusage correct page and row count inaccuracies in catalog views, as i had problem that my DB space available was showing to...