Mike Hinds (12/11/2015)

---

What I haven't seen mentioned is the solution my organization uses:

Have a dedicated (to the DBAs) terminal server where SSMS, Profiler, et al, are installed....

Lynn Pettis (12/14/2015)

---

Here is how I look at it. If the people who build, create, and maintain the servers (physical or virtual) have decided to install Windows Server Core...

Core edition on the Test Server Enterprise on the Production Server.

I'm not working against anyone.

I just wanted opinions.

We have already made a compromise so this is a non issue.

Thanks.

EdVassie (12/14/2015)

---

I have always tried to get an environment where my administration tools are on a separate Windows instance to the database servers. One of the main reasons is...

Does anyone have a guide as to what steps should be taken to debug a Log Reader failure?

I determined...

GilaMonster (12/13/2015)

---

I just told you! And the error message that you posted told you as well!

You've either got transactional replication with a log reader job that's not running or change...

GilaMonster (12/13/2015)

---

Welsh Corgi (12/13/2015)

---

The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader Agent or capture...

How do I get out of this mess?

BACKUP LOG [PrismData] TO DISK = N'E:\Backup\PrismData_backup_2015_12_13_042945_6506526.trn' WITH NOFORMAT, NOINIT, NAME = N'PrismData_backup_2015_12_13_042945_6506526', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10

Processed...

Keyboard messed up.

Duplicate post.

Do not respond to this post.

I tried it but no success.

No. I am the only one connected to the...

Thank you.

That is helpful.

I was looking to generate a restore script via SSMS.

I need to change the name of the Database in some cases so...

Mike Hinds (12/11/2015)

---

What I haven't seen mentioned is the solution my organization uses:

Have a dedicated (to the DBAs) terminal server where SSMS, Profiler, et al, are installed....