Can you telnet to the server on port 5023?

Can you telnet from the primary server to the secondary on the port specified?

How often are the log backups running in the log shipping policy?

Do you have the option of pausing the log shipping, grabbing the last log backup and applying that (with...

I've used Idera SQLsafe quite extensively and to be honest, I wouldn't recommend it purely because it's quite memory hungry.

I've seen the program use up to 3GB of memory on...

HanShi (9/24/2014)

---

DBA From The Cold (9/23/2014)

---

....If your diff backups are taking longer, can you schedule them to run more than twice a week? They would then have to backup less...

sql-lover (9/23/2014)

---

Wow! One of...

What was the error that was generated?

You can attach a .MDF file using sp_attach_single_file_db:- http://msdn.microsoft.com/en-us/library/ms174385.aspx but it does require that the database was shutdown in a controlled fashion.

Yes, you did.

The database was 3TB in size, in a .MDF file and two .NDF files.

They must have thought each needed a .LDF

The guys here and over at Stack Exchange have got it right (IMHO).

I inherited a 3TB database with thousands of VLFs (in three .ldf files on the same disk!) which...

I use Ola Hallengren's scripts, never had a problem with them. https://ola.hallengren.com/

If your diff backups are taking longer, can you schedule them to run more than twice a week? They...

No worries!

Try:-

select cast((bp.id) as varchar(50))

from #temp2 as t2

join plan bp

on t2.vp_name=cast((bp.id) as varchar(50))

Yes, the conversion needs to be in the join

This will show you the bytes in use in each of the transaction logs in the databases on the system:-

USE [master];

GO

SELECT

DB_NAME(database_id) AS [Database],

SUM(database_transaction_log_bytes_used_system) AS [System Bytes Used],

SUM(database_transaction_log_bytes_used) AS [Bytes Used]

FROM

sys.dm_tran_database_transactions

GROUP...

From what you posted, the first script shows that your database has 86% space free overall (including your log file),

The second output shows that you have 12% in your log...