Features of SQL Server 2012 1. AlwaysOn Availability Groups -- This feature takes database mirroring to a whole new level. With AlwaysOn, users will be able to fail over multiple databases in groups instead of individually. Also, secondary copies will...
Linked server:SQL Server 2005 new feature. A linked server is simply a connection to an Object Linking and Embedding Database (OLEDB) data source. THE MAIN PURPOSE is to access remote databases from source server instance without login. Permissions to...
Violation of PRIMARY KEY constraint 'PK_Whatever': Why you get this error: Trying to insert duplicate records in publisher or subscriber How to find: Once we get this error message , replication is going to fail. Go to replication monitor> Properties...
SQL Agent SQL agent, also known as SQL server agent, is a Microsoft SQL server relational database management system(RDBMS) background tool. SQL agent allows the database administrator (DBA) to schedule automated execution jobs, as well other management...
SQL DMVs Top 15 SQL Dynamic management Views 1.sys.dm_db_index_physical_stats: This dynamic management function returns information regarding data and index information for data tables and views 2.sys.dm_exec_requests: This view shows information regarding...
What is database mirroring? In which SQL Server version it was introduced? Why mirroring why not Log shipping? What are the difference between Log Shipping and mirroring? Can you explain the specific usability of mirroring, Log Shipping and Replication?...
What are the DMV's in SQL Server ? Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Important Dynamic management views and functions...
What is the syntax to stop the Database Mirroring? Alter database
1In which Recovery model we can use in Mirroring? In mirroring the principal and mirror databases are used only full recovery model
What is Role-switching? Inter changing of roles like principal and mirror are called role switching.
