you're welcome

you'll be adding the node back to the current instance not creating a new one!

try just uninstalling sql server first

MBR limits partitions to 2TB, where as GPT doesn't, it's a lot larger than that.

The main restriction with MBR is the fact it will only support 4 partitions max, where...

I would uninstall\remove the node that's causing the issue and re install it

When you drop objects from the database the files do not automatically reduce in physical size

Optimal stripe sizes for SQL server...

There is no monitor server, the return value for this in sp help log shipping primary database was null.

jitendra.padhiyar...

Is this an OS service pack you're installing or the SQL server service pack?

Firstly, I'm assuming this is a typo!!

30 minutes is a little aggressive for the file pruning. How often does the backup job, copy job and restore job run?

Full...

ensure you are not taking log backups outside of your log shipping plan, only the log shipping backup job should be taking log backups of the database. Also ensure the...

sufiyan.sarguroh (7/10/2012)

---

Checked the logs. It appears that the tran backups arent being restored.

Here is the error in the log :

The log shipping secondary database INFVA02839\INSTANCE1.AdventureWorks has restore threshold of 120...

what is the vritual network name for the clustered instance you are trying to connect to?

(i.e. the one provisoned in the clustered application group in Failover cluster manager)

A client acces...

don't take these threshold values too literally, they can and will change for each and every index.

Ensure you target your indexes based on a wider view of the index...

you already have a clustered instance installed and you want to know the IP address used is that correct?