When running eTrack Console and performing a database backup errors can occur. eTrackConsole sends a command to the running SQL Server instance to perform the backup.
Sometimes errors can occur and the most common error is: Cannot open backup device ‘M:\E-Track\Backups\eTracketrack2013011401.bak’. Operating system error 3(error not found)
This error is a permissions error on the Windows Server running the SQL instance and needs to be corrected. The SQL Server Database runs as a specific user (Usually network/Service or System account on the server).
For console to be able to perform correct backups the path displayed in the error message must have read/write permissions for the Network/Service or System account.
It is possible to check which user SQL Server database runs as by doing the following on the server:
- Open Control Panel
- Open Administrative tools
- Double click services
- scroll to find: SQL Server (ETRACK)
- right click -> properties – check properties TAB to locate user service is running as.
Once permissions have been corrected the backup will operate normally.
Posted in: eTrack FAQ, Server and Databases
