full and diff backup

full and diff backup - sql2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

oto.pakozdy@gmail.com - 27 Nov 2007 15:06 GMT

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.

Reply to this Message

Jay - 27 Nov 2007 15:57 GMT

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 ...

> hello...
>
[quoted text clipped - 15 lines]
>
> Thanks for any help.

Reply to this Message

oto.pakozdy@gmail.com - 27 Nov 2007 16:19 GMT

> Well, try doing a manual full and see if it resolves.
>
[quoted text clipped - 27 lines]
>
> - Zobraziť citovaný text -

Now I altered db_backupoperator role for MSDB by user running backup
script. soi I will see if it help.

Reply to this Message

Tibor Karaszi - 27 Nov 2007 17:46 GMT

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...

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> hello...
>
[quoted text clipped - 15 lines]
>
> Thanks for any help.

Reply to this Message

Ben Nevarez - 27 Nov 2007 17:51 GMT

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

> hello...
>
[quoted text clipped - 15 lines]
>
> Thanks for any help.

Reply to this Message

oto.pakozdy@gmail.com - 28 Nov 2007 12:00 GMT

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.

Reply to this Message

Gil - 30 Nov 2007 13:33 GMT

Hello, I think i meet the same problem. but you said you have find the
resolution on google. Could you please give me the link that describe the
problem?

Thanks,
Gil

> I found solution on google
> Problem is MSSQL SP2 changed startup state SQL Server VSS Writer from
[quoted text clipped - 5 lines]
>
> Thank for your hints.

Reply to this Message