Search This Blog

Friday, February 19, 2021

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







Sunday, February 14, 2021

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. 

Sunday, February 7, 2021

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:

Monday, February 1, 2021

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