Check to see if the account which is trying to access the database has enough permission to access DB/ create mirror or Database autogrowth is on.

Mirror will become the Primary.

what value SET @subscriber = $(Client Name) is returning ? Do you know subscriber name, so you can pass directly?

When you want to setup replication from back up, you do not have to run snapshot agent, because you are already doing the work of snap shot agent by restoring...

What parameters you are passing in sp_dropmergesubscription?

take a look in the code of sp_dropmergesubscription and see if you running on any valid sequence. May be SP is running successfully but...

Check this out.

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput

This article by Kimberly Tripp describes about the VFL management.

Duplicate Post :-

http://www.sqlservercentral.com/Forums/Topic1447198-1549-1.aspx

yes it is a very good idea to start with these books.

But if you want to learn about deprecated features:-

http://msdn.microsoft.com/en-us/library/ms143729.aspx

http://technet.microsoft.com/en-us/library/cc707789(v=sql.105).aspx

Please take a look at :-

http://msdn.microsoft.com/en-us/library/ms175575.aspx

Duplicate Post..

http://www.sqlservercentral.com/Forums/Topic1446290-291-1.aspx#bm1446716

You can view synchronization status in subscriber and also validate subscription to see what is going on. But as DHeath said replication monitor is the best to see things is...

It looks like you have duplicate rows in MSArticles and MSSubscriptions. I would suggest to run the following commands:-

delete distribution..MSarticles where publisher_db = 'YourPublisherDB'

delete distribution..MSsubscriptions where...

Glad it worked for you.

Do you see anything under Local Publication then Publication and click on + of publication..If yes try the below mentioned command..

USE master

EXEC sp_removedbreplication @dbname='DBName'

GO

sp_dropsubscription @subscriber='SubscriptionName'-- If you...

Check under replication "Local Subscription"? Is there any?