How can we help you today? How can we help you today?

False database needs full backup...

Howdy -

Just wanted to pass along another false read.

Got a message that a databasse needs a full backup.
Checked the job, it has been running fine forever, runs early every morning.

I have screen shots of the history and the sql response screen zipped into a word document; don't see a way to upload it here though.
randyv
0

Comments

1 comment

Sort by
  • priyasinha
    Hi,

    SQL Response looks at backupset table in the msdb database for the backup history. If it doesn't get any record of the full backup for the database in the last seven days then it raises a recommendation. Can you please run the below query on your server and send me the result at priya.sinha@red-gate.com along with the screen shots of the history and the SQL Response screen? This will help us to analyze the problem.

    This is the query:

    SELECT b.name, a.type, max(a.backup_start_date) AS latest_backup FROM msdb..backupset AS a INNER JOIN sysdatabases AS b
    ON lower(b.name) = lower(a.database_name)
    GROUP BY b.name, a.type
    ORDER BY b.name, a.type;
    -- This query shows databasename, type of backup and date of the latest backup.



    Thanks.

    Regards,
    Priya
    priyasinha
    0

Add comment

Please sign in to leave a comment.