August 30, 2007 at 11:15 am
I am in the process of replicating SQL Server 2000 database running on a clustered server to a SQL Server 2005 for reporting purposes. I intend to use transactional replication without the initial snapshot. The Subscriber will not be updating the data. I was able to configure distribution and create publication and subscription without enabling the snapshot agent by using on demand only option and not ticking the checkboxes for the snapshot agent. So far so good. But now I dont have much information from here to proceed further. Iam using Management Studio. Please advise.
August 30, 2007 at 12:05 pm
for these situations I would use only scripts, not just UI.
* Noel
August 30, 2007 at 5:09 pm
I understand one should use scripts. I am using the SQL Server 2005environment -- that's what I meant when I stated I am using Management Studio. But the Published data is SQL 2000.
Cause I have come across this situation while trying to enable Publisher to allow initialization from backup with the following code
DECLARE @publication AS sysname
SET @publication = 'ABCD_Publication'
USE ABCD
EXEC sp_changepublication
@publication = @publication,
@property = N'allow_initialize_from_backup',
@value = 1
GO
But I could not find allow_initialize_from_backup property through sp_helppublication
Advise Please
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply