Andrew G (12/16/2013)

---

Check that the TSR_ACCOUNT_VEHICLE table schema is the same between databases.

If it is, drop the article from publisher, drop table on subscriber. Add article, snapshot, should work...

Were they installed incorrectly, sharing the same systems dbs? I've never tested the impact of this so I cant confirm what impact this would have.

I would probably look at a combination of all of the recommendations so far.

I would set MAXDOP based on the current recommendation (No. of CPU Cores/No. of Numa = MAXDOP),...

Andrew G (12/11/2013)

---

You need to add a subscription on the subscriber before running the snapshot agent.

eg

EXEC sp_addsubscription

@publication = N'<publication Name>',

@article = N'<Article Name>',

@subscriber = N'<Subscriber Name>',

@destination_db...

It looks like published database has had its transaction log restored past what was logged in the distribution db. There is a gap in LSN's preventing the logreader from...

Are you running multiple concurrent jobs using Powershell?

There is a default limitation in the msdb.dbo.syssubsystems table limiting you to 2 instances of powershell running concurrently. You can safely update...

As Grant suggests, this would be the ideal situation.

In the...

Is the db online? If it is, there is no way to revert the db to logshipping as it has fully recovered. You will need to restart by...

Also worth considering if a connection component isn't configured somewhere for an incorrect database or server.

Its fairly unlikely that any DB objects are simply "disappearing".

If by order being wrong you mean row order, I came across something like this when upgrading from SQL2000 to SQL2005 about 5 years ago.

The ordinal column order...

If you can, I'd consider a computed column with index. Maybe an indexed view trimming the values could work for you.

Otherwise I believe there is little you can with...

Sounds correct. I would check the SQL error logs for a failed login attempt to confirm you have reached SQL Server. There should be an entry stating there...

If you are developing an in-house index degfragmentation tool, I personally wouldn't invest the time reinventing the wheel. There are several options already developed and freely available on the...

In this case the ideal IMO would be merge replication or peer to peer replication.

Both would allow data modifications on either instance.

Denesh Naidoo (12/9/2013)

---

Thanks Gail...the reason we are going for this option (restoring) is because there's not much down time. So to ensure as little down time as possible I thought...