Mask PII data (Personally Identifiable Information)

When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.

Restoring after TRUNCATE TABLE

Default Backup Directory

Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:

Point-in-time restore

Dynamically Script Database Backups

Dynanically Generate Backups with Date and time

Backup and Housekeeping with Maintenance Plans

Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.

Create SQL JOB to backup database and schedule it

This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.

T-Log Backup/Restore with Date & Time

Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.