Category Archives: Backup

Query To Find Backup Location In SQL Server

Akira March 2, 2023 No Comments

We use simple T-SQL commands to retrieve the PATH from our msdb backup records. T-SQL doesn’t seem to have a method to slice up a folder/file path and return the parent folders so we have to use CHRAINDEX, SUBSTRING and REVERSE to pull out the file name leaving just the… Read more »

Use Powershell To Backup SQL Database Remote

Akira November 5, 2020 No Comments

This is a Powershell script I’ve used for a few years that creates a dated folder and places a backup for a single database in it. This version uses the “Invoke-Sqlcmd” and you may need to install the module before using this script. Install-Module sqlserverGet-Command -ModuleName sqlserver You only need… Read more »