Restore SQL Database with NoRecovery option Using Veeam

 In this post, we are looking into how to recover Microsoft sql database for SQL mirroring setup. A quick guide rather than step by step. 

Before you use Microsoft SQL Management Studio to configure mirroring, you need to back up the database and restore as NoRecovery state.

[Backup]

• Configure to backup using Veeam Backup & Replication or use Veeam agent
• Backup policy enable application-aware setting & backup the transaction log

• Run a backup

[Restoration]

Note: Tested on Veeam Backup version 9.5 Update 4b, v10a and v11

• Use Veeam Explorer for Microsoft SQL to restore the database.
• When come to after define the specific database files target location page, you will have a page to select the state that would like to recover.

• Select "NoRecovery"
• Proceed with recovery

[End result]

Database restored

Example:- DB4. DB will be in "Restoring state"

You can proceed to configure mirroring and bind to DB4. Mirrored success will look like DB1

Create Azure Archive Tier Storage

In this post, we are going to check out how to create azure archive tier storage, as a good location for long term data retention.

To do so, access to Azure portal (https://portal.azure.com)

Click + Create Storage

Enter the storage account name, select Locally Redundant Storage replication & Leave the rest default settings

On Advanced Tab, change blob access tier to "Cold". Remember to change to COLD

Review the settings & create storage.

Once done,  go to Blob Service | Containers | Create Container ( + Container) to store your data

The way that you configure the above steps is basically to set up a storage account as usual and initially configure it as 'Cool' storage (since you. can't do Archive storage directly). You then upload files there (typically using Azure Storage Explorer). The final piece of the puzzle is to change the access tier from 'Cool" to 'Archive" by right click mouse clicking on the item. 

For backup data, you can accomplish this by using Veeam v11- Azure Archive Tier. 

Stay Tuned on v11. 

Demo Mail as a Service Using Veeam

Previous blog post, we have talked about the architect and component require to setup Mail as Service to protect Microsoft Office365. Next post, we will look at how does it look like.

Interest to learn more, please view this video:

Architect Mail as a Service Using Veeam

In this post, we are going to explore how to use Veeam to provide "Mail as a Service" on protecting Microsoft Office365.

To know more, please view the video below