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.
Last Updated On : Wednesday, May 27, 2015You can restore the model and msdb databases by using the same procedure you would use to restore a user database. Because these databases do not use the full recovery model by default, you do not need to worry about restoring transaction log backups with these databases. Because […]
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 […]
Last Updated On : Wednesday, May 27, 2015You can use page restore to repair a small number of damaged pages in an otherwise healthy database. Performing a page-level recovery can be quicker than performing other types of restores. If a database file constantly suffers from damaged pages, it is likely that the volume that hosts […]