Can Read Only Database receiving tranaction log?

• Judy Why

  Hall of Fame

  Points: 3656

  More actions

  February 22, 2010 at 6:55 am

  #219341

  Hi All,

  This is a request from client.

  They need full database backup. but they onlu want to restore full backup once, and then apply all the changes later. During ant time, they can query the database.

  What restore command can they use? They can use database(only read) and apply the transaction log (log backups from our side).

  If they use "with norecovery", then they can't use database;

  If they use "with recovery", then they can't apply transaction log.

  By the way, They can't use Log Shipping, Replication, Database Mirroring etc.

  Thanks

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  February 22, 2010 at 7:09 am

  #1122925

  use with standby option

  ---------------------------------------------------------------------

• Judy Why

  Hall of Fame

  Points: 3656

  More actions

  February 22, 2010 at 7:29 am

  #1122943

  george sibbald (2/22/2010)

  ---

  use with standby option

  Thank you. That works.