Skip to content

SimpleSQLDBA | Shadab Mohammad

Microsoft SQL Server Tips and techniques

Home
Scripts
- Check Memory Pressure for the Current Processes in SQL Server
About

failover

Microsoft SQL Server Clustering – Advanced Interview Questions

November 6, 2018November 6, 2018 ~ easyoradba ~ Leave a comment

A very good list of SQL Server Advanced Interview Questions on Clustering SQL interview questions & answers on SQL Server Failover Clusters - I https://www.sqlshack.com/sql-interview-questions-answers-on-sql-server-failover-clusters-i/ SQL interview questions & answers on SQL Server Failover Clusters – II https://www.sqlshack.com/sql-interview-questions-answers-on-sql-server-failover-clusters-ii/

Advertisement

Sql server 2008 database mirroring manual failover

February 9, 2014 ~ easyoradba ~ Leave a comment

In case your mirroring has been suspended and you have tried everything else and nothing works. Your last option is to break the mirroring and restore the mirror database and connect the client application to the mirror site. Before proceeding with this please note that doing this will require you to rebuild the Data Mirroring … Continue reading Sql server 2008 database mirroring manual failover

Shadab Mohammad, MCITP

Pages

About
Scripts
- Check Memory Pressure for the Current Processes in SQL Server

2005 2005 2008 2012 2008 2012 Attach Backup Change Command Create Database Mirroring Data Mirroring Deatach Delete DUPLICATE Enable Encryption Execute failover Indexed views Insert Job large Listener Log Login Logins manual Microsoft mirror Mirror Database Mirroring Mode MSSQL Null Offline Online Oracle Partner Powershell Random Rebuild Indexes reconfigure Restore Rows Safety scheduler Scripts Select Server Snapshot Database sp_start_job sql sql-authority sql-query sql-scripts sql-server sql-stored-procedure sql-tips-and-tricks sqlcmd SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 2012 Stored Procedure T-LOG T-SQL Table task technology Transaction Transfer Truncate Log TSQL Windows XP_CMDSHELL

Archives

Recent Posts

SQL Serve 2019 CTP 2.5
Create C2 Native Auditing for SQL Server
Install SQL Server 2019 on Docker
Microsoft SQL Server Clustering – Advanced Interview Questions
Enable TDE (Transparent Data Encryption) for SQL Server 2016

Email Subscription

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

Email Address:

Join 380 other subscribers

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Follow Following
- SimpleSQLDBA | Shadab Mohammad
- Already have a WordPress.com account? Log in now.