none
TFS Daily scheduled Backup is failing RRS feed

  • Question

  • Hi,

    We have TFS2015.3. And we have scheduled DB backup in TFS using TFS admin console. But we are finding that TFS DB back up failing frequently with below error:

    Exception Message: Write on "\\XASDC\public\DASC\IT\BACKUPSQL\XXXXX1234\TFS\Tfs_CollectionA_9859957732898727191F.bak" failed: 1359(An internal error occurred.)
    BACKUP DATABASE is terminating abnormally. (type SqlException)
    SQL Exception Class: 16
    SQL Exception Number: 3202
    SQL Exception Procedure:
    SQL Exception Line Number: 1
    SQL Exception Server: XXXXX1234
    SQL Exception State: 1
    SQL Error(s):
    SQL Error[1]: System.Data.SqlClient.SqlError: BACKUP DATABASE is terminating abnormally.
        Class: 16
        Number: 3013
        Server: XXXXX1234
        Source: .Net SqlClient Data Provider
        State: 1
        Procedure:
        Line Number: 1

    Exception Data Dictionary:
    HelpLink.ProdName = Microsoft SQL Server
    HelpLink.EvtSrc = MSSQLServer
    HelpLink.EvtID = 3202
    HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
    HelpLink.LinkId = 20476

    Exception Stack Trace:    at Microsoft.VisualStudio.Services.Configuration.SqlDatabaseBackupRestoreComponent.Execute(String sqlStatement)
       at Microsoft.VisualStudio.Services.Configuration.SqlDatabaseBackup.Backup(ISqlConnectionInfo connectionInfo)
       at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeFullBackupOfSingleDatabase(IVssRequestContext requestContext, String dataSource, String databaseName, String fullFileName, ITFLogger logger)
       at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeFullBackups(IVssRequestContext requestContext, BackupSettings settings, List`1 databaseConnectionInfoList, ITFLogger logger)

    It is failing only for a particular Collection. We have 11 collections and Back-up is fine for 10 Collections. But for this particular collection the scheduled Back-up failed. On rerunning the Back-up job manually it succeeds. It failed twice in last 4 days.

    Kindly requesting your help to get the issue resolved.

    Regards,

    Chirag D S

    Friday, April 6, 2018 4:22 AM

All replies