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.

Script: Map Orphan Login and Users

Map the Orphan Login and Users.

Setting SQL Server Default Locations

How to set the default locations for backups, data files, and log files in SQL Server.