[EX:/o=ExchangeLabs/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=06a8f17eda834f4881ef057d7b1dc812-a26e5ec4-de]

上記に消去したはずのアドレスが残っているため、転送メールに配信不能の表示がなされる。

完全に消去する方法はありますか。

​[EX:/o=ExchangeLabs/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=06a8f17eda834f4881ef057d7b1dc812-a26e5ec4-de] 上記に消去したはずのアドレスが残っているため、転送メールに配信不能の表示がなされる。完全に消去する方法はありますか。  Read More

​

Not a new topic, but looking for any new insights!

We have a significant number of large, shared mailboxes in EXO – and Outlook desktop users who need to do frequent searches of these mailboxes. With Outlook desktop’s caching behavior [regardless of whether or not ‘download shared folders’ is checked/unchecked], search functionality is either not working at all, or not providing complete/accurate results if it [sort of] works.

Of course, Outlook desktop users mutiny over trying to use the Outlook Web App for shared mailbox functions.

Does anyone have a solid solution or recommendation for the searching of large, shared mailboxes?

​Not a new topic, but looking for any new insights! We have a significant number of large, shared mailboxes in EXO – and Outlook desktop users who need to do frequent searches of these mailboxes. With Outlook desktop’s caching behavior [regardless of whether or not ‘download shared folders’ is checked/unchecked], search functionality is either not working at all, or not providing complete/accurate results if it [sort of] works. Of course, Outlook desktop users mutiny over trying to use the Outlook Web App for shared mailbox functions. Does anyone have a solid solution or recommendation for the searching of large, shared mailboxes?  Read More

​

No Learn Live da série Certificação GitHub Foundations dessa semana, foram exploradas as possibilidades de automatização com GitHub Actions. A automatização de fluxos de trabalho é essencial para desenvolvedores que desejam ganhar eficiência, reduzir erros manuais e se concentrar em atividades de maior valor.

A sessão foi conduzida por Pablo Lopes, Cloud Advocate na Microsoft, e contou com a participação do Renicius Fostaini, Senior Infrastructure Engineer na ThoughtWorks. Ambos focaram em conceitos e demonstrações práticas para ajudar a audiência a entender como usar o GitHub Actions e GitHub Codespaces de maneira eficiente.

Essa é uma série de lives dedicada a quem deseja se certificar com o GitHub Foundations. Acompanhe a agenda, inscreva-se e participe das próximas sessões!

Inscreva-se AQUI para receber notificações sobre os próximos eventos.

Confira agora um resumo do que foi abordado durante a sessão!

Não Perca a Sessão Gravada

Se você perdeu a live, não se preocupe! O vídeo está disponível no canal do YouTube do Microsoft Reactor. Acesse o link abaixo para assistir à sessão completa:

Pablo e Renicius discutiram como automatizar processos com GitHub Actions e exploraram o GitHub Codespaces, que facilita a configuração de ambientes de desenvolvimento de forma prática e centralizada na nuvem.

Ambos fizeram uma introdução sobre as vantagens de usar essas ferramentas, destacando como elas ajudam a solucionar problemas comuns enfrentados por desenvolvedores, como a dificuldade de replicar ambientes e a necessidade de automatizar tarefas repetitivas. Eles enfatizaram que a automação de fluxos de trabalho é essencial para ganhar eficiência, reduzir erros manuais e se concentrar em atividades de maior valor.

Os principais objetivos da sessão foram:

Utilizar o GitHub Codespaces de maneira eficiente.
Escrever código com o GitHub Copilot.
Automatizar processos com GitHub Actions.

GitHub Codespaces

Uma das maiores dificuldades que muitos desenvolvedores enfrentam é replicar ambientes de desenvolvimento em diferentes máquinas.

Como Pablo explicou na live, o famoso “funciona na minha máquina” é um problema recorrente e pode atrasar o progresso de um projeto colaborativo. O GitHub Codespaces resolve essa questão ao oferecer um ambiente virtual que permite o desenvolvimento direto na nuvem.

