Dear Admin,
I am getting following error while taking remote
database backup .
>>> run 16/07/2012 09:24:27 by Any User
SQLBackupandFTP 7.2.4.15036 Free (started manually) at Test-PC (Microsoft Windows NT 6.1.7601 Service Pack 1) (.NET:
2.0.50727.5420, 3.0.30729.5420, 3.5.30729.5420, 4.0.30319)
SUMMARY:
Database SNDLITE_FBD: - Failed
DETAILED LOG:
16/07/2012 09:24:27 Creating backup of SNDLITE_FBD to C:\Windows\TEMP (using scripting)
16/07/2012 09:24:27 Creating SNDLITE_FBD001.sql
16/07/2012 09:24:27 Scripting database creation
16/07/2012 09:24:27 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.f(Stream A_0)
16/07/2012 09:24:27 ERROR: Job failed > An error occured while getting database information. > Invalid object name
'sys.databases'.
16/07/2012 09:24:27 ERROR: Job finished (With Errors)
Log file also attached
