Skip to content

Instantly share code, notes, and snippets.

@phaniav

phaniav/Sitecore Database Backup script.sql

Created November 21, 2017 11:13
Show Gist options
  • Save phaniav/14a5b755d3d24c12aad0b21c9d3ebd5e to your computer and use it in GitHub Desktop.
Save phaniav/14a5b755d3d24c12aad0b21c9d3ebd5e to your computer and use it in GitHub Desktop.
Download ZIP
Script to take Sitecore database backups
Raw
Sitecore Database Backup script.sql
BACKUP DATABASE [sc821Sitecore_core]
TO DISK = N'E:\SitecoreInstances\sc821\821db\sc821Sitecore_core'
WITH NOFORMAT, NOINIT,
NAME = N'sc821Sitecore_core-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [sc821Sitecore_master]
TO DISK = N'E:\SitecoreInstances\sc821\821db\sc821Sitecore_master'
WITH NOFORMAT, NOINIT,
NAME = N'sc821Sitecore_master-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [sc821Sitecore_web]
TO DISK = N'E:\SitecoreInstances\sc821\821db\sc821Sitecore_web'
WITH NOFORMAT, NOINIT,
NAME = N'sc821Sitecore_web-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [sc821Sitecore_reporting]
TO DISK = N'E:\SitecoreInstances\sc821\821db\sc821Sitecore_reporting'
WITH NOFORMAT, NOINIT,
NAME = N'sc821Sitecore_reporting-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment