Showing posts from January, 2011

What is Database Mirroring

In the proposed database mirroring solution there will be two groups of active-passive windows clusters deployed at each location (PRIMARY SITE and Secondary Site). The Primary Site will be the prima…

SQL Server Management Studio (SSMS) – Keyboard Shortcut Keys

Here is list of Shortcut keys to work with SSMS handy. Action SSMS-Shortcut Key Move to the SQL Server Management Studio menu bar ALT Activate the menu for a tool component ALT+HYPHEN Display the con…

SQL Server Service Account Privileges

SQL Server 2005 Books Online indicates that the SQL Server service account requires permission to start the following related services (among many other requirements): SQL Server Active Directory Hel…

Log Shipping vs. database mirroring

Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server instance.  It can oper…

Log Shipping – NORECOVERY vs. STANDBY mode

When you restore a transaction log using the NORECOVERY option, SQL Server does not need to analyze the transaction log and roll back any uncommitted transactions at the end of the restore process. …

Log shipping –Failover

When it's time to failover to the secondary database, so that it becomes our primary database, we have to do the following· if possible, back up the transaction log on the primary database  …

Reading SQL Trace Files using fn_trace_gettable function

While working in SQL Server, most of the time we create trace files(.trc) to identify performance bottleneck. You can create trace files using SQL Profiler or you can use SQL as well. Most of us woul…
Subscribe Our Newsletter