Backup/Restore

• luda

  SSC Veteran

  Points: 219

  More actions

  December 16, 2003 at 11:35 am

  #151994

  I need help!!!

  I have to do backups of production database

  and restore them on the backup server.

  The database should be updated from backups every 20-30 miniets

  and this database on the backup server should be operational.

  How is it possible to do? There are a lot of problems:

  1.I can’t run backup if the database is in use.(Operational???)

  2. I load full backup(from Sunday) and every 20-30 miniets ( till the next full backup)

  I have to restore on backup server Transaction LOG backups.

  To be able to load Transaction LOG backups

  I have to specify WITH NORECOVERY or WITH STANDBY for all but the final step.

  It means that nobody will not be able to work with this database.

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  December 16, 2003 at 11:47 am

  #486479

  Luda,

  Please don't post twice. Your post, with the same subject, in the TSQL section is getting responses.

  -SQLBill