Hey everyone. Thought I would follow up with my testing.

Right now, I really like the Red Gate solution. Very simple, effective and pretty inexpensive which fits nicely into my budget.

The...

Luke L (10/8/2008)

---

Yes this is possible. You can either create the new database first or create it during the restore operation...

Make note of a few things...

Be very careful to...

Steve Jones - Editor (9/23/2008)

---

It should be using SSIS, which I think has a few issues between 32 and 64 bit. However if you run it from the source, or...

MIJ (8/6/2008)

---

Service Packs are cumulative, so you should be able to just install SP2 w/out first installing SP1.

However, SP2 had some issues with maintenance plans, so if you use them...

I am not familiar with BCP...can I trouble you to fill me in?

THx.

Think I figured it out.

Will stand by to confirm.

Thanks for the input. I appreciate.

I created two maintenance plans.

One runs nightly for backups.

The second one runs once a week, on Sunday, and it does the updating of statistics, defrags...

Grant Fritchey (2/7/2008)

---

Database design and indexing design is a tough topic and it takes time to get it right. Two books that you might want to add to your library...

floyd99 (2/4/2008)

---

I did some research into this a while back.

When SQL (2005) is installed, it automatically creates some windows groups (SQLServer2005*).

These groups have various permissions for different things.

So, create a...

Michael Earl (2/4/2008)

---

Probably the most secure thing you could do is have everything run as LocalSystem (not a domain account).

Using a domain account, having one account per server and per...

Appreciate the help.

Can you give some suggestions on how to properly detach the database?

I know once I detach the database, I move the transaction log file to the new...

For this particular move, I am just moving the t-logs from one array to a new array on the same server.

Wow...the tempdb.mdf file is growing right before my eyes. It has jumped from 10mb to 40gigs over the last 20 minutes.

how can I track what is going on? Any suggestions...

Thanks guys. I appreciate it.

Sounds like I have some work to do. 🙂

Do you have any suggestions on how to come across and find the information I need to find...

Following up here.

Well, this is turning to be into quite a task (but I am up for it) trying to figure out. Learning a ton, so that is good.

Let...