My issue is that initial snapshot is not being generated. Some issues are there that are well described in attached images in original post. Pl see these images.

We are running...

Thanks

I think some thing is blocking there in replication that is causing problem. B/c initial snapshot is not being created.

I used sp_removedbreplication sp to remove Replication objects after...

Thanks for mentioning me the article. This article is about cleaning some tables after deletion of Subscription. Would you please suggest me the script that will clean all replication...

Thanks dear.

We are using domain account which has full rights over the Shared folder. I have implemented replication before this with the same account.Pl see attached images as well if...

many Thanks for your time.

I have reinitialized the all subscription at Publisher,Distributor and Subscriber.

But I am getting same issue.

"The initial SnapShot of the Article "abc" is not yet available"

Thanks

I am facing same sort of problem. Please tell me where to start Distribution agent. I am not able to find exact screen at the distributor from where I can...

Thanks Sir for your help,

I have configured Replication pretty well.

But after this my boss ask me to run some schema Changes like altering Columns and removing/addition of some primary...

Thanks for your reply.

There was no Error.but table was not replicated at the Subscriber End.

Thanks

Thanks for proper Explanation.

Pl Tell me, Whether table partition improve select query performance or not?

Thanks

I gone through your Article "Managing Transaction Logs", its provides me such a wonderful information to clear my misconception about logs.

I have still two misconception here

1: Pl tell me If...

Thanks Gail,

We change the index as you suggested and things are now pretty good and DB is now performing well.

Again many thanks indeed.

Thanks

My another Question is

We have data...

Thanks Gail,

How can we bring the log file back to normal size b/c we have no log backup. What is the impact of this on performance of select queries. Before...

Thanks Dear Jhanzaib,

I have installed SP1 for MSSQL08R2 but situation is same. I have not installed CU#07 b/c I got warning at the Microsoft that it should be installed if...

Thanks JAcyub.

Pl fin attached Execution Plans in XML files of same query at SQL 2008 and sql 2008R2.

Along with this, we also made some changes with the DB when we...

Thanks for your valuable time,

Attached image file explain Memory settings of our server.

Thanks

Azhar