I'm not quite sure I understand the question, but I'll try.

If you add SQL Services to the cluster administrator tool, you should absolutely make sure they are set to restart....

I agree with thoughts that this could be a misinterpretation of the situation. If an entire database needs encrypting, my thought is that NO ONE should have access to it....

My take on this post is (s)he wants us to build the actual database.

Read Books Online. It has all sorts of useful information on how to do this task.

I'll have to check into that myself. I never bothered to look and we do need that info.

Thanks, Lynn & Grant.

Your best bet is to run a day long session of Profiler and PerfMon to identify your issues.

Or have both run sample traces every X number of minutes. But that's...

If you're getting NULLS, there's not a whole lot happening. But just an FYI, MANU-J is using an...

The maintenance plans will always look in the system tables for backup file names when cleaning up old data. The only way to delete old backups without affecting the system...

I know a SAN admin who holds on to information like a Scottish miser holds on to money. Anytime he's asked a question about setup, his first response is "Why?...

Ahh. For some reason all the SANs I've come across use multiple disk controllers. I've never heard of one with only one controller, unless the SAN used logical drives only...

Lynn Pettis (4/27/2010)

---

Sounds like all you may have restored is the production database. Did you setup the logins/users as they were setup on the hosted system? It sounds...

Grant Fritchey (4/27/2010)

---

Brandie Tarvin (4/27/2010)

---

If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a...

homebrew01 (4/27/2010)

---

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken....

What is Data Provider "MSDASQL"?

I've never heard of this one before.

I'm glad it's working now. Sounds like the filename was kept in a table and re-running might have cleared the cache.

Well that seems to be the problem right there. The job is failing by trying to delete a file that doesn't exist.

Perhaps you should check the job, see if...