Com o GitHub Codespaces, é possível resolver esse problema criando e configurando um ambiente de desenvolvimento com um simples clique. Este ambiente é uma máquina virtual que pode ser facilmente escalada, permitindo que todos os desenvolvedores de uma equipe utilizem um setup padronizado, sem a necessidade de instalações locais complexas.

Qual é o ciclo de vida de um Codespaces?

O ciclo de vida de um Codespaces envolve as seguintes etapas principais:

1. creating a Codespaces (criação do Codespaces): O ciclo de vida do Codespaces começa com a criação de um novo ambiente, onde o desenvolvedor(a) seleciona o repositório e as configurações desejadas. Esse ambiente é então configurado automaticamente, incluindo extensões e dependências.

2. rebuilding a codespace (reconstrução do codespace): Durante o uso, pode ser necessário reconstruir o Codespace, especialmente se houver mudanças significativas nas configurações ou dependências do projeto (por exemplo, modificações no arquivo .devcontainer.json). A reconstrução garante que o ambiente esteja sempre atualizado com as configurações mais recentes.

3. stopping a codespace (pausa do codespace): Para economizar recursos, o Codespace pode ser pausado quando não está em uso. Essa etapa permite que o estado do trabalho seja salvo, e o desenvolvedor possa retomar do ponto em que parou sem perder nenhuma alteração.

4. deleting a codespace (exclusão do codespace): O ciclo de vida termina com a exclusão do Codespace quando ele não é mais necessário. Essa etapa libera os recursos associados e encerra o ambiente de forma definitiva.Principais Benefícios do GitHub Codespaces

Benefícios do GitHub Codespaces

Os principais benefícios do GitHub Codespaces incluem:

ambiente virtual padronizado: Garante que todos os desenvolvedores trabalhem com a mesma configuração, eliminando inconsistências e problemas de compatibilidade entre diferentes máquinas.

escalabilidade flexível: Permite ajustar recursos como CPU e memória de acordo com as necessidades específicas do projeto, garantindo performance ideal para cada etapa do desenvolvimento.

configuração automatizada: O Codespaces utiliza o arquivo .devcontainer.json para configurar automaticamente extensões, dependências e outras configurações, proporcionando um ambiente pronto para uso em minutos.

colaboração simplificada: Compartilhe seu Codespace com outros desenvolvedores, permitindo acesso simultâneo, visualização em tempo real e contribuições colaborativas de forma prática e eficiente.

redução de problemas de configuração: Evita o famoso problema do “funciona na minha máquina“, garantindo que todos os membros da equipe tenham acesso ao mesmo ambiente, com as mesmas ferramentas e configurações.

GitHub Copilot: Seu Parceiro no Desenvolvimento de Código

Pablo e Renicius também apresentaram o GitHub Copilot, uma ferramenta de desenvolvimento de código baseada em inteligência artificial que auxilia os desenvolvedores a escrever código de maneira mais rápida e eficiente.

E explicaram as diversas maneiras como o GitHub Copilot pode ser utilizado, incluindo:

sugestões inline: O Copilot sugere automaticamente trechos de código enquanto você escreve, diretamente no editor, facilitando a incorporação rápida de sugestões sem interromper o fluxo de trabalho.

sugestões por chat: Você pode interagir com o Copilot através de um chat, fazendo perguntas sobre problemas específicos, pedindo exemplos ou explicações.

chat inline: Similar ao chat, mas realizado diretamente no contexto do código em que você está trabalhando. Isso permite obter sugestões específicas ou entender seções de código sem sair do editor.

command palette: A paleta de comandos do editor (como VS Code) permite acessar funcionalidades do Copilot de forma rápida e eficiente.

comentários no código: Escreva comentários descrevendo o que deseja implementar, e o Copilot gera o código relevante com base nesses comentários. Isso é útil para economizar tempo quando você já tem uma ideia clara do que precisa fazer.

