Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-13 : 09:49:37
|
| Carlos writes "I can´t finish a backup because there is a constraint violation PK duplicated in history backup table, I would like to know how solve this problem and how set the history backup id to zero (0).Thanks." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-13 : 10:01:23
|
| You could try to delete all the backup history and start fresh. Take a look at sp_delete_backuphistory stored procedure in msdb database...Backup id will not be set to 0, but at least it might help you get around the PK violation problems. Edited by - izaltsman on 12/13/2001 10:02:58 |
 |
|
|
|
|
|
backup history