location of subscription database?

Hi, I have set up transactional replication. I have specified the folder
that the snapshot is to reside in (on our SAN). But how does one specify the
location of the database tables on the subscriber end? I wish to place the
..mdf and .ldf that the subecriber picks up, in a pre-defined location. I
cannot see it in the publisher properties or the agent properties. I can
only see the option to define the 'snapshot location' .. but what about the
subecriber database location? any help most appreciated!
I installed a fresh instance of SQL as the subscriber. I created the
publication and pushed it to the subscriber. Do i have to create a dummy
database (with same name as the database to be replicated) on the subecriber
and predefine the location of the .mdf and .ldf files before i start the
transactional replication? What steps am i missing?
Any help most appreciated!
cheers, john
Did you create a subscription yet? During that, it asks you where you want to
put your replicated db. You can create that prior to your setup and point
your subscription to point to that db. Also, when you are creating the
subscription, it asks you for the subscription db. At this time, you can
chose the one you created or you can create one with all the things you want
to define.
Tejas
|||Replication needs a preexisting database. There is no way to deploy a
database through replication.
Hilary Cotter
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
"john r" <johnr@.trailer.com> wrote in message
news:%23z1ChEF8FHA.3200@.TK2MSFTNGP11.phx.gbl...
> Hi, I have set up transactional replication. I have specified the folder
> that the snapshot is to reside in (on our SAN). But how does one specify
> the location of the database tables on the subscriber end? I wish to place
> the .mdf and .ldf that the subecriber picks up, in a pre-defined location.
> I cannot see it in the publisher properties or the agent properties. I can
> only see the option to define the 'snapshot location' .. but what about
> the subecriber database location? any help most appreciated!
> I installed a fresh instance of SQL as the subscriber. I created the
> publication and pushed it to the subscriber. Do i have to create a dummy
> database (with same name as the database to be replicated) on the
> subecriber and predefine the location of the .mdf and .ldf files before i
> start the transactional replication? What steps am i missing?
> Any help most appreciated!
> cheers, john
>
|||Hilary, when you are creating a subscription through the Create subscription
Wizard, What's the "Choose Destination Database"? There, it says browse or
create and when you click on it, It has a button to "Create New" and when you
click that, doesn't it allow you to replicate to the newly created db? Am i
missing something? Please tell me if i'm wrong. Thank you.
Tejas.
|||You are completely correct here Tejas. But if you script your subscription
out and then modify it for another subscriber which does not have the
subscription database it will not create it and the agent will fail. Or if
you deploy the subscription to a subscription group or multiple subscribers
you will not have the option to precreate the subscription database through
the Wizard.
Hilary Cotter
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
"Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:7BE03DE5-DA5F-43E5-A9C6-1CEBCF44EAD5@.microsoft.com...
> Hilary, when you are creating a subscription through the Create
> subscription
> Wizard, What's the "Choose Destination Database"? There, it says browse or
> create and when you click on it, It has a button to "Create New" and when
> you
> click that, doesn't it allow you to replicate to the newly created db? Am
> i
> missing something? Please tell me if i'm wrong. Thank you.
> Tejas.

LOCAL USER vs GLOBAL USER set in agent service

My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.

Thank you in advance. Good day!

Can you post the error message you're seeing while trying to start snapshot agent job? From that we can confirm whether the issue you're seeing is due to agent account setup. Sometimes the issue may be caused by local user doesn't have permission on network resources.

Thanks,

Zhiqiang Feng

|||

mongol wrote:

My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.

Thank you in advance. Good day!

hi mongol

be sure the the login used by the service has an NTFS permission in the

replication shared folder

and the services has also write permission to the replication target database

Local User Account and Replication

Hi - Suppose I wanted to do replication (merge) between two machines
that are not part of a domain. So I create the same Windows account on both
machines (with the same password) and start SQL Server services under those
accounts. Can I do all replication operations in this scenario?
In BOL it says "A domain user account is typically used because many
server-to-server activities can be performed only with a domain user
account" and one of the items is replication. Does that mean that
replication between two machines can only be done with domain accounts?
Thanks,
Maer
Your method should work. Your method is called pass through authentication,
or pass thru authentication.
You do not need to be in the same domain for this to work. Check out this kb
article for more info.
http://support.microsoft.com/default...b;en-us;321822
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Maer" <maer@.auditleverage.com> wrote in message
news:ewpJXdL0EHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi - Suppose I wanted to do replication (merge) between two machines
> that are not part of a domain. So I create the same Windows account on
both
> machines (with the same password) and start SQL Server services under
those
> accounts. Can I do all replication operations in this scenario?
> In BOL it says "A domain user account is typically used because many
> server-to-server activities can be performed only with a domain user
> account" and one of the items is replication. Does that mean that
> replication between two machines can only be done with domain accounts?
>
> Thanks,
> Maer
>

local access to replication logs (was "Does anyone have a clever solution")

We have a SQL Server database that runs a website on our server, however the company that we are running the website for requested that they have a replicated local version at their business. Everything is working fine.

However they have requested that they have access to the replication logs. They want to have the details of the recent replication details so they can see if changes they have made on their side has been transferre across successfully they also want a table with all the details in of the changes that have ever happened. Can anyone suggest a good way of doing this?

Thanks EdStructure changes or data cheanges.

If they're changing the structure I think it's a much bigger deal...|||I've had to do the same thing at my company, what I did was put triggers on the replicated tables (on the subscriber side). The triggers wrote all insert/updates into a "Log" table which our customer could access throgh Crystal reports.|||Thanks I thik I'll go with the trigger solution, Thanks Ed