That is good to know - glad I could help.

I don't think the problem is the linked server, but the fact that you are not aliasing the tables. You can no longer use the full table reference for...

If you create a physical disk resource and want to be able to access that resource through the cluster then you have to have an IP address/name for the resource...

Okay - then, once you have an IP address/name to use, you can then create the resources in the cluster group.

You need to google for learning materials - I don't...

gmamata7 (9/21/2009)

---

Hi Williams,

In-order to create the Backup Group:

1. I need to ask Windows admin, who created the windows cluster, for an Virtual Ipaddress and Network name

2. Then create Backup Group...

gmamata7 (9/21/2009)

---

here do we need to create file share in both Backup group & Cluster group after assigning Ip address & name in Backup group?

Could you please recommend some documentation...

You have a few problems here, and I would highly recommend that you consider hiring somebody to come in and mentor/train you. I'll try and clear up some of...

Scozzard (9/21/2009)

---

It means I freed up space and it works fine now.

I did go on a rather disjointed tangent to explain i noticed another issue but that is for another...

Scozzard (9/21/2009)

---

Cool, thanks you are absolutly right.

I don't want to back-up snapshot databases which means I will have to use T-SQL script instead of a database backup task in the...

No, BackupExec and other utilites like that won't backup SQL Server database files that are open. SQL Server locks the files and will not allow them to be backed...

There is some process that is running that is switching from FULL to SIMPLE. You need to find that process and understand what the process is doing and why...

On any system with more than about 12GB of memory, you need to leave much more memory available to the OS. On a system with 32GB of memory, I...

Looking at the picture, it is actually very easy to figure out why this happens. Your dependencies are not correct:

What you have set up is your Execute SQL Server...

SSMS caches the data from your queries locally in TEMP. If you are returning a large amount of data (which is sounds like you are doing), then yes -...

Using SQL Server maintenance plans, you have several options:

1) Create separate sub-plans for each database. Each sub-plan can be scheduled separately.

2) Use conditional logic on your dependencies and only...