SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

dbthj
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?

tkizer
Almighty SQL Goddess

USA
36845 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:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51150

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Kristen
Test

United Kingdom
22403 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!

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.11 seconds. Powered By: Snitz Forums 2000