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?

i need help

XYZ Company is a Car production company. It has four factories and many distribution outlets spread across the country. The company keeps online records of the sales of its cars. It also creates batched Production schedules on the basis of the sales of the car. The car production is done at a nearest factory so that the cost of transfer of cars to distribution centre is minimized. Each factory also maintains its inventory. The company maintains a distributed database management system keeping all the above information. The following information may be stored in the Distribution and Inventory Management System of the Company:

(Please note that the following description may lead to un-normalized relations, normalize them wherever required. You may also add more tables as per your analysis.)

Data store NameDescription
Distribution OutletsIt includes outlet code, outlet name, outlet address, list of car models, sales made for each model etc.
Factory It may be keeping information about each car inventory items (Model wise). It includes item code, item name, model in which this item is used, quantity used in a single Car unit, and quantity in stock, time taken to produce a batch of 100 cars, etc. This information is stored factory wise. Each factory will have separate minimum stock and reorder level based on its capacity.
Batched OrderIt includes details on overall sales of Cars at various outlets, all such sales are put together to generate a consolidated orders for factories. On the basis of such orders the factories make Cars.

Assume that only following two applications exists:

(a)Keeping track of status of Inventory so that the delays in production of Cars can be minimised. Proper reorder levels should be kept so that a given order of cars is completed with full assembly load in desired time.

(b)It evaluates the performance of each distribution outlet of the Company.
Design a distributed database assuming that at present the company has only 10 outlets. Also assume statistics, which justifies your design.

Your design should include:

(i)The global schema, fragmentation schema and allocation schema.
(ii)SQL commands/ application code for above queries/applications.
(iii)How the response for application 1 and 2 will be generated? Assuming these are global queries, explain how various fragments will be combined to generate the query response.
(iv)Implement the database at least using a centralized database management system (make suitable adjustments in your design).It looks like it is your school assignment.
Show us some work and where you have a problem.|||Kindly post what you have tried so far .