Sounds obvious, but did you check Named Pipes settings? Or is that a typical SQL Server "red herring" error and nothing to do with NP at all? :ermm:

qh

1. It may not be possible to replicate from 2005 to 2012 (off hand I don't know this) you may need to have the 2005 server at SP4?

2. The size...

As a prod DBA I've been a bit snobby and dismissive of SSIS in the past (even preferring DTS!) but with some clients I've had no choice but to get...

As a production SQL DBA contracting for many clients I have found 3rd party compression tools totally invaluable. SQL 2008 compression is fine, but many of my clients aren't...

Great article, I am looking to build the same clustered environment using SQL 2008 R2/Win2008 R2 Server & virtual box.

qh

Many ways to skin a cat! Empowering to know as many ways as possible to perform a set task or tasks then see which is the best fit.

Good article.

qh

kennethigiri (9/21/2012)

---

quackhandle1975 (6/29/2012)

---

Nice article, I have implemented this a number of times, as much as you try and coerce your boss/cient into using/buying 64bit OS/SQL, you have to work with...

Thanks Lowell, much appreciated.

qh

No replies how odd, but I'll add that it's a great article, looking to perform this also.

Thanks one for the briefcase this. 😀

qh

Good and informative article.

Thanks

qh

Would I be right in thinking that when using both, the database would more or less be read only for that login?

qh

But non replicated objects created or updated on subscriber would not break replication?

qh

Thanks for the reply. In my setup the Publisher is large (50GB+) so I performed a backup and restore for the subscriber so no snapshot was applied (or will...

I have a similar question: I have basic transactional replication setup between two 2005 SQL Servers. Now I want to create views on the subscriber, will this break the replication?

Thanks

qh

Good article, thanks very much.

qh