Essas diferentes formas de interação oferecem uma abordagem flexível e poderosa para melhorar a produtividade, adaptando-se a fluxos de trabalho de desenvolvimento.

Os participantes também foram incentivados a explorar o GitHub Student Developer Pack, que oferece acesso gratuito ao GitHub Copilot e a outras ferramentas para estudantes.

Automação com GitHub Actions

A segunda parte da live foi dedicada à criação de uma pipeline automatizada utilizando GitHub Actions.

Pablo apresentou um exemplo prático de como criar um workflow simples que executa uma ação personalizada em resposta a um evento de push. O exemplo incluiu a criação de um repositório com um arquivo de ação personalizada e um arquivo de configuração de workflow.

name: A workflow for my Hello World file
on: push
jobs:
build:
name: Hello world action
runs-on: ubuntu-latest
steps:
– uses: actions/checkout@v1
– uses: ./action-a
with:
MY_NAME: “Mona”

No exemplo acima, temos um arquivo de configuração de workflow que executa um job chamado build em resposta a um evento de push. O job é executado em uma máquina virtual ubuntu-latest e consiste em duas etapas: actions/checkout@v1 e ./action-a. A primeira etapa faz o checkout do repositório, enquanto a segunda executa uma ação personalizada chamada action-a com um parâmetro MY_NAME definido como Mona.

Demonstração Prática

Renicius fez uma demonstração prática de como criar uma aplicação estática e automatizar o seu deploy no Azure Static Web Apps. O Azure Static Web Apps é um serviço que permite hospedar aplicações estáticas e APIs serverless de forma simples e rápida, oferecendo integração contínua e deploy automático a partir de repositórios GitHub ou Azure DevOps.

A demonstração foi dividida em cinco etapas principais:

1. criação da aplicação estática: Renicius iniciou criando uma aplicação simples, que consistia em alguns arquivos HTML. O objetivo era mostrar como é possível implementar rapidamente uma aplicação estática que poderia ser distribuída.

2. configuração do workflow: Utilizando um arquivo YAML (main.yaml)

3. compilação do código: A etapa de compilação era realizada para garantir que não houvesse erros antes de prosseguir com o deploy.

4. testes automatizados: Testes foram adicionados para validar o código da aplicação. Esta prática é importante para manter a qualidade e a estabilidade do código, identificando problemas antecipadamente.

5. deploy no Azure Static Web Apps: Por fim, o deploy era feito automaticamente no Azure Static Web Apps, utilizando as configurações definidas no workflow.

Além disso, Renicius usou o GitHub Copilot com o GitHub Codespaces para acelerar o desenvolvimento e a configuração do ambiente de desenvolvimento. Essas ferramentas combinadas permitiram uma experiência de desenvolvimento mais eficiente e produtiva.

Conclusão

A live sobre Automatização com GitHub Actions foi uma oportunidade incrível para aprender sobre as possibilidades de automação no desenvolvimento de software. Pablo e Renicius compartilharam conhecimentos valiosos sobre o GitHub Codespaces, GitHub Copilot e GitHub Actions, demonstrando como essas ferramentas podem ser utilizadas para melhorar a produtividade, a qualidade do código e a eficiência dos fluxos de trabalho.

Se você está buscando otimizar o seu fluxo de trabalho, GitHub Actions e Codespaces podem ser exatamente o que você precisa. Você pode acessar os materiais de apoio da live e cursos gratuitos nos links abaixo e aprender ainda mais:

Codificar com o GitHub Codespaces

Introdução ao GitHub Copilot

Introdução ao GitHub Copilot para Python

Não perca as próximas sessões do Learn Live! Vamos explorar temas como segurança de projetos no GitHub e aumentar a produtividade com GitHub Copilot.

Espero que este resumo da live tenha sido útil para você. Se você tiver alguma dúvida ou sugestão, deixe um comentário. Estamos aqui para ajudar na sua jornada de aprendizado.

Experimente GitHub Actions e Codespaces em seus projetos e veja como podem transformar seu fluxo de trabalho. Para começar, confira os tutoriais e guias práticos disponíveis nos links acima.

