SQL Server Backup Articles

New Database Backup Options in SQL Server 2014

Backup options are changing with every release of SQL Server. With SQL Server 2014, several important backup features have beenintroduced. First, the options are divided into two options called Media, Backup. General Under General, there is a new media type called URL. This option is to store the backup directly to cloud services. After providing […]

Report SQL Server Percentage Backup Completion and Time Completion

When executing a backup from a t-sql command, it is difficult to know what percentage has completed and when the backup will be complete. When you are taking a backup, you can specified STATS = 10 like following. BACKUP DATABASE [AdventureWorks2012] TO DISK = N’D:\MYBackup\AdventureWorks2012.bak’ WITH NOFORMAT, NOINIT, NAME = N’AdventureWorks2012-Full Database Backup’, SKIP, NOREWIND, […]

Backup and Restore of an Analysis Services Database

Introduction One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user […]

SQL Server 2014: Encryption for Backups

The next version of Microsoft’s main stream relational database management system (RDBMS), SQL Server 2014, has the ability to encrypt data in the database while a backup is created. The pleasant surprise is that this encryption feature for native database backups is available in Standard, Enterprise, and Business Intelligence editions of SQL Server 2014. Moreover, […]

Backing Up a SQL Server Database Directly Onto a Remote Server

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy and then on the staging server […]

Restoring a SQL Server Database – A Practical Example

Performing a Database Restore is a part of a DBA’s daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc. Many times it can be difficult to perform a Restore due to corrupted media, low disk space on the server and […]

Enhanced Features in Database Restore in SQL Server 2012

Point of time Recovery In a typical production environment, in order to recover data in the even of disaster, most DBAs will schedule a robust backup plan. Since scheduling a full back-up during peak times will have an impact on database performance, most DBAs will have combination of full, differential and log backup in the […]

SQL Server Log Shipping For Large Databases

Scenario:  A couple of days back I was setting up a DR plan for one of our most mission critical DB servers which was hosting around 10 databases having size of 10, 23, 5, 7.4, 1.8, 6.2, 7.9, 5.53, 8.7 and 125 GB respectively. I decided to implement Log Shipping as a part of the […]

Installing Windows Server Backup

Despite Windows Server Backup being listed in Administrative Tools, the Windows Server Backup feature will still need to be installed, this article demonstrates how.

Automate Generate Scripts in SSMS

The SSMS allows you to manually generate scripts for a database by right-clicking a database and selected Generate Scripts and selecting what elements you wish to be scripted. However, suppose you do wish do manually perform this task, how can it be automated? Actually there is no way to automate it from SSMS, currently the […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |