There is no need to perform two integrity checks - perform your integrity check first, then backup the database.

I would have a separate plan (or sub-plan) that only performs the...

That might work - but, be aware that during that operation...

Roust_m (9/10/2010)

---

So there is no way to rebuild the indexes without blowing out the files? What that SORT_IN_TEMPDB option is about then? Isn't it supposed to prevent the...

You were obviously able to connect to SQL Server - so, I am not sure what the problem you are experiencing is.

If you had to right-click and run as Administrator...

Please open a new thread - you'll get many more people looking at your question.

cagan (9/9/2010)

---

Thanks for the suggestions. I did some research and it looks like I need a dharma driver to make my database link to SQL, it is an odbc/oledb...

What is recent? Current data, one day - one week?

If you need current data, you have one choice - really. That would be replication - and you already...

How long does it currently take to backup?

What is your maintenance window for backups?

The first thing I would look at is buying a third-party backup utility that compresses the backups...

Not sure what you mean when you say replication didn't work. That is definitely one of the options for creating a reporting server.

Other options are:

o Database Mirroring (Enterprise Edition...

What is the database system that is running on AIX? Most of the database products that will run on AIX will have some type of ODBC/OLEDB access. Once...

jerry-621596 (9/8/2010)

---

Thanks! I figured, and told them as much. Was totally shocked that these guys would risk the contention.

It all seems to be working better now. Changed...

sanderstad (9/8/2010)

---

During the installation of a cluster all the cluster aware services are set to manual. The reason is probably because when the server reboots you want to be in...

Just to be clear - you are not really upgrading an instance of SQL Server. You are installing a new instance and migrating the databases to the new instance.

GilaMonster (9/7/2010)

---

My preference is two maint plans (when I use maint plans)

1) - Rebuild indexes, update statistics

2) - Integrity check, backup database

Integrity check before backup. There is no point whatsoever...

Again, you will need to upgrade to at least SP3 CU4 or the locked pages in memory option won't be honored. You also have to start SQL Server with...