Last Updated On : Tuesday, May 22, 2018Clustering SQL Server 2012 Overview In this lesson we will discuss the concepts and implementation behind Clustering SQL Server 2012. A SQL Server 2012 failover cluster instance is a special deployment of SQL Server 2012 that stores database files on a shared storage device. If the server that […]
Last Updated On : Wednesday, May 23, 2018Clustering and AlwaysOn Overview Clustering and AlwaysOn are two strategies for making Microsoft SQL Server 2012 databases highly available. Failover clustering is a more traditional approach while making sure the availability of database in the incident where server crashes. If you are planning to deploy a failover cluster instance, […]
Last Updated On : Wednesday, May 23, 2018Configuring SQL Server 2012 Components Overview Microsoft SQL Server 2012 database administrators (DBAs) must be able to deploy not only the Database Engine but also take a look at configuring SQL Server 2012 components like Analysis Services and Reporting Services in either Native or SharePoint integrated mode. In […]
Last Updated On : Wednesday, May 27, 2015Whether you perform a restore operation depends on the current state of the database. You can check the status of a database by using the following statement: SELECT databasepropertyex (‘databasename’, ‘Status’); The output from this statement is as follows: – ONLINE The database is operating normally. – OFFLINE […]
Last Updated On : Wednesday, May 27, 2015When you restore a publication, distribution, or subscription database, you must also restore the master and msdb databases on the instance. This ensures that all three databases are consistent with respect to replication configuration and settings.