#backup database

How to implement N2WS Veeam Cloud Protection Manager (CPM 2.3.0d)

N2WS is a leading provider of enterprise backup, recovery, and disaster recovery solutions for Amazon Elastic Compute Cloud (Amazon EC2), Amazon Relational Database Services (Amazon RDS), Amazon Redshift, Amazon Elastic File System (Amazon EFS), Amazon Simple Storage Service (S3), Amazon Aurora, and Amazon DynamoDB. Kindly refer to these related guides for more on other Veeam products. How to…

NeoFinder – Media Cataloger Software For Mac

NeoFinder for Mac rapidly works on your digital asset management software that creates catalogs of your entire hard disk and media library, and backup archive. It keeps track of your documents, photos, songs, movies, and folders wherever they are stored. Catalog everything – hard disks (internal, external, USB, FireWire, Thunderbolt), server disks, DVD-ROMs, CD-ROMs, iPods, Blu-ray, USB sticks,…

Faster Backups with SQL Server Backup Compression

Database compression is a feature that Microsoft introduced in SQL Server 2008, but many people still don’t understand or regularly use the feature. The power of this feature is to both speed up the backup process, and to save disk space. The speed benefit is a result of reduced disk activity as you stream the compressed backup file directly to disk. You can use all your available CPU cycles to…

wordpress free plugin

You can check the plugin out either https://backup-guard.com/products/backup-wordpress or https://wordpress.org/plugins/backup.

source

Importance of Performing DBCC CHECKDB

You absolutely need to be performing a DBCC CHECKDB on all of your databases on a regular schedule. This includes the system databases. One example is Model database corruption leading to a TempDB issue, because the TempDB is created using the Model Database.

In this article by Simon Liew we get a better understanding of the potential issues by example.

The scenario starts with a perfectly…

SQL Server Backup Format (BAK)

When using the standard backup utilities in SQL Server, the backup files will have the default BAK extension. Standard database backup files with the .bak extension contain data in the standard Microsoft Tape Format (MTF), which is used by  Microsoft itself as well as many backup tools created for the Windows platform. Many third-party backup products produce backups in this format as well.

Micr…

Ola Hallengren’s SQL Server Maintenance Solution

A few of the responsibilities of a SQL Server Database Administrator is monitoring performance managing database backups. Luckily Ola Hallengren has created a SQL Server Maintenance Solution, which is a great script for monitoring performance and backup jobs. 

Installing SQL Server Maintenance Solution from Ola Hallengren:

1. Visit Ola’s web site and read about his solution.

2. Download the…

Simple Database Backup Script

Simple script to create a backup of your SQL Server database:

DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- file date -- specify database backup directory SET @path = 'H:\Backup\' -- specify filename format SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)…