Tarsus'tan sondakika haberlerinin cep telefonunuza bildirim olarak gönderilmesini ister misiniz?

:

:

:

veeam sql backup

Tarih: 15 Mart 2019 Cuma 13:02
veeam sql backup
Yazı Boyutu:
Metni küçült
Metni büyüt
Products, programs and pricing exclusively for Service Providers

At Veeam®, we value the relationship we have with our 20,000 cloud and managed service provider partners worldwide. That is why we are making it easier than ever for providers like you to offer Availability to your customers and make more margin on the data protection solutions you’ve come to trust. NEW for 2018, the Veeam Cloud & Service Provider (VCSP) program has introduced:

NEW solutions for physical, virtual and cloud-based workloads

Unique partner perks, like messaging and campaign materials written for selling services
Volume-based discounts of 15-45% of rental pricing plans

Going beyond cloud backup & DRaaS

You know Veeam as the leader in intelligent data management, but did you know that Veeam has equipped more than 3,000 providers with the means to build a cloud backup and Disaster Recovery as a Service (DRaaS) offering? Now, Veeam is breaking new ground by introducing technology to build lucrative Veeam-powered services for any app, any data, across any cloud.

CLOUD BACKUP AND DRAAS

Offer your customers a reliable, yet effective data protection solution that leverages a multi-tenant architecture to send applications and data off site and execute failover and failback for disaster recovery.

Top Veeam solutions to check out:

Offer fast, secure backup to the cloud with Veeam Cloud Connect Backup for Service Providers. 

Break into the high-demand Disaster Recovery as a Service (DRaaS) market with Veeam Cloud Connect Replication for Service Providers. 

IAAS AND SAAS DATA PROTECTION

Expand your services portfolio by offering high-demand managed backup services for customers of hyperscale public clouds and Software as a Service (SaaS). With Veeam, you’ll unlock new revenue potential by storing a copy of your customers’ cloud-based data anywhere, helping them maintain control with file and granular level recovery.

Top Veeam solutions to check out:

Protect any workload running in an Infrastructure as a Service (IaaS) offering with the Veeam Agents for Microsoft Windows and Linux. 
for an extended evaluation experience!
Offer value-added data protection services for Microsoft Office 365 customers with Veeam Backup for Microsoft Office 365. 
or an extended evaluation experience!

ROSS-CLOUD DATA PROTECTION

Whether you offer data protection services to your Infrastructure as a Service (IaaS) customers, or you want to offer cross-cloud data protection services, Veeam has the flexible solution to meet your deployment needs.

Top Veeam solutions to check out:

Capture demand for Amazon Web Services by offering data protection for your AWS environment with N2WS Cloud Protection Manager.

Protect your own hosted offering with Veeam Availability Suite™, the #1 data protection solution for VMware vSphere and Microsoft Hyper‑V. 

REMOTE MANAGED SERVICES

Increasingly customers are looking to get out of the business of backup. Managed service providers (MSPs) can leverage the reliability of Veeam technology, and powerful remote monitoring and management tools to deliver value-added data protection services for their customers.

Top Veeam solutions to check out:

Use the same tool you use to protect cloud-based workloads to protect physical servers and workstations running on premises with Veeam Agents for Microsoft Windows and Linux. Download a for an extended evaluation experience!
Leverage a purpose-built tool to deliver Veeam-powered remote managed services with Veeam Availability Console. 

Backing up and Restoring Microsoft SQL Server Databases

To protect a virtualized Microsoft SQL Server, you can configure a backup job that will create image-level VM backups and, in addition, copy database transaction logs. Image-level backups will capture the VM state at specific points in time.

Transaction logs will keep records of all transactions performed against protected databases since the moment of the last backup. If a Microsoft SQL Server VM fails, you can recover the VM from the necessary restore point and then apply transaction logs to get databases on the Microsoft SQL Server to the required state between backups.

To configure a backup job that copies transaction logs, you must create a regular backup job and specify advanced settings for transaction logs shipping. In these settings, you define:

How often you want to back up transaction logs
How transaction logs must be shipped to the destination
How long transaction logs must be retained
With these settings enabled, Veeam Backup & Replication actually creates two jobs linked with each other:

A regular backup job responsible for creating image-level backups
An auxiliary job responsible for shipping database transaction logs
The regular backup job runs by the defined job schedule. It creates image-level backups and saves them on the backup repository. After the image-level backup has been successfully created, Veeam Backup & Replication truncates transaction logs on the virtualized Microsoft SQL Server.

The auxiliary backup job runs continuously. The job copies transaction logs accumulated between VM restore points at scheduled intervals, for example, every 15 minutes. As a result, on the backup repository you will have a chain of restore points and a set of transaction logs that cover intervals between these restore points.

Veeam Backup & Replication ships transaction logs to the backup repository and saves them in files of VLB format next to VM image-level backups. To ship transaction logs from the virtualized Microsoft SQL Server to the backup repository, Veeam Backup & Replication uses log shipping servers — Microsoft Windows machines added to the backup infrastructure. You can select explicitly what log shipping servers you want to use, or let Veeam Backup & Replication assign log shipping servers automatically.

For restore operations, Veeam Backup & Replication offers a special tool — Veeam Explorer for Microsoft SQL Server. Veeam Explorer for Microsoft SQL Server is integrated with Veeam Backup & Replication. The explorer is installed automatically when you deploy Veeam Backup & Replication.

Veeam Explorer for Microsoft SQL Server supports a number of restore scenarios:

You can restore a database to a specific point in time or to a specific transaction.
You can restore a database to a specific point in time or transaction and export it to the necessary location.

