To Rename Database in Primary Server For Logshipping

• Saravanan T

  SSCrazy

  Points: 2506

  More actions

  April 19, 2010 at 4:56 am

  #386730

  HI,

  I have configured Log shipping . I want to rename the database . How to do it????

  Regards,
  Saravanan

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  April 19, 2010 at 8:22 am

  #1153867

  Hi,

  After you rename the primary DB, as the logshipping is configured on the <old database>, the transaciton log backup fails with the error:

  Error: Could not locate entry in sysdatabases for database <old name>.

  I think, logshipping needs to re-configured if the DB name is changed.

  [font="Verdana"]Renuka__[/font]