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, I've been noticing that while taking a snapshot backup in MSSQL 2000 the time taken to backup the database completes in around 10-12 minutes for a approx. 16GB DB but still time notified in comepleting the job in job history is around 40 minutes. This is happening not daily but once or, twice...