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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:05 AM
Points: 500, Visits: 741
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: Wednesday, September 10, 2014 9:19 AM
Points: 1,016, Visits: 1,343
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