cancel
Showing results for 
Search instead for 
Did you mean: 

Restore SQL database

Ericx22x
Level 4

Is it possible to restore SQL database from daily backups? i have 2 schedules :daily and weekly, they both backup the same thing, correct?

Thanks

1 REPLY 1

RAPHAEL_F_CARVA
Level 5
Employee Accredited Certified

Not exactly the same thing. Daily backups could be Transaction Logs or Differential Dump as Weekly normally is a full one. If your daily is a full backup, you can restore your entire database using only it, if not, you will need a full one and then apply the subsequent dumps or transaction logs.

 

At first, don't mind about that, create the restore script to a 'roll forward' or 'point in time restore' and NBU will automatically request the tapes it needs (see the job details on activity monitor).

 

Normally works, if not, has something wrong with your SQL backup strategy (Wrong scripts definitions, wrong database configuration, wrong backup schedule configuration, and so on). 

Message Edited by Raphael Carvalho on 01-27-2009 04:12 PM