Sql Backup And FTP

I've connected to the SQL Server & Database with no problem, the storage & email notification work great... However either using Run Now or by Schedule the job fails every time at the same place... Getting Database Information... I have pasted the log entry below... I'm using
Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600

Any ideas how to move this on...????



>>> run 26/02/2010 08:45:52 by DavidH

SqlBackupAndFtp 4.3.0.32657 (Free)

SUMMARY:
Database playdt40: Backup - Failure
Database tmandt40: Backup - Failure

DETAILED LOG:
26/02/2010 08:45:51 Creating backup of playdt40 to T:\ (using scripting)
26/02/2010 08:45:52 Creating playdt40001.sql
26/02/2010 08:45:52 Scripting database creation
26/02/2010 08:45:52 ERROR: Database scripting failed: An error occured while getting database information. >> System.Data.SqlClient.SqlException: Invalid object name 'sys.databases'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at c.w.j(Stream A_0)
26/02/2010 08:45:52 ERROR: Backup of playdt40 failed: Job failed
26/02/2010 08:45:52 ERROR: Job finished (With Errors)

On its way to you Alex :)

TTFN

DWH

I suggest you not to use the scripting feature. We can't handle all database confirurations and that's why we keep it in "permanent beta". Better install the program on the server and use a standard backup method.