Evaluation Case

In this exercise, you will back up a Microsoft SQL VM and restore a database on the Microsoft SQL Server to a specific transaction using the created backup. To do this, you will perform the following actions:

Configure a backup job that will create a Microsoft SQL VM backup and copy transaction logs.
Use the created VM image-level backup and transaction logs to recover a database on the Microsoft SQL Server to a specific transaction with Veeam Explorer for Microsoft SQL Server.
It is strongly recommended that you use a non-production Microsoft SQL Server with a sample database for this exercise.

Prerequisites

Make sure that the Full or Bulk-logged recovery model is enabled for the database on the Microsoft SQL Server that you plan to back up. If the recovery model is set to Simple, Veeam Backup & Replication will not detect and process transaction logs.

Procedure

Step 1. Configure the backup job for a Microsoft SQL VM

In Veeam Backup & Replication, configure a backup job that processes a Microsoft SQL Server VM.
For details, see the Performing Backup exercise.

At the Guest Processing step of the New Backup Job wizard, select the Enable application-aware processing check box. In the Guest OS credentials section, specify a user account to connect to the VM guest OS. The user account must have the sysadmin privileges on the Microsoft SQL Server. In the opposite case, Veeam Explorer for Microsoft SQL Server will fail to automatically identify Microsoft SQL databases in the created VM backup.

Click Applications.
Select the Microsoft SQL Server VM in the list and click Edit.
In the Transaction logs section, make sure that the Process transaction logs with this job option is selected.
Backing up and Restoring Microsoft SQL Server Databases

Open the SQL tab.
Select the Backup logs periodically option.
In the Backup logs every <N> minutes field, specify how often you want to ship transaction logs from the Microsoft SQL Server VM to the backup repository. By default, Veeam Backup & Replication ships transaction logs every 15 minutes.

In the Retain log backups section, specify the retention policy for transaction logs. You can store them for a specific number of days or until a preceding image-level backup is removed from the backup chain.

In the Log shipping servers section, leave the Automatic selection option selected. Veeam Backup & Replication will automatically identify the least loaded Microsoft Windows server in your backup infrastructure and use this server to ship transaction logs to the backup repository.

Backing up and Restoring Microsoft SQL Server Databases

At the Schedule step of the wizard, define scheduling settings for the job. If you do not specify that the job must run automatically by the defined schedule, the backup job will be unable to ship transaction logs to the backup repository.

Finish working with the wizard and run the job to produce an image-level backup of the Microsoft SQL Server VM.

When you create a backup job that processes a Microsoft SQL Server VM and enable transaction log shipping, Veeam Backup & Replication creates two jobs: one processing the Microsoft SQL Server VM and the other one shipping transaction logs. In the inventory pane of the Home view, expand the Last 24 hours node to see the created jobs.

View Backup Job Statistics

After the image-level backup has been created, perform some transaction on the database on the Microsoft SQL Server VM that you have backed up. For example, if you use a test database, you can manually run a simple Microsoft SQL script to insert a record into the database or drop a record.

Wait for the period of time that you have defined in the Backup logs every <N> minutes field. After this period has expired, Veeam Backup & Replication will ship transaction logs and store them in a file of VLB format on the target backup repository, next to the image-level backup of the Microsoft SQL Server VM.

Check Backup Files

Step 2. Recover a database to a specific transaction

Open the Home view.
In the inventory pane, click the Backups node.
In the working area, expand the backup job processing the Microsoft SQL Server VM, right-click the Microsoft SQL Server VM and select Restore application items > Microsoft SQL Server databases.
Launch Application Item Recovery

Pass through the steps of the Microsoft SQL Server Database Restore wizard: select a restore point and specify a restore reason. At the last step of the wizard, click Finish to start the recovery process. Veeam Backup & Replication will automatically mount the Microsoft SQL Server VM file system to the Veeam backup server, locate the Microsoft SQL database and attach it to a staging Microsoft SQL Server — Microsoft SQL Server on which the Veeam Backup & Replication database is deployed. After that, Veeam Backup & Replication will automatically open the database in Veeam Explorer for Microsoft SQL Server.

In the left pane of Veeam Explorer for Microsoft SQL Server, right-click the necessary database and select Restore point-in-time state to <Microsoft SQL Server\Instance Name>.
Choose Restore Option

Veeam Backup & Replication will launch the Restore wizard. At the Specify restore point step of the wizard, select Restore to a specific point in time. Use the slider below to define the exact point in time to which you want to restore the database.
Select the Perform restore to the specific transaction check box and click Next.
Backing up and Restoring Microsoft SQL Server Databases

At the Fine-tune the restore point step of the wizard, select a transaction to which you want to restore the database and click Restore.
Veeam Backup & Replication will start restoring database to the selected transaction. When the restore process is complete, Veeam Explorer for Microsoft SQL Server will display a popup message to notify you of the restore operation results.
Validation

Check the state of the restored database on the Microsoft SQL Server VM and make sure it has been restored to the necessary state.
Etiketler:
UYARI: Küfür, hakaret, rencide edici cümleler veya imalar, inançlara saldırı içeren, imla kuralları ile yazılmamış,
Türkçe karakter kullanılmayan ve büyük harflerle yazılmış yorumlar onaylanmamaktadır.
Henüz yorum eklenmemiştir.

Tarsus Haber ©2003 - Tüm Hakları Saklıdır, Kaynak Gösterilmeden İçerik kopyalanamaz.
Mersin Haber
Oluşturma süresi(ms): -1