Até a próxima live! 😎

​Microsoft Tech Community – Latest Blogs –Read More 

I’m uncertain if this can be achieved but decided to inquire. In the access panel (shown in the attached screenshot), I am interested in repositioning the following items to the top instead of Home and Gallery:

– This PC

– OS (C:)

– Data (D:)

I attempted to drag them but they do not remain in the desired position.

Furthermore, in Explorer, when sorting by date, the folders are displayed before the files. Is there a way to have the files appear above the folders when sorting by dates?

Thank you for your assistance.

​I’m uncertain if this can be achieved but decided to inquire. In the access panel (shown in the attached screenshot), I am interested in repositioning the following items to the top instead of Home and Gallery: – This PC- OS (C:)- Data (D:) I attempted to drag them but they do not remain in the desired position. Furthermore, in Explorer, when sorting by date, the folders are displayed before the files. Is there a way to have the files appear above the folders when sorting by dates? Thank you for your assistance.  Read More

​

Hello everyone,

I’m a newcomer to this forum seeking assistance with an issue I’m experiencing in the Details Pane of Windows 11’s File Explorer.

To provide a clearer understanding, I will be attaching screenshots illustrating the problem.

1. Currently, when I select all files within a specific folder in File Explorer, the Details Pane on the right remains blank:

Upon researching potential solutions, I discovered that upon re-accessing the same folder (the one used as an example), the information does appear in the Details Pane:

Here is a snapshot of my Windows 11 interface:

[Attached Screenshot]

I also want to mention that I am utilizing StartIsBack – StartAllBack.

I have made an attempt to create shortcuts for easy access to the folders I frequently use via the Control Panel, but this approach has not resolved the issue.

If anyone has any insights on how to address this problem and display the details of selected files without the need to repeatedly navigate into the folder via the Control Panel, your assistance would be greatly appreciated.

Thank you.

​Hello everyone, I’m a newcomer to this forum seeking assistance with an issue I’m experiencing in the Details Pane of Windows 11’s File Explorer. To provide a clearer understanding, I will be attaching screenshots illustrating the problem. 1. Currently, when I select all files within a specific folder in File Explorer, the Details Pane on the right remains blank:Upon researching potential solutions, I discovered that upon re-accessing the same folder (the one used as an example), the information does appear in the Details Pane:Here is a snapshot of my Windows 11 interface: [Attached Screenshot] I also want to mention that I am utilizing StartIsBack – StartAllBack. I have made an attempt to create shortcuts for easy access to the folders I frequently use via the Control Panel, but this approach has not resolved the issue. If anyone has any insights on how to address this problem and display the details of selected files without the need to repeatedly navigate into the folder via the Control Panel, your assistance would be greatly appreciated. Thank you.  Read More

​

When working with files on Windows 11, the behavior may vary depending on the method used to transfer them. If you’re moving a file or folder within the same drive, it will simply relocate the item. However, if you perform a search for specific file types within a folder, select all the results, and then drag them to another location, it will create a copy instead of moving them, even if it’s on the same drive.

It’s puzzling why this happens, especially if you haven’t made any changes to the default settings for file operations. If you’re encountering this issue when attempting to move files that were searched for using the Windows 11 search feature, and you’d prefer them to be moved instead of duplicated between folders on the same drive, you may need to explore potential solutions or adjustments to eliminate this behavior.

​When working with files on Windows 11, the behavior may vary depending on the method used to transfer them. If you’re moving a file or folder within the same drive, it will simply relocate the item. However, if you perform a search for specific file types within a folder, select all the results, and then drag them to another location, it will create a copy instead of moving them, even if it’s on the same drive. It’s puzzling why this happens, especially if you haven’t made any changes to the default settings for file operations. If you’re encountering this issue when attempting to move files that were searched for using the Windows 11 search feature, and you’d prefer them to be moved instead of duplicated between folders on the same drive, you may need to explore potential solutions or adjustments to eliminate this behavior.  Read More

