Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Manual backup succeeds. Scheduled backup fails. Options · View
cboyd0319
#1 Posted : Thursday, September 01, 2011 10:06:36 AM Quote
Rank: Newbie

Groups: Registered

Joined: 9/1/2011
Posts: 3
Location: Chicago
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!
mikeshilov
#2 Posted : Thursday, September 01, 2011 1:33:15 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Thank you for reporting this, it may shed some light on the problem, let us test it on our side.
pbaker
#3 Posted : Tuesday, September 06, 2011 1:52:44 PM Quote
Rank: Newbie

Groups: Registered

Joined: 9/6/2011
Posts: 1
Location: Texas
Any update on this?
mikeshilov
#4 Posted : Thursday, September 08, 2011 2:17:36 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
This problem is fixed in 6.1.7. Please check.
cboyd0319
#5 Posted : Tuesday, September 13, 2011 10:49:40 AM Quote
Rank: Newbie

Groups: Registered

Joined: 9/1/2011
Posts: 3
Location: Chicago
Version 6.1.7 looks like it fixed the issue. We will run a few more tests, but it looks good so far.

Thanks!
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.