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:-...
How is a point in time recovery performed independent of a server down situation? It depends on which backup types are issued. In this example let's assume that full, differential and transaction log backups are issued. Restore the most recent full backup...
What is Use of Backups? Backups is safe guard to Databases because Data may can loss due to many failures such as Media Failures, User errors, Hardware Failures and Natural Disasters etc. With good backups, we can recover database from failures.
What is Backups? Types of backups? (i) “A copy of data that is used to restore and recover the data after a system failure”. There are four types of Backups available (1) Full Backup (2) Differential Backup (3) Transaction Log Backup (4) File /File Group...
