Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

To Rename Database in Primary Server For Logshipping Expand / Collapse
Author
Message
Posted Monday, April 19, 2010 4:56 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:06 AM
Points: 498, Visits: 701
HI,
I have configured Log shipping . I want to rename the database . How to do it????


Regards,
Saravanan
Post #905828
Posted Monday, April 19, 2010 8:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:30 AM
Points: 1,012, Visits: 1,316
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.


Renuka__
Post #906025
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse