Saturday, March 30, 2013

Database 'distribution' does not exist.

When I try to configure replication, I get the error "Database 'distribution' does not exist. Make sure that the name is entered correctly."

I’m not able to use the distribution database because it doesn't exist, and I even can't create the distribution database because it already exists.

USE master
Go
Alter Database distribution Set Offline;
GO
Drop Database distribution;


Above script help you to remove distributor and then recreate them.
Could not locate entry in sysdatabases for database 'distribution'. No entry found with that name. Make sure that the name is entered correctly, does not exist in the database, sql server 2012, sql server 2008 R2, sql server 2005, sql server 2000, Msg 922, Level 14, State 1, Line 1, Database 'distribution' is being recovered. Waiting until recovery is finished. Msg 3148, Level 16, State 3, Line 1, This RESTORE statement is invalid in the current context. The 'Recover Data Only' option is only defined for secondary filegroups when the database is in an online state. When the database is in an offline state filegroups cannot be specified. Msg 3013, Level 16, State 1, Line 1, RESTORE DATABASE is terminating abnormally. distribution database cann't be dropped. Dropped Distribution database. Distribution database exists. unable to disable publishing and distribution‎ . Determining size of Distribution database‎ . How to clean Distribution database. Database 'distribution' cannot be opened due to inaccessible files or insufficient memory or disk space. Large Distribution Database. Drop Distribution DB. Publications. Subscriptions. jobs. agents.

0 comments:

Post a Comment