OS: Server 2008 R2 Standard with SP1 and all critical/security patches
User Account Control: Off
IE ESC: Off for all users
Database: MS SQL 2008 R2 Express
DB Auth: Mixed mode
SQLBackupAndFTP Account: Domain account in the local administrators group. This account is an admin in SQL as well.
We have configured the software and it appeared to be working correctly while someone was logged in, but with no one logged in the scheduled backups fail.
There are two events in the Windows Event Log. The first one is when the scheduled backup job starts:
Quote:Log Name: Application
Source: SBF Service
Date: 9/1/2011 8:43:02 AM
Event ID: 0
Task Category: None
Level: Information
Keywords: Classic
User: N/A
Computer: Servername.domain.com
Description:
Starting diff backup for C:\jobs\jobname.jobx using D:\Program Files (x86)\Pranas.NET\SQLBackupAndFTP\SQLBackupAndFTP.exe under domain\admin_account
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SBF Service" />
<EventID Qualifiers="0">0</EventID>
<Level>4</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-09-01T14:43:02.000000000Z" />
<EventRecordID>4736</EventRecordID>
<Channel>Application</Channel>
<Computer>Servername.domain.com</Computer>
<Security />
</System>
<EventData>
<Data>Starting diff backup for C:\jobs\jobname.jobx using D:\Program Files (x86)\Pranas.NET\SQLBackupAndFTP\SQLBackupAndFTP.exe under domain\admin_account</Data>
</EventData>
</Event>
The second one happens 1 second later.
Quote:Log Name: Application
Source: SBF Service
Date: 9/1/2011 8:43:03 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Servername.domain.com
Description:
GetTokenInformation: A specified logon session does not exist. It may already have been terminated.
(1312)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SBF Service" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-09-01T14:43:03.000000000Z" />
<EventRecordID>4737</EventRecordID>
<Channel>Application</Channel>
<Computer>Servername.domain.com</Computer>
<Security />
</System>
<EventData>
<Data>GetTokenInformation: A specified logon session does not exist. It may already have been terminated.
(1312)</Data>
</EventData>
</Event>
SQLBackupAndFTP log only shows successful jobs.
Please help...Thanks!