70-462 Articles

139 Articles

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

Restoring a Database Protected with Transparent Data Encryption

Last Updated On : Wednesday, May 27, 2015You can restore a database that uses Transparent Data Encryption (TDE) as long as you have access to the certificate and private keys. When planning the backup of databases protected with TDE, include the certificate used to create the Database Encryption Key (DEK) and the Database Encryption Key […]