Backup Standards and Suggestions

Thanks Ekrem.
In your opinion which one is better, using backup to disk? Or directly to
tape; considering I can get tape drive hooked directly to SQL Server.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
It depends on the scenarios. You can see some scenarios from the following
articles.
Some of them:
http://www.smallbusinesscomputing.com/testdrive/article.php/3528326
http://www.storagesearch.com/engenio-art2.html
Ekrem ?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:79E1C65C-5732-4957-B18B-14B765A9D558@.microsoft.com...
> Thanks Ekrem.
> In your opinion which one is better, using backup to disk? Or directly to
> tape; considering I can get tape drive hooked directly to SQL Server.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
|||Thanks! Those are good links, now I can backup some of what I say to
management ;-). Thanks again.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
|||I'm glad they helped, good luck! =)
Ekrem ?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:59BFA06B-DCAE-4840-8CBF-2C36A946D056@.microsoft.com...
> Thanks! Those are good links, now I can backup some of what I say to
> management ;-). Thanks again.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
sql

Backup opinion

What do you think this sort of backup?
Sunday - Full Database backup
Monday to Saturday - Differential Log backupOn Wed, 19 Sep 2007 11:35:24 +1000, "Alan T"
<alanNOSPAMpltse@.yahoo.com.au> wrote:
>What do you think this sort of backup?
>Sunday - Full Database backup
>Monday to Saturday - Differential Log backup
If that is the entire backup strategy I think it is very poor, as
there are no regular transaction log backups. A differential backup
is just a shortcut to a full database backup, and can only restore to
the moment that the backup was taken. Log backups allow point in time
recovery. Can you really afford to loose a day's work? Unless the
data is not important enough to protect you want log backups.
Also consider that you want backups going back longer than a week. And
copies of backups that are stored off-site for disaster recovery. And
backups of the master database to go with the application database.
I came across a clever overview of backup issues a few years ago. It
is partly an advertisement for a backup product, and not aimed at
databases, but the underlying philosophy it conveys is pretty good.
You might want to read it.
http://www.taobackup.com/
Roy Harvey
Beacon Falls, CT|||How long does a full backup take?
How much disk space is available?
Are you writing locally, or to a SAN?
The answers to these and posibally other) questions will help you make a
decision.
If resources are available, I always prefer full backups along with the
transaction logs.
Jay
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:u95za1l%23HHA.4476@.TK2MSFTNGP06.phx.gbl...
> What do you think this sort of backup?
> Sunday - Full Database backup
> Monday to Saturday - Differential Log backup
>