Prev: Service Broker Check after Receive?
Next: Select only columns with contents
From: Van Den Steen Dany Van Den Steen on 30 Jun 2010 03:23
To detect if there is a valid Full backup exist, before starting a log backup
I check of the LastBackupDate is filled.
Sometime this give the following error.
Error.Message : BACKUP LOG cannot be performed because there is no current
database backup.
BACKUP LOG is terminating abnormally.
Error.Source : .Net SqlClient Data Provider
Error.StackTrace : at
Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction
action, Object execObject, DataSet fillDataSet, Boolean catchException)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
Error.TargetSite : System.Object ExecuteTSql(ExecuteTSqlAction,
System.Object, System.Data.DataSet, Boolean)

Is there another method to detect there is a valid Full backup
From: Van Den Steen Dany on 30 Jun 2010 17:13


"Van Den Steen Dany" wrote:

> To detect if there is a valid Full backup exist, before starting a log backup
> I check of the LastBackupDate is filled.
> Sometime this give the following error.
> Error.Message : BACKUP LOG cannot be performed because there is no current
> database backup.
> BACKUP LOG is terminating abnormally.
> Error.Source : .Net SqlClient Data Provider
> Error.StackTrace : at
> Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction
> action, Object execObject, DataSet fillDataSet, Boolean catchException)
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
> Error.TargetSite : System.Object ExecuteTSql(ExecuteTSqlAction,
> System.Object, System.Data.DataSet, Boolean)
>
> Is there another method to detect there is a valid Full backup

The backup program is written C# with the SMO library
 | 
Pages: 1
Prev: Service Broker Check after Receive?
Next: Select only columns with contents