If this is new drives - I would do the following:

1) Shut down all services (SQL Server, etc...), change to Manual startup type

2) Change drive letter on D: to X:...

Well, I am not sure that I would approach it that way. It all depends upon how you are going to get that new storage available. Is the...

There are two options for the copy database wizard - which one are you selecting?

FWIW - I have found it to be a lot easier to just do a backup/restore...

Why is your upgrade failing? I am going to guess that it is because you are getting an error. :w00t:

If you wouldn't mind posting the error you are...

From cluster admin - find the group that has SQL Server as a resource. It will be the group that also has the R: drive as a resource.

Add all...

The SQL Server resource needs to be dependent upon the drive resources so that SQL Server can 'see' them. If the drives are not resources in the same resource...

bpowers (8/11/2009)

---

I appreciate the help. I have around 450 indexes that are over 50% fragmented. From what I have read I need to rebuild rather than reorganize. I do not...

SQL Server Maintenance Plans - schedule using SQL Server Agent

SQL Server Integration Services - schedule through Windows Task Scheduler or SQL Server Agent

SQL Server Agent Jobs

Windows Task Scheduler with a...

You can alter the database from full recovery model to bulk-logged during the index rebuilds. That will cause the rebuild operation itself to be a minimally logged operation. ...

ouqiwu (8/10/2009)

---

Hi,

We like to upgrade our database from SQL server 2000 to 2008.

I used named instance, name EOS50, for SQL server 2008 instance. But this solution requests to add EOS50/...

Thanks for the links - not sure where in there it talks about side-by-side installation, but I will review it in more detail when I have some time.

JC (8/10/2009)

---

Hi Jeffrey

i wil llook at this scenario you suggested

I have already written my plans in SSMS though

I did some testing the last time with BIDS and I had all...

What part of the SQL Statement are you trying to use a variable for? SQL has certain limitations on where a variable assignment can be used and if you...

The only compelling reason I can think of is the fact that SP3 is a rollup of the changes and fixes made since SP2. That includes the cumulative updates...

Here is what I do:

Create SSIS package in BIDS

Import Maintenance Plans into new project

Save

Now, if I need to reinstall - or even install on a new server - all I...