How to Backup a SQL Server Database
This post contains a demo on how to backup a SQL Server Database and includes some information on the types of backups available in SQL Server.
How to Get Estimated Backup Restore Time in SQL Server
This post contains a script to get estimated completion times and process information for your currently running database backups & restores in SQL Server.
How to Get Last Backup Times for all Databases in SQL Server
This is a post on how to get the last backup dates and times for all databases on a SQL Server Instance.
Show Last Backup Times in SQL Server
If you’re running a SQL Server and you care about the data held in it, you should already be backing up the databases.
Backing up a SQL Server Database with Encryption
Backing up a SQL Server Database with Encryption is the secure way of performing your SQL Server backups. If you’re ever worried about the data within your databases, you may consider this option when performing database backups.
Backing up a SQL Server Certificate
It’s important to backup SQL Server Certificates, but only if you’re using them really. If for example, your SQL Server database backups are encrypted and you need to restore it on another server, then you will need both the certificate and private key that was used.
Backup & Restore (WITH FILE)
In this post I’m going to show what the WITH FILE = X option does when backing-up or restoring a SQL Server database.
Backing Up a SQL Server Database
Backing up a database is something I’ve always found easier done within a query window. There’s not much to it; BACKUP DATABASE [DATABASENAME] TO DISK = N'e:\directory\databasename_backupdate.bak'
