Prev: Invalid object name 'dbo.sysmergepublications'
Next: Snapshot replication Problem
From: thejamie on 28 Nov 2006 16:29
Someone deleted one of the folders that SQL Server installs. We reinstalled
SQL and voila, the file is there now.
--
Regards,
Jamie


"Hilary Cotter" wrote:

> There is a script called instdist.sql which is run. Any errors are logged to
> a file called instdist.out. Somehow you are having a problem running this
> script.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "thejamie" <thejamie(a)discussions.microsoft.com> wrote in message
> news:225ACF20-532F-41E5-A1AB-C0FFB3EF6B35(a)microsoft.com...
> > Let's try again... the last post appears blank on my screen.
> > Hilary,
> > We have searched the server hoping to find this file. The file does not
> > exist on the server so I don't know what it says. Thus my question - any
> > idea what it may mean?
> > --
> > Regards,
> > Jamie
> >
> >
> > "Hilary Cotter" wrote:
> >
> >> What does 'instdist.out say?
> >>
> >> You can also issue this command
> >>
> >> sp_adddistributiondb 'distributionNew',@data_folder='c:\temp,
> >> @data_file='distribution.mdf',
> >>
> >> @log_folder='ctemp', @log_file='distribution.ldf',
> >>
> >> @log_file_size=5,@create_mode=1
> >>
> >> where c:\temp already exists
> >>
> >>
> >> --
> >> Hilary Cotter
> >> Director of Text Mining and Database Strategy
> >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> >>
> >> This posting is my own and doesn't necessarily represent RelevantNoise's
> >> positions, strategies or opinions.
> >>
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >>
> >>
> >> "thejamie" <thejamie(a)discussions.microsoft.com> wrote in message
> >> news:B7FBF6B2-F8D0-40C6-9844-A21E386C991E(a)microsoft.com...
> >> > What does this mean? It appears to be keeping the wizard from running
> >> > the
> >> > distributor setup on the server.
> >> >
> >> > Code used is:
> >> > use master go
> >> > sp_adddistributor @distributor = @@servername GO
> >> > sp_adddistributiondb @database='distribution' GO
> >> >
> >> > Error is:
> >> > Server: Msg 14113, Level 16, State 1, Procedure sp_adddistributiondb,
> >> > Line
> >> > 304
> >> > Could not execute 'copy "d:\Program Files\Microsoft SQL
> >> > Server\MSSQL\DATA\DISTMDL.MDF" "d:\Program Files\Microsoft SQL
> >> > Server\MSSQL\DATA\distribution.MDF"'. Check 'instdist.out' in the
> >> > install
> >> > directory.
> >> >
> >> >
> >> >
> >> > --
> >> > Regards,
> >> > Jamie
> >>
> >>
> >>
>
>
>
 | 
Pages: 1
Prev: Invalid object name 'dbo.sysmergepublications'
Next: Snapshot replication Problem