​

This installation is fully compliant with 3155 Pro, however, the BingChat key value “IsUserEligible” keeps resetting to 0 every time the system is rebooted. To restore the taskbar icon option and enable Copilot in taskbar settings, I have to use a .reg file that I created by exporting the key.

While this workaround is functional, it’s not ideal. I am looking to prevent the key from reverting back to zero upon shutdown or reboot. Perhaps Copilot can provide me with a batch file to achieve this, and instruct me to place it in User…ProgramsStartup, but this solution is also not optimal.

I am seeking guidance on how to configure gpedit, settings, or the registry to ensure that the value data for IsUserEligible remains at 1 and does not reset to zero.

Additionally, I would appreciate insights into the underlying cause of this issue and why the value keeps changing unexpectedly.

​This installation is fully compliant with 3155 Pro, however, the BingChat key value “IsUserEligible” keeps resetting to 0 every time the system is rebooted. To restore the taskbar icon option and enable Copilot in taskbar settings, I have to use a .reg file that I created by exporting the key. While this workaround is functional, it’s not ideal. I am looking to prevent the key from reverting back to zero upon shutdown or reboot. Perhaps Copilot can provide me with a batch file to achieve this, and instruct me to place it in User…ProgramsStartup, but this solution is also not optimal. I am seeking guidance on how to configure gpedit, settings, or the registry to ensure that the value data for IsUserEligible remains at 1 and does not reset to zero. Additionally, I would appreciate insights into the underlying cause of this issue and why the value keeps changing unexpectedly.  Read More

​

Hello,

I am currently experiencing a new issue with my taskbar. Whenever I open a File Explorer folder, the taskbar displays the folder name with “- File Explorer” appended to it. For example, instead of just showing “UD” and “Downloads,” it now shows “UD – File Explorer” and “Downloads – File Explorer.”

I would greatly appreciate any help with resolving this issue.

Thank you.

​Hello, I am currently experiencing a new issue with my taskbar. Whenever I open a File Explorer folder, the taskbar displays the folder name with “- File Explorer” appended to it. For example, instead of just showing “UD” and “Downloads,” it now shows “UD – File Explorer” and “Downloads – File Explorer.” I would greatly appreciate any help with resolving this issue.Thank you.  Read More

​

Restoring an MS SQL 2022 DB from a ANF SnapShot

PoC and Validation

Overview

Using Azure NetApp Files (ANF) with SAP systems offers several advantages that can significantly enhance performance, reliability, and manageability. Here are some key reasons:

High Availability and Reliability: ANF provides a highly available NFS/SMB file server with a Service Level Agreement (SLA) of 99.95%, which is usually much higher. This eliminates the need for creating a Linux pacemaker cluster on two Azure VMs, reducing costs and administrative overhead.

Cost Savings and Simplified Management: By using ANF, there is no need for additional VMs or operating systems, which translates to cost savings and less administration. Additionally, there is no need for complex configurations like DRBD block shipping between local VM disks, which reduces latency and further simplifies management.

Performance: ANF can deliver enterprise-level NFS/SMB performance required by SAP workload for database support, with sub-millisecond latency. It supports both SMB and NFS protocols, allowing for near-instantaneous snapshots and volume cloning.
Backup and Recovery: ANF offers robust backup solutions, including policy-based (scheduled) and manual (on-demand) backups. These backups are stored in Azure storage, independent of volume snapshots, providing long-term recovery, archive, and compliance capabilities.
Scalability and Flexibility: ANF allows for flexible volume assignment according to application needs and supports online volume resizing. This makes it easier to scale and adapt to changing requirements.
Simplified Deployment: ANF simplifies the deployment of SAP systems by providing a consolidated structure and design concepts for multiple SAP systems in one ANF volume. This includes optimal volume design for SAP HANA and considerations for backup and recovery.

These benefits make ANF a compelling choice for running SAP systems, offering a combination of high performance, reliability, cost savings, and simplified management.

This Document

