SQL Server Backup and Restore with Powershell

Check if your module installed on your system

List all databases

Backup-SQL database

Backup all databases for example

Get-ChildItem “SQLSERVER:\SQL\$SQLInstance\Databases” | Backup-SqlDatabase -BackupContainer G:\Foldername -CopyOnly

And be specific

--

--

--

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Move huge amount of files between different Google Drive accounts without re-uploading them.

Experimenting with Robots and Cloud IoT Core

Things a developer MUST DO

Docker —  The Most Loved Platform Every Developer Must Learn

Using Azure Functions with Python, a quick intro with a Blobtrigger

Install macOS 11 Big Sur -on a separate partition.

Making Zoom discussions matter

3 ways not to use Selenium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alim Dogan

Alim Dogan

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.

More from Medium

Containers everywhere: how to run Microsoft SQL Server, SQL tools and Azure Data Studio with…

Hosting Python package in Azure Devops

Cheat sheet — Running a MSSQL Server instance using Docker Desktop

Access ADLS G2 with Unix Filesystem Commands Part 1