Monday , April 23 2018

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


Start Daily –


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


#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.


Example –


Good to know –

Get-SqlDatabase –ServerInstance servername


About Satheshwaran Manoharan

Satheshwaran Manoharan is an Microsoft Exchange Server MVP , Publisher of
Supporting/Deploying/Designing Microsoft Exchange for some years.
Extensive experience on Microsoft Technologies.

Check Also

Installation can’t proceed until all Exchange 2003 Servers are removed

Had to extend schema before installing Exchange 2016 on a Exchange 2010 Server environment. Eventually ...

Leave a Reply

Your email address will not be published.