This document describes a recovery procedure of a Microsoft SQL Server 2022 Database from a NetApp SnapShot. The principles and processes shown, are working on our Azure Large Instances or on Azure VMs with ANF infrastructure. There is no difference between both infrastructure variants.

We assume that enhanced Azure Large Instances, Azure VM, ANF and MS SQL knowledge is available because we start right away with the topic without any explanation of the underlying technologies.

For basic information please use our learning site where you can find anything you will need to understand this article Microsoft Learn: Build skills that open doors in your career.

Explaining MS SQL 2022 snapshot feature: Create a Transact-SQL snapshot backup – SQL Server | Microsoft Learn

Setup

We configured one Windows VM and installed MS SQL Server 2022 on it.  

We recommend splitting the Data and Log volumes from the Backup volume in different Azure Zones. 

This will be more optimal for data resiliency.

To scale the I/O throughput for larger systems, we configured multiple data volumes and data files. and separated the log file of the SQL Server database into a different volume as well. 

Database files:

\smb-5bd6.anfsmb.comSQ4Data1SQ4.mdf
\smb-5bd6.anfsmb.comSQ4Data1SQ4_2.ndf
\smb-5bd6.anfsmb.comSQ4Data2SQ4_3.ndf
\smb-5bd6.anfsmb.comSQ4Data2SQ4_4.ndf

Log files:

\smb-5bd6.anfsmb.comSQ4logSQ4_log.ldf
\smb-5bd6.anfsmb.comSQ4logSQ4_2_log.ldf

Backup Volume structure:

Here we recommend to create a directory for every DB like:

\SMB-ServerVolumeSID1
\SMB-ServerVolumeSID2

and so on…

In this directory now create three directories:

Backup –> here a “normal” SQL Full Backup can be stored

Metadata –> here the Metadata of the DB will be stored which we need for the SQL SnapShot procedure

T-Log : Here we will store our log backup files.

In our setup it looks like this:

\smb-c80b.anfsmb.comSQLBackupSQ4Backup
\smb-c80b.anfsmb.comSQLBackupSQ4Metadata
\smb-c80b.anfsmb.comSQLBackupSQ4T-Log

AzAcSnap

The Azure Application Consistent Snapshot tool (AzAcSnap) is a command-line tool that enables data protection for third-party databases. It handles all the orchestration required to put those databases into an application-consistent state before taking a storage snapshot. After the snapshot, the tool returns the databases to an operational state.

Before performing the installation, it is important to understand the functionality of an ANF snapshot and how it is working:

How Azure NetApp Files snapshots work | Microsoft Learn

So far AzAcSnap was “only” available for databases like SAP HANA, IBM DB2 and Oracle. Up to now we only supported Linux as an operating system for the snapshot backup scenarios.

With this blog we will show that AzAcSnap is also capable of creating application consistent snapshots for Microsoft SQL Server (version 2022 and newer) on the Windows operating system.

Setup and configuration of AzAcSnap on Windows.

Download the executable from https://aka.ms/azacsnap-windows and store it in a directory e.g.

C:Users<SID>admazacsnap

Create the metadata directory for AzAcSnap e.g.

\smb-c80b.anfsmb.comSQLBackupSQ4Metadata

Create either a managed identity or service principal authentication file for AzAcSnap to be able to access the ANF volumes. We highly recommend using managed Identity!

Look for a detailed description for “Enable Communication with Storage” in

Install the Azure Application Consistent Snapshot tool for Azure NetApp Files | Microsoft Learn

Configuration of AzAcSnap

Login as the domain user which has access to the SQL data base.

Create the config file for AzAcSnap

