Yup???

You've been listening to Gail and Paul too much 😀

no, the agent failure will not fail over the instance

DBA in Unit 7 (1/8/2013)

---

One node in our cluster had a hardware failure and comepletely down and need to rebuild. I am asking for advices/suggestions to get back the node...

You're welcome, there are other scripts around but they don't account for partitions and the new allocation units used by SQL Server 2005 onwards

I can understand the provision of high availability...

That's ok mitundra 😉

If you have more than one file restart the instance afterwards to kickstart the proportional fill from equal file sizes.

To get details of table\index sizes on SQL Server 2005 onwards use the following script,

SELECTOBJECT_NAME(i.object_id) AS TableName

, ISNULL(i.name, 'HEAP') AS IndexName

, i.index_id as IndexID

, i.type_desc AS IndexType

, p.partition_number AS PartitionNo

,...

b.ammad (1/7/2013)

---

Hello,

I have a 2 node Active/Passive cluster mounted in Windows Server 2008 R2. Currently on the active node there's a SQL Server DB Engine instance running. SQL Server...

I can't say I've seen that before, are you sure you modified the xml file the same on all nodes?

Not just the patching but the installation of the product...

balasach82 (1/5/2013)

---

Do you guys foresee any problem with

[Taking backup of db and restoring the same db and changing the file location while restoring]

Example:

Database: Inventory

Backup Inventory

Restore Inventory (replace existing Inventory...

most times a differential backup will do the job 😉

Contrary to popular belief you do not need to stop SQL Server, there, that's that over with 😉

To move the database files perform the following;