1. Make sure that the two partners that is the principal server and mirror server, are running the same edition of Microsoft SQL Server. The partners require either SQL Server Standard Edition or SQL Server Enterprise Edition or SQL Server Developer Edition.
Choosing a database backup strategy is crucial because it determines how data in your SQL Server database is protected. You can read more about database backup strategies, but here we are going to present you some statistics on how SQL Backup And FTP users backup their databases. The numbers are based on a sample of about a thousand users.
17% of users do not do automatic scheduled backups
Some of SQL Backup And FTP users create backups manually, without any schedule. This backup strategy is, for example, good in the development environment when you need to quickly take a snapshot of the current database state. But in production, you need to make sure that your database is secured by regular backups. Read more »
Before Configuring mirroring, make sure that you have 3 different database instance is ready to use in same windows server or in different windows server.
Connect to Principal server > select database > go to properties > select mirror.
Click on > Configuring security button, a popup windows “Configuring Database Mirroring Security Wizard” will appear. Click on > Next > Include Witness Server? > Click on > Yes > Next > Next > Choose Principal Server Instance (as already selected in drop down box) > Listener Port: 5022 > Endpoint name: Mirroring > Click on Next. Read more »
DB mirroring, maintaining two synchronized copies of database is called mirroring. Secondary database will be in NO-RECOVERY always. Only one copy of database is available to user at any time.
Mirroring implemented by combination of other 3 high availability concepts. Read more »