azacsnap.exe –configfile mssql.json -c configure –configuration new
…
..
.
Enter the database type to add, ‘hana’, ‘oracle’, ‘db2’, ‘mssql’, ‘exit’ (to abort without saving), ‘save’ (to save and exit)?
mssql
=== Add MS SQL Server details ===
What is the MS SQL Server ConnectionString?
Trusted_Connection=True;Persist Security Info=True;Data Source=anfsmbdb01;TrustServerCertificate=true
What is the MS SQL Server Instance (Database) Name?
SQ4
What is the MS SQL Server Backup Meta-Data File Location?
\smb-c80b.anfsmb.comSQLBackupSQ4Metadata
BEGIN : Database tests
PASSED: Successful connectivity to MSSQL version 16.00.4015
*** Connection to SQ4 successful. ***
=== Add Mssql Storage section ===
Do you want to add Mssql database Storage?
…
..
.

You need to snapshot SQ4data1, SQ4Data2 and SQ4log at the same time. All three volumes must be configured under the point data-volumes in the azacsnap config. The SQLBackup volume does not need to be snapshotted because only offline files are stored there. You can directly backup file from this volume, if you like.

After you created the mssql.json file and both tests (storage and Database) were successful you can create the first snapshot.

C:Userssq1admazacsnap>azacsnap.exe –configfile mssql.json –preview -c backup –volume data –prefix test –retention 2 –trace

Now we have created will see a new snapshot in each volume. The timestamp indicates that it is really created at the same time.

You can now schedule the snapshot creation via the Windows scheduler, Azure Power Automation, Azure Logic Apps or any 3rd party scheduling tool.

Log Backups

Depending on the desired RPO you can schedule the Log-Backups automatically from the database.

I assume the RPO is 10 minutes, this would require a log backup every 5 minutes.

Two prerequisites must be provided:

      1)   DB must be in FULL Recovery mode

You must have taken a FULL Backup in FULL Recovery mode.

To schedule a log backup every 5 minutes I recommend creating a small SQL script and schedule it via the MS Windows scheduler.

Step 1: (optional)

Create a backup user which is able to execute the backup script which we create in step 2.

CREATE LOGIN azacsnap WITH PASSWORD = ‘<your Password>’;
CREATE USER azacsnap FOR LOGIN azacsnap;
ALTER SERVER ROLE sysadmin ADD MEMBER azacsnap;

Verify that the user is created

USE SQ4;
SELECT name AS username, create_date, modify_date, type_desc AS type
FROM sys.database_principals
WHERE type NOT IN (‘A’, ‘G’, ‘R’, ‘X’) AND sid IS NOT NULL AND name != ‘guest’;

Sesult:

Step 2: Create a Backup Script

First, create a Transact-SQL script to back up the transaction log with a unique name that includes the date and time. Save this script as backup_log.sql:

SQL:

DECLARE @BackupFileName NVARCHAR(500)
SET @BackupFileName = ‘\smb-c80b.anfsmb.comSQLBackupSQ4T-Logt-log_’ +
                      CONVERT(VARCHAR(20), GETDATE(), 112) + ‘_’ +
                      REPLACE(CONVERT(VARCHAR(20), GETDATE(), 108), ‘:’, ”) + ‘.trn’
BACKUP LOG [SQ4]TO DISK = @BackupFileName
WITH NOFORMAT, NOINIT, NAME = ‘SQ4-Transaction Log Backup’

Step 3: Create a Batch File

Next, create a SQ4_T-Log_Backup .bat) to run the SQL script using sqlcmd. This script will store 100 logfiles in the logs directory of azacsnap.

@echo off
setlocal
:: Set the timestamp
set “timestamp=%date:~10,4%-%date:~4,2%-%date:~7,2%_%time:~0,2%-%time:~3,2%-%time:~6,2%”
set “timestamp=%timestamp: =0%”
cd C:Userssq1admazacsnap
:: Execute the SQL script and write to the log file
sqlcmd -S localhost -d SQ4 -U “azacsnap” -P “<your Password>” -i SQ4_T-Log-Backup.sql -o “logsSQ4_T-Log_Backup_%timestamp%.log”
:: Manage log files to keep only the latest 100
set “logdir=C:Userssq1admazacsnaplogs”
set “logcount=100”
for /f “skip=%logcount% delims=” %%F in (‘dir /b /o-d “%logdir%SQ4_T-Log_Backup_*.log”‘) do del “%logdir%%%F”
endlocal

