PROBLEM WITH ADDING NEW DISTRIBUTION DATABASE TO DISTRIBUTOR

• navie22

  SSC-Addicted

  Points: 494

  More actions

  March 22, 2015 at 2:21 pm

  #74787

  I am having problem with creating new distribution dB. it does not show under distributor. I started form scratch but no luck. here is code I am using.

  already have distribution as one distribution db. need multiple distributiondb's to support heavy load.

  USE master

  GO

  exec sp_adddistributiondb

  @database = N'Distribution_1',

  @data_folder = N'G:\Program Files\Microsoft SQL Server\MSSQL11.ODS\MSSQL\Data',

  @log_folder = N'H:\Program Files\Microsoft SQL Server\MSSQL11.ODS\MSSQL\Data',

  @data_file_size = 200,

  @log_file_size = 200,

  @min_distretention = 0,

  @max_distretention = 24,

  @history_retention = 24,

  @security_mode = 1

  GO

  when I run EXEC sp_helpdistributor; I only see first distribution.

  servernamedistribution

  servername distribution_1 missing in list.

  thanks,

  Navie