Noticed that - Thanks

Even without the distinct, the result is the same

Noticed that the SalesOrderDetailID column...

Is there nothing in the report file?

You have to restore a full backup from the primary to the standby server and then all subsequent logs. The database needs to be restore with No recovery/Standby so that...

Thanks

Thanks

Does it matter if the Node we evicted and now adding again was the primary Node of the original cluster?

Thanks

Derek

Elliott Whitlow (10/31/2011)

---

I'm largely going along with Perry on this one.. I would wipe the node and rebuild it, I think trying to re-add it is simply asking for...

Perry Whittle (10/31/2011)

---

never tried it myself, i have always cleaned up the clustered applications and then evicted the node. After evicting the node if you attempt to add it back...

Cool

Just a question

Multi-Node??

What is your environment?

Standalone, Clustered etc....

Hi Perry

If not going for the best practice of reinstalling the clustered applications

Do you think the following could work?

1. Present Shared storage to Node

2. Add Node in failover cluster management

3....

Then use this

truncate table table_name

or

delete from table_name

Delete from table_name

Truncate table table_name

Are you trying to remove all the rows from a certain table without deleting the actual table??

steveb. (10/28/2011)

---

The N is not specific to restores, it is the way of telling sql server that the string value could be unicode.

The stats is a percentage showing...

Unbeknownst :hehe: