Restores

Backup and Recovery

Backup and Truncate Transaction Logs

Save the transaction log and truncate the file to prevent Tlogs FULL Error

SQL Server 2008 Recovery Models and Backups

This article examines the Recovery Model options used by SQL Server 2008 and the various methods that can be used to backup a database such as Differential and Transaction Logging. In addition, Transaction Logs, the mechanism that makes Recovery Models possible will be introduced.

Generate CREATE DATABASE FOR ATTACH for all databases on server

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.

Restore Transaction Logs for Point in Time Recovery

This article shows how a database can be restored to achieve point in time recovery

Using the FORFILES Command to Delete SQL Server Backups

Is there a way I can automate a file deletion process from within SQL Server?

Auto generate restore scripts after each backup completes

There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database?

SQL – Backup Methods, Some Cool Scripts

This article will tell you about some ways of taking all databases backup using one single command.

Database Recovery Models in SQL Server

This article discusses in detail the three database recovery models and how to choose the appropriate recovery model