I need your opinion on my way to do a Backup

My Database is online 24/24...7/7, but in the night and on the weekend
the database is not very busy.
99% of the transactions are made between 7h30 AM and 20h00 (monday to
friday)
This is the way I schedule my BackUp
Every nigth I start this job at 1h00AM
backup database [databasName]to [databaseDevice] with init
At 7h00AM I start this job
backup log [databasName]to [databaseDeviceLog] with init,skip
And between 8h00Am to 20h00 PM every hour this job run
backup log [databasName] to [databaseDeviceLog]with noinit
The files Attach to the device are on another server...is it ok?Hi,
Your streategy seams to be very good. Apart from this, To validate your
backups please do a restore of this backup files in any of your
test servers. I do this check once in every 3 months
Note:
As part of backup strategy ensure that you take the full database backup of
Master and MSDB database daily.
Thanks
Hari
MDBA
"Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
news:3b53412a.0402270607.13527bf4@.posting.google.com...
> My Database is online 24/24...7/7, but in the night and on the weekend
> the database is not very busy.
> 99% of the transactions are made between 7h30 AM and 20h00 (monday to
> friday)
> This is the way I schedule my BackUp
> Every nigth I start this job at 1h00AM
> backup database [databasName]to [databaseDevice] with init
> At 7h00AM I start this job
> backup log [databasName]to [databaseDeviceLog] with init,skip
> And between 8h00Am to 20h00 PM every hour this job run
> backup log [databasName] to [databaseDeviceLog]with noinit
> The files Attach to the device are on another server...is it ok?

I need your opinion on my way to do a Backup

My Database is online 24/24...7/7, but in the night and on the weekend
the database is not very busy.
99% of the transactions are made between 7h30 AM and 20h00 (monday to
friday)
This is the way I schedule my BackUp
Every nigth I start this job at 1h00AM
backup database [databasName]to [databaseDevice] with init
At 7h00AM I start this job
backup log [databasName]to [databaseDeviceLog] with init,skip
And between 8h00Am to 20h00 PM every hour this job run
backup log [databasName] to [databaseDeviceLog]with noinit
The files Attach to the device are on another server...is it ok?Hi,
Your streategy seams to be very good. Apart from this, To validate your
backups please do a restore of this backup files in any of your
test servers. I do this check once in every 3 months
Note:
As part of backup strategy ensure that you take the full database backup of
Master and MSDB database daily.
Thanks
Hari
MDBA
"Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
news:3b53412a.0402270607.13527bf4@.posting.google.com...
> My Database is online 24/24...7/7, but in the night and on the weekend
> the database is not very busy.
> 99% of the transactions are made between 7h30 AM and 20h00 (monday to
> friday)
> This is the way I schedule my BackUp
> Every nigth I start this job at 1h00AM
> backup database [databasName]to [databaseDevice] with init
> At 7h00AM I start this job
> backup log [databasName]to [databaseDeviceLog] with init,skip
> And between 8h00Am to 20h00 PM every hour this job run
> backup log [databasName] to [databaseDeviceLog]with noinit
> The files Attach to the device are on another server...is it ok?