Good information. If you have specified dates time of the backups, it would have been easier to explain. Don't panic. Check whether you have all the backups in hand. Also test whether they are in a good condition. Send a mail to all stakeholders that the database server will be down for some time...

All, I do not like using the native sql server 2005 maintenance plans but rather script out tasks to perform maintenance. I do the following... Backup databases nightly (full) using Redgate. 15 minute t-log backups using Redgate. Defrag any index greater than 30% fragmentation rate every night (the logs...

i have 2 SQL servers (Development & Production) both have the same scheduled backup job (contains 35 databases). However, on the development server after the job finish i find that there are 2 databases failed to backup and the following error message is there: Executed as user: NT AUTHORITY\SYSTEM...

BACKUP DATABASE ... TO DISK='myserver\myshare\...' One thing to remember is that the account SQL Server and Agent runs under should (or must?!?) be a user account, not the system account and this account needs read and write permission.