problems restoring logs & bak

• Sergio Campos

  SSC-Addicted

  Points: 459

  More actions

  April 25, 2006 at 3:19 am

  #114442

  hi , i'm trying to restore logs & bak with tsql, but when for example when i type

  RESTORE LOG action_packs FROM DISK='c:\promo_cp\temp\ac_pks_200604181635.trn' WITH NORECOVERY

  it said that it cant modified the state of database while other users use it, how could i fix this, any help plz?

  Thanks

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  April 25, 2006 at 5:44 am

  #633971

  You can only restore a database when there is noone in it, it must be empty from *all* users, including your own connection that does the restore.

  Make sure that no user is using your db, and then the restore should work fine.

  /Kenneth