Thank you for reply

what you mean with manage history

Can any one help me if possible

Thank you for reply

My data as following(fixing data)

Salary (Change every year)

Bonus(change every year)

Transport Amount

Resident Amount

My data Variable data

overtime

Deduction

How my diagram will be

my diagram no as following

but remaining Payroll table

Employee...

can any one help me in question above

Hi guys i thanks all very much but what i need is to request about some thing

are these files all full backup or differential backup.

and can i make restore one...

Can i do shrink to database to minimize size if possible

please help me

how i can do this by ssis please tell me