Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

A loggbackup file is not copied from $bkp in the Vista database to the place specified in the backup object.

Issue

A loggbackup file is not copied from $bkp in the Vista database to the place specified in the backup object.

Environment

Vista 5.1.5
Windows XP
SQL 2005 express

Cause

When the SQL server is finished with the backup it tells Vista, and Vista then copies the bkp file from $bkp in the Vista database to the place specified in the backup object in Vista.

In this case the SQL server succeeds with the backup but fails to put it in the history log called dbo.backupfile in the MSDB database. So Vista never gets the message that SQL is finished and doesn't move it to the right location.

Resolution

The dbo.backupfile table in the msdb database was corrupt and needed repair.
Contact PSS or have a SQL expert check the msdb database.

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
2 weeks ago
Updated by: