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...

You can also disable the reports so they don't get generated at all (my preference, since they are rather useless IMHO). Open the maintenance plan and click on the...

This actually does not have anything to do with the database snapshot that you created. If you look at the message, the error is on the MSDB database:

Executing the...

Jason-181907 (9/21/2009)

---

For those that use "simple" recovery model, when it comes to backups, does it matter if you are doing full backups or simply backing up the .mdf/.ldf files? ...