Has anyone tried restoring Epicor’s training database with a copy from the production database? Below is the sql agent job and was wondering if we can take a production backup to do the restore.
USE [master]
RESTORE DATABASE [EpicorVanilla905]
FROM DISK = N’E:\Backups\Vanilla.bak’ WITH FILE = 1,
MOVE N’Epicor905’ TO N’E:\MSSQL\DATA\EpicorVanilla905.mdf’,
MOVE N’Epicor905_log’ TO N’E:\MSSQL\LOGS\EpicorVanilla905.ldf’, NOUNLOAD, REPLACE, STATS = 5
GO
you can restore any DB to your heart’s content… there is nothing specific about the Training DB it is just another DB slot
Of course, if you overwrite the training database the menu structure, parts, etc. will not match the training exercises any more, which is the point of the training database. Remember to change your scheduled tasks and port configurations as well, of course.
Also a good idea to change the company name from Your Name to Your Name (Trainng Copy) this way and reports that run you can identify they came from the Training Database and not confuse them with the live database reports.