SQL Backup Notes

Backup permissions: http://sqlbak.com/blog/backup-permissions/

Query to use as admin if getting permission denied error after giving user db_backupoperator permission

USE [IMS]
GO
GRANT ALTER TO DATABASELOGIN
GO

Setting up recurring backups: https://msdn.microsoft.com/en-us/library/ms191002.aspx

Steps to get backup working on front_end (as of February 22, 2016):

1. Make folder C:\backup

2. Create user using SQLManagementStudio
   User: IMSBackup
   pw: backup

3. give new user these permissions:
   User mapping:
   db_backupoperator
   db_denydatawriter
   db_denydatareader
   Server roles: dbcreator

4. Edit BackupDatabase.php and RestoreDatabase.php
   Update the $server variable with your windows credentials

5. Ensure database recovery is set to simple Right click IMS folder -> properties -> options -> recovery model -> simple

   OR

   Run query: ALTER DATABASE IMS SET RECOVERY SIMPLE