Browse by Tags

Site sponsored by:

The gold standard of SQL Server performance monitoring & diagnostics

RSS Feeds

backup » databases (RSS)

Backup Error

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

Posted to General DBA Questions (Forum) by eyeswideshut on 05-05-2008
Why Backup, Why Recovery? You need a good strategy to save your data!

The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on: Third-Party Tool Enhances SQL Server Backup and Recovery Microsoft SQL Server’s own backup and restore facilities are probably some of the most robust in the industry...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 03-12-2008
Re: Backup error

Say the problem is gone for now, what if it occurs again. So it is better to approach the vendor in any case for a bug fix release... help them by reporting the bug. Please post the thread in relevant section only, moved from General DBA section.

Posted to Third Party Tools (Forum) by satya on 11-03-2007
Backup Job

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

Posted to General DBA Questions (Forum) by eyeswideshut on 10-30-2007
Automation of Analysis Services database backup

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple, within SQL Server 2005 version you can schedule...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 09-26-2007
TSQL script for deleting backups older than 1 day

Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get you started in the right direction. You basically...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 09-10-2007
DB Restore takes longer

Hi There, I am restoring a production backup onto the test server and it takes about 55 min. to restore when it used to take only about 16min as of last week before i did the re-indexing on the production db. The backup size is about 16gb. Do you know what could be wrong? Thanks.

Posted to General DBA Questions (Forum) by Anoop on 08-09-2007