I already tried reinitializing.

The weird thing is that they show as a published article but they did not get replicated.

No relevant errors.

I generated a new snapshot. There are no undistributed commands but the table and view do not exist at the subscriber.

I had an action message that the Snapshot Agent that...

wayne.fairless (12/23/2014)

---

We often run into this in our QA environments. The below script is a blunt hammer approach to remove replication, no matter how fubared your server is:

USE <yourreplicateddb>

EXEC...

Jacob Wilkins (2/9/2016)

---

Is the version of SSMS you're using older than the instance you're connected to?

I know people have run into this issue a few times. In that case,...

I installed SQL Server 2014 and I right clicked on Replication and Selected Configure Distribution and I get that error.

It is very basic. :laugh:

Steve Jones - SSC Editor (1/28/2016)

---

Are you restoring on the same instance or a different/new one?

quote]

I need to be able to do both. Thanks for your help.

Steve Jones - SSC Editor (2/8/2016)

---

You do in order to decrypt the cert for the backup on the main instance.

Do you not know the password of the cert? Is it...

Don't I need a password? :unsure:

Perry Whittle (2/8/2016)

---

to restore the database to another server you'll need to backup the cert with the private key. You then restore this on the target server, this link details...

The encryption keys are of the following type.

I'm not sure that I have the private key.

I was told that you do not need the private key.

Master Key Type = Key...

Ken McKelvey (1/28/2016)

---

Just query the backup tables in MSDB.

eg Something like the following will get the logs since the last full backup.

SELECT 'RESTORE LOG YourDBRestore FROM DISK =''' + M.physical_device_name...

GilaMonster (1/28/2016)

---

Welsh Corgi (1/28/2016)

---

GilaMonster (1/28/2016)

---

There are two different things called the...

Grant Fritchey (1/28/2016)

---

Welsh Corgi (1/28/2016)

---

Grant Fritchey (1/28/2016)

---

The way I've dealt with this in the past is to use T-SQL or PowerShell to generate the scripts. Script the scripts. That way...

GilaMonster (1/28/2016)

---

There are two different things called the 'tail log backup'....

Grant Fritchey (1/28/2016)

---

The way I've dealt with this in the past is to use T-SQL or PowerShell to generate the scripts. Script the scripts. That way you don't have to...