Backups...daily

Hi,
When using the default backup tool and scheduling them nightly that come
with SQL 2000 Standard Edition are we getting good backups on a daily basis?
Meaning usable data for a restore in the event of disaster, I was told by
an associate that we are getting worthless backups without Backupexe.
Also, I know that we have other solutions by backing up the log files
assuming that the database is not set to "Simple". Suggestions?
Thanks!
Hi,
SQL Server Standard backup is allways safe. So do not worry. If it is a
production database you could set the recovery model to "FULL"
and do a Transaction log backup every 30 minutes. Every night you could do a
Differential or FULL database backup.
Transaction log backup with FULL recovery model will allow you to recover
the database fully in the eve of a crash as well
as you could do a POINT_IN_TIME recovery.
SEE THE BELOW SITE FOR BACKUP AND RECOVERY STRATEGY:-
http://www1.us.dell.com/content/topi...555&l=en&s=biz
Thanks
Hari
SQL Server MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When using the default backup tool and scheduling them nightly that come
> with SQL 2000 Standard Edition are we getting good backups on a daily
> basis? Meaning usable data for a restore in the event of disaster, I was
> told by an associate that we are getting worthless backups without
> Backupexe.
> Also, I know that we have other solutions by backing up the log files
> assuming that the database is not set to "Simple". Suggestions?
> Thanks!
>
|||Thank you!
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eEg2wG0gFHA.2880@.TK2MSFTNGP09.phx.gbl...
> Hi,
> SQL Server Standard backup is allways safe. So do not worry. If it is a
> production database you could set the recovery model to "FULL"
> and do a Transaction log backup every 30 minutes. Every night you could do
> a Differential or FULL database backup.
> Transaction log backup with FULL recovery model will allow you to recover
> the database fully in the eve of a crash as well
> as you could do a POINT_IN_TIME recovery.
> SEE THE BELOW SITE FOR BACKUP AND RECOVERY STRATEGY:-
> http://www1.us.dell.com/content/topi...555&l=en&s=biz
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
>
|||Are you backing up to the same drive that youre db is on? If so, yes it is
worthless.
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When using the default backup tool and scheduling them nightly that come
> with SQL 2000 Standard Edition are we getting good backups on a daily
> basis? Meaning usable data for a restore in the event of disaster, I was
> told by an associate that we are getting worthless backups without
> Backupexe.
> Also, I know that we have other solutions by backing up the log files
> assuming that the database is not set to "Simple". Suggestions?
> Thanks!
>
|||You say it's worthless because of the obvious hard drive failures or some
other reason?
"ChrisR" <noemail@.bla.com> wrote in message
news:e9V9AN0gFHA.1468@.TK2MSFTNGP14.phx.gbl...
> Are you backing up to the same drive that youre db is on? If so, yes it is
> worthless.
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
>
|||The obvious hard drive failures.
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:uBrFAl0gFHA.2904@.tk2msftngp13.phx.gbl...
> You say it's worthless because of the obvious hard drive failures or some
> other reason?
> "ChrisR" <noemail@.bla.com> wrote in message
> news:e9V9AN0gFHA.1468@.TK2MSFTNGP14.phx.gbl...
>