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

Hi, We are running SQL Server 2000 SP3, I am receiving an error message in the sql log: BACKUP failed to complete the command backup database to VIRTUAL_DEVICE='VNBU0-3040-3984' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1. Now, the odd thing about this is that the database...

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

Hi Akhtar, Their are some third party tool which you can use to compress and encrypt your database backup files, also you can password protect your backup files. Apart from this what you can do is, always keep your db backup files in protected folder and maintain proper authentication so that only those...

SQL 2005 SP1 Management Studio 9.00.1399.00 OS is Windows Server Enterprise SP2 running on a 32 bit machine. When SQL 2005 was installed a few months ago, it was installed on C:\Pgrm Files. I have another much larger drive (D) that I store the databases on as well as the backups. We had a contractor...

Hi All, I am trying to take a database backup from a sql server which is on 'x' domain and trying to store it on 'y' domain and I get the below error. -------------------------------------------------------------------------------------------------------------------- Server: Msg 3201...

Hi, you may schedule the job as Martin suggested, i.e. schedule a job which take full backup on 1st of every month;

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.

Hello Everybody, I am working with SQL 2000, and I have scheduled a job to backup some databases at night (Let's say about 10 databases), but when I checked the final report, it showed me that there is one of the databases failed to backup, and it gave me the following message: Executed as user:...