The witness is used for automatic failover in High Safety mode - The database is not mirrored to the witness server

http://msdn.microsoft.com/en-us/library/ms175191.aspx

Shrinking MSDB will not affect your Log Shipping setup. You're not deleting any data from MSDB

http://www.sqldbadiaries.com/2010/10/24/syspolicy_purge_history-what-is-it/

I've dealt with corrupter maser databases before - Instead of rebuilding all system databses, which is the fix for master db corruption, I did the following:

Took a previous backup of...

I wouldn't worry too much about the DB logins and their permissions as these are stored in the user database itself.

The main thing is the instance level logins and...

Since you can't mirror system databases which is where this info is stored - The best thing to do is to script out the logins and permissions. Do this on...

System databases can be restored as user databases on your DR servers - Just keep track of which ones belong to which servers.

When you have downtime on the Prd servers,...

muthyala_51 (6/6/2013)

---

I have an index occupying almost 77 GB space on the drive which is 70 percent fragmented. I am trying to calculate the theoritical size of this index. This...

Make sure that the SQL Agent service account also has permissions to the share..

ikonrao (6/6/2013)

---

We have a table in which we want to know whether any of the columns has unique constraint defined.

Or if we can get create table statement for that table,...

I would implement a "Log Shipping" scenario between the servers and then just cut-over when the time comes

You don't need to take SQL Services down - Let the service pack do that for you,...

Query Performance Tuning Distilled - Grant Fritchey

Raymond van Laake (6/5/2013)

---

Hey,

I have a SQL 2008 R2, running on Windows Server 2008, with all latest service packs and updates. It runs approx. 30 databases that totals over 500GB...

Thanks

Will add it into my where wait_type not in() list