If you've already got the users set up in the Target server, don't worry about deleting and creating. As suggested earlier, just use sp_change_users_login and that will fix the database.

However,...

Rectify it? Why? Is it actually causing you a problem?

If so, please describe the problems it's causing. If you're just concerned because you've seen it increase memory utilization and you...

NJ-DBA (4/29/2010)

---

The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.

The Cluster Service should...

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