In addition to the reading, can you answer the following:

1. Does it work on the current node?

2. Does it continue to work when you failover to the other node?

If the...

Hi Mani.

You are correct. If you have a failure of node1, all resources will failover to node2.

A resource group in a cluster will, by design, act as an independent entity....

Thanks for the update.

A processor license gives you the right to install any number of copies of SQL Server 2005 on a single computer, as long as you...

Are you referring to a high availability dish share? If so, you can have a cluster group with disk, share, DNSName and IP resources.

This will give you something like \\ClusterDNSName\ClusterShare\...

Mani.

What is happening is that your backup drive is not on the same node as your SQL group and is therefore not available.

You need two backup drives, one in each...

Do you backup your transaction logs? If so, you may be able to restore the damaged pages.

http://www.sql-server-pro.com/dbcc-checkdb.html

Hope this helps

Assuming you are trying to associate SQL Server with the E Drive:

* Add the E Drive to the same resource group as SQL Server

* In the dependencies tab of SQL...

Try xp_delete_file. Alternatively, you can write a CLR.

Read the article and comments for usage but something like this should work for you. Refer also to maintenance plans which is also...

Animal Magic (10/6/2009)

Thats what i used to think, but it isnt true. i read an interesting article a while back which said that for server with less than 4...

Mani.

Are sqlgroup1 and sqlgroup2 linked in the cluster? That is to say, can one of the sqlgroups failover without taking the other sqlgroup with it?

If the answer is yes, you...

Melton (10/6/2009)

---

However, the caveat, if you bought a single processor license but your server has 2 processors in it, you are not in compliance with licensing. I have come...

Jim.

Full and TLogs will run together as will Diff and TLogs. Running Full and Diff at the same time makes no sense and may make life fun when you need...

Hi Fredrik.

If you want to keep your test environment in step with live, there are a few ways you can do this.

Yes, you can automate a restore of a backup....

darrylms (10/6/2009)

I became involved when I was asked to restore the DB that hadn't been added to the backup list.

No use complaining about it, though. I'll have to monitor it...

I am assuming your are using the 2005 SSMS and have connected to your target server for the restore.

* If you right click on Databases and choose Restore Database, the...