Friday , August 7 2020

SQL 2014/2016 Express Daily Full Backup using PowerShell

As SQL Server Agent doesn’t function on SQL 2014 Express. We have to use scripts to do daily backup.

But Powershell SQLPS module can make things more easy for Admins.

  • DailySQLDatabaseBackup

Create a Scheduled Task in Windows Server 2012 R2

Note: Using Windows Task Scheduler to Run Power shell Scripts

image

Start Daily –

image

  • Program – PowerShell
  • Add Arguments – C:\Scripts\Sql2014Express.ps1

image


#SQL Full Backup Powershell Script

Import-Module sqlps
$Date = (Get-Date -format "MM-dd-yyyy")
$location = "C:\DatabaseBackup\DBName($date).bak"
Backup-SqlDatabase -ServerInstance Servername -Database DBName -BackupFile $location

NOTE : Please Update —
DBNAME on Line 3,line 4
ServerName on Line 4

Example – Save to PS1 and it should create new full backups in this folder without appending or overwriting.

image

Example –

image

Good to know –

Get-SqlDatabase –ServerInstance servername

image

About Satheshwaran Manoharan

Satheshwaran Manoharan is an Microsoft Office Server and Services MVP , Publisher of Azure365pro.com. Specialized in Office365 / Microsoft Exchange / Virtualization , Sathesh is an Messaging Expert supporting/Designing/Deploying many medium size businesses to large enterprises when it comes to Corporate messaging and Virtualization Infrastructure

Check Also

Migration Endpoint Fails with Connection Exception

Solution –  Make sure Outlook Anywhere succeeds with test account. Make sure you enter the …

Leave a Reply

Your email address will not be published.