Step 4: Schedule the Task

Use Windows Task Scheduler to run the batch file every 5 minutes:

Open Task Scheduler.
Click on Create Task.

Name your task and provide a description.

Select New Task and configure the required frequence. In my case 5 minutes.

Set the start time and select Repeat task every 5 minutes for a duration of 1 day.

Choose Start a program and click Next.

Browse to your batch file

Provide the credentials of your selected OS user

Click Finish to create the task.

DB Recovery

If you want or have to restore the database from a snapshot, we recommend the following steps:

Shutdown or kill the database
Drop the Database
Revert, or even better Clone, the snapshot you would like to use for the recovery
Use the Metadata file (belonging to the SnapShot you reverted) for the “RECOVER DATABASE” command. Important here is to start the recovery with NORECOVERY
Apply each T-Log file you need to Apply and still use NORECOVERY
If all T-Log files are applied, start the DB with the “WITH RECOVERY” option.

Needless to state that you should test and exercise the procedure of recovering from a snapshot backup on a regular basis to make sure that:

Changes in your environment did not make the documented or coded procedures obsolete
To make sure that operators are able to execute the procedure
To make sure that the restored database is consistent

Here the detailed commands for our setup:

Drop the DB:

USE master;
GO
ALTER DATABASE SQ4 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE SQ4;
GO

Use The Portal to revert ALL snapshots in our case:

SQ4DATA1
SQ4DATA2
SQ4Log

Logon to the master DB and use the Metadata file for the recovery

Important: Be sure to use the correct Metadata file.  This can be found by matching the Metadata file name with the snapshot name.  The Metadata file is generated by AzAcSnap during the snapshot backup and is called “MSSQL_BACKUP_<snapshot name>.bkm”.

RESTORE DATABASE SQ4 FROM DISK = ‘\smb-c80b.anfsmb.comSQLBackupSQ4MetadataMSSQL_BACKUP_test__FACFAFFDB2D.bkm’
WITH METADATA_ONLY,  NORECOVERY ;

Now Apply the logfiles

RESTORE LOG SQ4 FROM DISK = ‘\smb-c80b.anfsmb.comSQLBackupSQ4T-Log202408131716.trn’
WITH NORECOVERY;
RESTORE LOG SQ4 FROM DISK = ‘\smb-c80b.anfsmb.comSQLBackupSQ4T-Log202408131721.trn’
WITH NORECOVERY;
RESTORE LOG SQ4 FROM DISK = ‘\smb-c80b.anfsmb.comSQLBackupSQ4T-Log202408131735.trn’
WITH NORECOVERY;

Now open The Database

RESTORE DATABASE SQ4 WITH RECOVERY;

The best is to take fresh SnapShot or backup after the restore.

​Microsoft Tech Community – Latest Blogs –Read More 

Hello everyone,

I’ve been a user of Microsoft Action Pack for several years, and I usually renew my subscription online without any issues. However, this year, I’m encountering a frustrating problem. When trying to renew, the system blocks me from completing the purchase, saying I need administrator permission to proceed – even though I AM the administrator of my account.

I’ve been contacting Microsoft support for the past two weeks, but unfortunately, I haven’t received any helpful response or callback. Has anyone else experienced this issue, and if so, how did you resolve it?

Any advice or guidance would be greatly appreciated!

Thank you in advance.

​Hello everyone, I’ve been a user of Microsoft Action Pack for several years, and I usually renew my subscription online without any issues. However, this year, I’m encountering a frustrating problem. When trying to renew, the system blocks me from completing the purchase, saying I need administrator permission to proceed – even though I AM the administrator of my account.I’ve been contacting Microsoft support for the past two weeks, but unfortunately, I haven’t received any helpful response or callback. Has anyone else experienced this issue, and if so, how did you resolve it? Any advice or guidance would be greatly appreciated! Thank you in advance.  Read More

​