I always say take a backup before a big change, and many readers ask how. This SQL in Sixty Seconds video shows how to take a database backup using SSMS.
SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions
Three questions I get all the time: where to get AdventureWorks, restoring a 64-bit backup on a 32-bit server, and restoring a 2012 database to 2008 or 2005.
.png)
SQL SERVER – Select the Most Optimal Backup Methods for Server
How to pick the optimal backup methods for your server: know the major backup types, choose a recovery model first and decide how much data you can lose.
SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3
SQLBackupAndFTP is the first tool I install on a SQL server. It schedules, compresses and encrypts backups and sends them to FTP, Dropbox, Google Drive or Amazon S3.
Restoring a TDE Protected Database on Another Server
Restore a TDE protected database on another SQL Server by moving its certificate and private key, then verify encryption state.
Ordering a Maintenance Window: Backups, CHECKDB and Index Work
Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.
SQL SERVER – Move Database Files MDF and LDF to Another Location
Your new database sits in the default location and keeps growing. Here is how to move the MDF and LDF database files to another disk or drive.