Configuring Database mirroring step by step – SQL Server 2012

Posted on June 21, 2013 by uday arumilli

Configuring database mirroring step by step in SQL Server 2012

Database Mirror topology_Diagram

Here is a video that demonstrates how to configure database mirroring on SQL Server 2012.

Step by Step guide to database mirroring – Part 1

Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , | 5 Comments

Configuring Log shipping step by step in SQL Server 2008

Posted on June 21, 2013 by uday arumilli

Configuring Log shipping step by step in SQL Server 2008

I just have come across with a video tutorial which was created by Mr. Keshav Singh. I really appreciate him for his hard work. I just got overall view on log shipping.

Please have a look at below videos on Configuring Log shipping step by step in SQL Server 2008

SQL Server 2008 Log shipping Part -1

Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , | 1 Comment

“Ctrl + R” is not working in SQL Server 2012: “Ctrl+R was pressed .Waiting for second key of chord..”

Posted on June 10, 2013 by uday arumilli

“Ctrl + R” is not working in SQL Server 2012: “Ctrl+R was pressed .Waiting for second key of chord..”

 

Keyboard short cut “Ctrl+R” is used to Show or hide the query results pane in SQL Server 2005/2008/R2 whereas in SQL Server 2012 it’s not working by default.

 

After installing SQL Server 2012 if you press Ctrl+R then it echo’s the message:
“Ctrl+R was pressed .Waiting for second key of chord..”

 

It’s very handy shortcut for SQL developers. Now let’s see hot to configure SQL Server 2012 SSMS to use the “Ctrl+R” functionality.
Open SQL Server 2012 management studio.
Go to Tools – > Options – > KeyBoard



Under “show commands containing” select “Window.ShowResultsPane“

 

Select “SQL Query Editor” under “use new shortcut in”.


 

Once it is selected, make sure cursor is placed on text box “Press Shortcut keys” and press Ctrl+ R on keyboard.


Click on “Assign” and then click on “OK”.

Then you would be able to use the shortcut Ctrl+R to show/hide the output window.

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , | 3 Comments