|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
full and diff backup - sql2005I've got problem with backups on sql2005 script make backup at saturday with full backup and at monday script runs diff backup. On one of few sqlservers2005 diff backups doesn't run because because error: "a current database backup does not exist" . But I know full backup was executed corectly on saturday. In backup file , that is used for diff backup exists record for saturday's full backup. But server can't recognize full backup for db. When I run full backup again, it run sucessfully and diff backup too. This error is only on one server (named instance), other servers are ok. Any hints for this mystery ? Thanks for any help. Well, try doing a manual full and see if it resolves.
I'm not sure if the backup is looking at logs in msdb, or if it writes a flag, but a manual full will deal with both. In short, I wouldn't put too much energy into it, unless the simple solution doesn't work ... <oto.pako***@gmail.com> wrote in message Show quote news:2398bfcd-fa45-4a4f-ade4-915159aebbea@d21g2000prf.googlegroups.com... > hello... > > I've got problem with backups on sql2005 > script make backup at saturday with full backup and at monday script > runs diff backup. On one of few sqlservers2005 diff backups doesn't > run because because error: "a current database backup does not > exist" . But I know full backup was executed corectly on saturday. > In backup file , that is used for diff backup exists record for > saturday's full backup. But server can't recognize full backup for > db. > When I run full backup again, it run sucessfully and diff backup > too. > > This error is only on one server (named instance), other servers are > ok. > > Any hints for this mystery ? > > Thanks for any help.
Show quote
On 27. Nov, 16:57 h., "Jay" <s...@nospam.org> wrote: Now I altered db_backupoperator role for MSDB by user running backup> Well, try doing a manual full and see if it resolves. > > I'm not sure if the backup is looking at logs in msdb, or if it writes a > flag, but a manual full will deal with both. In short, I wouldn't put too > much energy into it, unless the simple solution doesn't work ... > > <oto.pako***@gmail.com> wrote in message > > news:2398bfcd-fa45-4a4f-ade4-915159aebbea@d21g2000prf.googlegroups.com... > > > > > hello... > > > I've got problem with backups on sql2005 > > script make backup at saturday with full backup and at monday script > > runs diff backup. On one of few sqlservers2005 diff backups doesn't > > run because because error: "a current database backup does not > > exist" . But I know full backup was executed corectly on saturday. > > In backup file , that is used for diff backup exists record for > > saturday's full backup. But server can't recognize full backup for > > db. > > When I run full backup again, it run sucessfully and diff backup > > too. > > > This error is only on one server (named instance), other servers are > > ok. > > > Any hints for this mystery ? > > > Thanks for any help.- Skry» citovaný text - > > - Zobrazi» citovaný text - script. soi I will see if it help. Perhaps you do some type of snapshot backup on the machine and this interferes in some way with the
diff backups? Consider disabling the SQL Server VSS writer service in that case. Just a thought... -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi <oto.pako***@gmail.com> wrote in message news:2398bfcd-fa45-4a4f-ade4-915159aebbea@d21g2000prf.googlegroups.com... > hello... > > I've got problem with backups on sql2005 > script make backup at saturday with full backup and at monday script > runs diff backup. On one of few sqlservers2005 diff backups doesn't > run because because error: "a current database backup does not > exist" . But I know full backup was executed corectly on saturday. > In backup file , that is used for diff backup exists record for > saturday's full backup. But server can't recognize full backup for > db. > When I run full backup again, it run sucessfully and diff backup > too. > > This error is only on one server (named instance), other servers are > ok. > > Any hints for this mystery ? > > Thanks for any help. I usually run this to get the history of backups for a specific database.
Try it and see what information it returns. Chage database name and pay atention to the type column. select backup_set_id, bs.media_set_id, database_creation_date, backup_start_date, backup_finish_date, type, database_name, physical_device_name from backupset bs join backupmediafamily bmf on bs.media_set_id = bmf.media_set_id where database_name = 'your_db' -- and type <> 'L' order by backup_start_date desc Hope this helps, Ben Nevarez Senior Database Administrator AIG SunAmerica Show quote "oto.pako***@gmail.com" wrote: > hello... > > I've got problem with backups on sql2005 > script make backup at saturday with full backup and at monday script > runs diff backup. On one of few sqlservers2005 diff backups doesn't > run because because error: "a current database backup does not > exist" . But I know full backup was executed corectly on saturday. > In backup file , that is used for diff backup exists record for > saturday's full backup. But server can't recognize full backup for > db. > When I run full backup again, it run sucessfully and diff backup > too. > > This error is only on one server (named instance), other servers are > ok. > > Any hints for this mystery ? > > Thanks for any help. > I found solution on google
Problem is MSSQL SP2 changed startup state SQL Server VSS Writer from manual to started . So when NTbackup run backup it breaks backup chain because vss make own db backups. So when I turn off SQL VSS Writer everyting works fine. ntbackup backup files without backuping db and sql backup chain full,diff is not break. Thank for your hints.  |
|||||||||||||||||||||||
Other interesting topics