How to Remove a Witness Server from Database Mirroring? SSMS:- Right Click on Principal Database > Tasks > Mirror > Remove TCP address from the Witness > Click oK T-SQL:- ALTER DATABASE AdventureWorks SET WITNESS OFF
What is Hardening? As quickly as possible, the log buffer is written to the transaction log on disk, a process called hardening.
What are the Database Mirroring states? 1) SYNCHRONIZING:- The contents of the mirror database are lagging behind the contents of the principal database. The principal server is sending log records to the mirror server, which is applying the changes to...
What are the prerequisites for Database Mirroring? Database base should be in full recovery model Database name same on both servers Server should be on same domain name. Mirror database should be initialized with principle server
What is Database Mirroring? What are the benefits of that? Database mirroring is an option to improve the availability of a databases which supports automatic fail over with no loss of data. Benefits:- Increases data protection Increases availability...
What are the common scenarios to Restoring the Data? 1) To restore the lost and corrupted data after a system failure 2) To restore a database onto a development system for user by application developers while developing and testing new code. 3) To restore...
What is Restore? What are the recovery states? Explain Each? Restore means recover the data from backups. There are three recovery states for Restore. (1) With Recovery (2) With No-Recovery (3) Standby. a) With Recovery:- With Recovery option the Database...
Restore Strategy? 1. First restore recent last full backup 2. Then restore last Diff. backup 3. Then restore all Transaction Log backups since recent Full/Diff backups.
Explain about Tail of Log? Give the syntax? The tail-log backup is the last backup that is used to recover the database to the point of failure (supports only Full or Bulk-logged recovery models). (e.g. Assume that 4.00 P.M. log backup is performed and...
Backup strategy? ® Generally Backups are done by client requirement. But Most of the companies are following this strategy. 1) Full Backup:- Every sunday nightly 10.00 PM 2) Differential Backup:- Every day nightly 10.00 PM 3) Transactional Log Backup:-...
