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…
Showing posts from January, 2011
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…