A couple of points on your process:

Item 1: SQL Server service accounts should not be setup as local administrators. Whether or not you use a domain user or local...

You use the procedure sp_change_users_login with the auto login parameter and identify the login/user to be fixed.

Look up the procedure in Books Online for exact syntax and available parameters.

Yes, definitely update to the latest service pack. And also make sure your client tools are at least the same version (if not greater) than any instance you are...

How did you copy the mdf/ldf files in the first place? Did you shut down SQL Server first - then copy the files? If so, then attaching those...

Well, first of all you shouldn't be allowing your databases to autogrow. You should manually grow them out to at least 6 months of space and monitor the usage....

In addition to what the others have stated, both Quest and SQL Backup utilize multiple 'threads' for the backup process - reducing the time it takes to backup in addition...

If you want to create all logins from prod - then sp_help_revlogin would be the way to go. I didn't want all users on the prod system, so I...

First, you have to create the login on the secondary server with the same SID that exists on the primary server. Lookup CREATE LOGIN in BOL for exact syntax,...

Yes, that's all you should need to do.

Reorganize is fully logged, rebuild can be minimally logged when the recovery model is simple or bulk-logged. Either way, the transaction log backup after that operation will be very...

george sibbald (4/8/2010)

---

If I understand correctly you are already switching to simple mode to shrink the log, so why don't you switch to simple, reindex, shrink log,switch to full, backup.

whether...

I did something similar using Powershell and SMO - you only need to install Powershell on your CMS server and use that instance to query all of the servers.

Or, you...

Indianrock (4/8/2010)

---

The decision was made to go to simple recovery during a large upcoming conversion ( 3 million + inserts). Should we take our preconversion full backup before or...

That is correct - deny supercedes...

You have to put the AD group in brackets:

Deny View Server State To [DOMAIN\AD Group Name];