Why are you deleting the database before restoring it?

You can restore with replace, which will overwrite the entire database

I've seen this in SQL 2005 while running index rebuilds. It would not allow me to see DB properties via GUI, I could query the properties though.

I'm inclined to think...

It depends on how available you need your dev system to be. What is your SLA for dev systems?

Failover clustering provides instance level availability, not database availability

There is a counter in sys.dm_os_performance_counters for pagesplits/sec and as far as I understand, when querying sys.dm_os_performance_counters, any per/sec counter is actually a cumulative amount since SQL was started.

select *...

Destination for the copies?

Shouldn't be a problem, just copy existing log files to the new destination.

Do you perhaps have any 3rd party software installed on the inactive node that requires SQL to be started? Maybe a 3rd party backup software that makes a connection to...

http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

Thanks all

erics44 (6/19/2013)

---

it clears and then repopulates a database, if it fails then there will be no data available

so i want to restire the database back to how it was before...

A SQL profiler trace during this time should point out what's happening during the spike.

In the case where one of the nodes fail and needs to be replaced:

> Evict failed node

> Add new/fixed node into failover cluster using Failover Cluster Manager

> Run SQL setup...

There is no specific role that enables the execution of stored procedure, even if the user has rights to do whatever the proc does.

You will have to manually grant execute...

Not sure what exactly you need here

Want to restore a database if an Agent job fails? What does the Agent job do?

DBCC DROPCLEANBUFFERS with clear the entire clean part of the buffer pool.

DBCC FREEPROCCACHE will remove all plans from cache

If you have the plan_handle of the query, you can remove...

The transaction log of you seconday database is a reflection of your primary database.

Shrink the log on the primary database and it will reflect on the secondary database.

That being said,...