Forums  »  adTempus  »  General  »  Nightly adTempus DB backup fails

Nightly adTempus DB backup fails

RZamora (1 post)
July 29, 2015 11:00 AM
Accepted Answer

We are running on Windows Server 2008 R2 Enterprise SP 1.

 The nightly backup starts up at the time specified in the Windows Registry, which was set to 2:00.  The job fails.  When I look in the Event Viewer the error: "BackupDiskFile::CreateMedia: Backup device 'C:\Program Files\Arcana Development\adTempus\Backup\adtempus_SWPDCENDWODB01.dat.bak' failed to create. Operating system error 5(Access is denied.)."

The adTempus service is logged in as "Local System".  The SQL Server (ADTEMPUS) service is logged in as "NT Service\MSSQL$ADTEMPUS".  The SQL Server Agent (ADTEMPUS) service is logged in as "Network Service".

The last two services do not have authority to write to the folders.  How can I grant them the authority?

Permalink
Bill Staff (599 posts)
July 29, 2015 02:35 PM
Accepted Answer
You need to grant permission to the "NT Service\MSSQL$ADTEMPUS" to be able to create files in the backup folder. The adTempus service account doesn't need permission, as the backup is done by SQL Server. See this article for more information.
Permalink

Replies are disabled for this topic.