70-462 Administering Microsoft SQL Server 2012 Databases Objective

178 Articles

Clustering and AlwaysOn in SQL Server 2012

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, […]

Configuring SQL Server 2012 Components

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 […]

Checking Database Status

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 […]