• About
  • SQLWikis
  • Useful Links and Tools
  • My Other Musings
  • Tools Tips and Tricks
  • Webcast Videos
  • Webcasts and PPTs
  • Business Rantings

TroubleshootingSQL

~ Explaining the bits and bytes of SQL Server

TroubleshootingSQL

Category Archives: Mirroring

How to move data files of the mirror database

September 26, 2010

The ideal scenario for database mirroring would be to have the principal and secondary server instances be exact clones of …

Continue reading »

CU10 is a must for all instances where mirroring is being used

June 28, 2010

If you happen to use Database Mirroring on SQL Server 2005, then Cumulative Update 10 for SQL Server 2005 Service …

Continue reading »

How to generate an Automatic Failover for a Mirrored Database

April 20, 2010

I have heard this question multiple times: How do I generate a condition which will cause an Automatic Failover of …

Continue reading »

Database Mirroring with SQL Authentication

December 30, 2009

It’s quite fascinating that a database can be mirrored across two sites and a front-end application will not have a …

Continue reading »

♣ Seek Count

  • 172,415 seeks

♣

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 707 other followers

♣ Linked Servers

Facebook Fan Page Twitter RSS Feeds Feedburner Feeds LinkedIn Networked Blogs Google+

♣ Ghosted Posts

♣ TroubleshootingSQL is on Facebook too!

♣ IAM

  • Backup (18)
  • Data Recovery (6)
  • Debugging (9)
  • Did you know (19)
  • Memory (9)
  • Microsoft (3)
  • Mirroring (4)
  • Performance (19)
    • Disk (2)
    • Query Tuning (8)
  • Replication (3)
  • Reporting Services (2)
  • Scripts (53)
    • Monitoring (8)
    • Powershell (5)
    • TSQL (33)
    • WMI (10)
  • SQL Agent (1)
  • SQL How To (12)
  • SQL Myths (2)
  • SQL Server (34)
    • Best Practices (15)
  • SQL Server 2012 (6)
  • SQL Setup (11)
  • T-SQL Tuesday (10)
  • Tools (54)
    • Data Analysis (9)
    • Data Collection (19)
    • Monitoring (12)
      • System Health Session (4)
    • Troubleshooting (6)
  • Tools Tips and Tricks (13)
  • Troubleshooting SQL Issues (38)
  • Twost (10)
  • Webcasts (13)
  • Wikis (13)

♣ Spatial Map

Locations of visitors to this page

Creative Commons License
TroubleshootingSQL by Amit Banerjee is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Transaction Log

June 2012
M T W T F S S
« May    
 123
45678910
11121314151617
18192021222324
252627282930  

Blog Roll

  • Brent Ozar's Blog
  • Kevin Kline's blog
  • Sudarshan's Blog
  • Jonathan Kehayias' Blog
  • CSS Replication Blog
  • CSS SQL Server FAQ
  • CSS Escalation Blog
  • Paul Randal's blog
  • Pinal Dave's Blog
  • Balmukund's Blog

Recent Tweets

  • New blog theme for troubleshootingsql.com #sql ^AB fb.me/13m8oOVVv 12 hours ago
  • The TroubleshootingSQL Daily is out! bit.ly/znfU1a ▸ Top stories today via @sqlpass 23 hours ago
  • The TroubleshootingSQL Daily is out! bit.ly/znfU1a ▸ Top stories today via @sqlbelle @mnDBA @AirborneGeek 1 day ago
  • The TroubleshootingSQL Daily is out! bit.ly/znfU1a ▸ Top stories today via @SQLServerCentrl @programmersedge @Bill_Pearson 2 days ago
  • The TroubleshootingSQL Daily is out! bit.ly/znfU1a ▸ Top stories today via @A_Bansal @JamesSerra 3 days ago
Follow @tblshootingsql

TOP (10) ORDER BY Date DESC

  • Awesomesauce SQL Server 2012: System Health Session
  • SQLDIAG and SQL Server 2012
  • Awesomesauce SQL Server 2012: Performance Dashboard
  • XML Plans Saga–Breaking Dawn Part 2
  • XML Plans Saga – Breaking Dawn Part 1
  • XML Plans Saga – Eclipse
  • XML Plans Saga –New Moon
  • XML Plans Saga –Twilight
  • Microsoft TechEd 2012–Multiple rows affected
  • Missing indexes and Create Index command from the procedure cache

Category Azure

#TSQL2sDay Backups Best Practices CHECKDB Cluster Setup Data Analysis Database Files Data Collection Deadlocked Schedulers Debugging Did you know Export Import Wizard Extended Events Indexes Maintenance Plans Memory Mirroring Monitoring Performance Powershell Profiler Trace Query Plan Query Tuning Restore RML Scripts Setup Troubleshooting SQL Memory SQL Nexus SQL Server SQL Server 2005 SQL Server 2008 SQL Server 2012 SQLServerFAQ Stack Dump T-SQL Tools Tools Tips and Tricks Troubleshooting Update Statistics VDI VSS Webcasts WMI XML Plans

Blog at WordPress.com. Theme: Chateau by Ignacio Ricci.

Follow

Get every new post delivered to your Inbox.

Join 707 other followers

Powered by WordPress.com