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

Friday, January 29, 2021

Backup & DR Webinar

Backing up data and preparing for a data loss event is a fundamental part of managing an IT environment, so it’s surprising just how many IT admins fall short of developing a proper strategy to cover all aspects. Until it’s too late.


However, it’s easier said than done. It would be nice to have a cookie-cutter backup plan that works for everybody, but the truth is that every IT environment is unique, with its own organizational and infrastructural characteristics and demands. Creating a workable backup and disaster recovery plan requires a thorough understanding of what you need and what you’ve got. 





Learn how to create, deploy, and maintain a customized backup and disaster recovery strategy in an upcoming webinar from Altaro hosted by Microsoft MVPs Andy Syrewicze and Eric Siron. Attendees will choose the scenarios and the experts will build the solutions live on air, demonstrating how to implement key strategy considerations, including, backup/DR fundamentals, creating a company specific framework, establishing RTO/RPOs, understanding compliancy & highly regulated environments, and strategy for implementation.


As an added bonus, all attendees will also receive a copy of the highly praised eBook The Backup Bible written by webinar co-host Eric Siron. The 200+ page eBook is a complete guide to backup & DR and forms the foundation upon which this webinar is structured. 


The webinar will be held on Wednesday 3 February and as usual presented twice at 3pm CET/9am EST/ 6am PST and at 7pm CET/1pm EST/10am PST.


Save your seat (and get your free eBook) now!