Rename database.

• anzz

  SSCertifiable

  Points: 5503

  More actions

  September 8, 2012 at 8:16 am

  #281410

  TITLE: Microsoft SQL Server Management Studio

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

  Unable to rename TableAuditLogs_OLD. (ObjectExplorer)

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

  ADDITIONAL INFORMATION:

  Rename failed for Database 'TableAuditLogs'. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+Database&LinkId=20476

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

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

  Can not rename the database name because it is published or it is a distribution database used by replication. (Microsoft SQL Server, Error: 18855)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2796&EvtSrc=MSSQLServer&EvtID=18855&LinkId=20476

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

  BUTTONS:

  OK

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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736544

  More actions

  September 8, 2012 at 9:19 am

  #1535391

  The error says it all. Replication is enabled, so you can't rename the database.