Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting a back up
Message
De
23/01/2001 13:37:31
 
 
À
18/01/2001 10:06:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
00465121
Message ID:
00467470
Vues:
12
Did You try with "sp_delete_backuphistory" ???



Section from SQL SERVER Books Online:

sp_delete_backuphistory

Deletes the entries in the backup and restore history tables for backup sets older than oldest_date. Because additional rows are added to the backup and restore history tables when a backup or restore operation is performed, sp_delete_backuphistory can be used to reduce the size of the history tables in the msdb database.

Syntax
sp_delete_backuphistory [ @oldest_date = ] 'oldest_date'

Arguments
[@oldest_date =] 'oldest_date'

Is the oldest date retained in the backup and restore history tables. oldest_date is datetime, with no default.

Return Code Values
0 (success) or 1 (failure)

Result Sets
None

Remarks
sp_delete_backuphistory must be run from the msdb database.

Permissions
Execute permissions default to members of the sysadmin fixed server role, but can be granted to other users.

Examples
This example deletes all entries older than August 20, 1998, 12:00 A.M., in the backup and restore history tables.

USE msdb
EXEC sp_delete_backuphistory '08/20/98'


See Also

BACKUP

backupfile

backupmediafamily

backupmediaset

backupset

DUMP

LOAD

RESTORE

restorefile

restorehistory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform