How to backup SCSM 2012 Service Manager Server and Data Warehouse

For those of you who use native backup or for those building the system I’ve put together a quick T-SQL file for backup up the databases:

For the SCSM Service Manager Server

USE ServiceManager GO BACKUP DATABASE ServiceManager TO DISK = ‘c:\backup\ServiceManager.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘ServiceManager Full Backup’; GO

For the data warehouse use:

USE CMDWDataMart GO BACKUP DATABASE CMDWDataMart TO DISK = ‘c:\backup\CMDWDataMart.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘CMDWDataMart Full Backup’; GO

USE DWDataMart GO BACKUP DATABASE DWDataMart TO DISK = ‘c:\backup\DWDataMart.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘DWDataMart Full Backup’; GO

USE DWRepository GO BACKUP DATABASE DWRepository TO DISK = ‘c:\backup\DWRepository.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘DWRepository Full Backup’; GO

USE DWStagingAndConfig GO BACKUP DATABASE DWStagingAndConfig TO DISK = ‘c:\backup\DWStagingAndConfig.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘DWStagingAndConfig Full Backup’; GO

USE OMDWDataMart GO BACKUP DATABASE OMDWDataMart TO DISK = ‘c:\backup\OMDWDataMart.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘OMDWDataMart Full Backup’; GO

USE ReportServer GO BACKUP DATABASE ReportServer TO DISK = ‘c:\backup\ReportServer.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘ReportServer Full Backup’; GO

USE ReportServerTempDB GO BACKUP DATABASE ReportServerTempDB TO DISK = ‘c:\backup\ReportServerTempDB.bak’ WITH FORMAT, MEDIANAME = ‘CSQLSERVERBACKUP’, NAME = ‘ReportServerTempDB Full Backup’; GO