Advanced Retail (UK) Ltd
Company Wiki

Backup Databases

EXEC [priarch].[dbo].[traxs_backup_rebuild]

Restoring databases

RESTORE DATABASE polling
FROM DISK = 'C:\DB_BACKUP\polling_full.bak'
WITH MOVE 'polling_data' TO 'C:\SQLSERVER\polling_data.mdf', 
MOVE 'polling_log' TO 'C:\SQLSERVER\polling_log.ldf'

RESTORE DATABASE priarch
FROM DISK = 'C:\DB_BACKUP\priarch_full.bak'
WITH MOVE 'priarch_data' TO 'C:\SQLSERVER\priarch_data.mdf', 
MOVE 'priarch_log' TO 'C:\SQLSERVER\priarch_log.ldf'

RESTORE DATABASE priarch_pos
FROM DISK = 'C:\DB_BACKUP\priarch_pos_full.bak'
WITH MOVE 'priarch_pos_data' TO 'C:\SQLSERVER\priarch_pos_data.mdf', 
MOVE 'priarch_pos_log' TO 'C:\SQLSERVER\priarch_pos_log.ldf'
RESTORE DATABASE stocktake
FROM DISK = 'C:\DB_BACKUP\stocktake_full.bak'
WITH MOVE 'stocktake_data' TO 'C:\SQLSERVER\stocktake_data.mdf', 
MOVE 'stocktake_log' TO 'C:\SQLSERVER\stocktake_log.ldf'

RESTORE DATABASE workdb
FROM DISK = 'C:\DB_BACKUP\workdb_full.bak'
WITH MOVE 'workdb_data' TO 'C:\SQLSERVER\workdb_data.mdf', 
MOVE 'workdb_log' TO 'C:\SQLSERVER\workdb_log.ldf'

RESTORE DATABASE traxs_temp
FROM DISK = 'C:\DB_BACKUP\TRAXS_TEMP_full.bak'
WITH MOVE 'traxs_temp_data' TO 'C:\SQLSERVER\traxs_temp_data.mdf', 
MOVE 'traxs_temp_log' TO 'C:\SQLSERVER\traxs_temp_log.ldf'

RESTORE DATABASE ART_TRAXS_HHT
FROM DISK = 'C:\DB_BACKUP\ART_TRAXS_HHT_full.bak'
WITH MOVE 'ART_TRAXS_HHT_data' TO 'C:\SQLSERVER\ART_TRAXS_HHT.mdf',
MOVE 'ART_TRAXS_HHT_log' TO 'C:\SQLSERVER\ART_TRAXS_HHT_Log.ldf'