Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Multiple Backup Schemes Bad???
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

143 Posts

Posted - 04/06/2007 :  14:24:59  Show Profile  Reply with Quote
Our network team backs up an entire server to a SAN or tape, including SQL databases (using SQL Server backups). That all works
pretty well. "just for good measure" We DBAs are working under the assumption that it is a good idea to take daily backups to disk with a maintenance plan. But I'm thinkin' - If both processes are backing up the log (and therefor truncating it), then neither process is getting a complete set of logs and NOBODY is going to be able to do a point-in-time recovery. Does that make sense?

Almighty SQL Goddess

38200 Posts

Posted - 04/06/2007 :  14:27:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
Have your network team immediately stop performing SQL backups. They are making it impossible to do a point in time recovery. The network team should only be copying your backup files to tape, they should not be performing SQL backups.

Check this out for why:

Tara Kizer
Go to Top of Page


United Kingdom
22859 Posts

Posted - 04/08/2007 :  02:48:48  Show Profile  Reply with Quote
We wrote a Stored Procedure that makes a backup. It makes it to a particular folder, with a particular filename-style, and records the fact in an "admin" table.

Whoever / Whatever makes a database backup uses this one stored procedure.

The Stored Procedure is used by any/all scheduled backup tasks, but also allows a developer, for example, to make a "just in case" backup before doing some task (they might want to make a full backup for faster recovery, or to reduce the size of subsequent DIFF backups after a big reorganisation, or just to make a TLog backup to make it easier to do a restore without having to work out the server-time-to-restore-to!)

IMHO that makes the chances of our disaster recovery plan being likely to work on any given day!

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000