|
|
You're in the
sql server replication
group:SQL Server Agent Account
sql server replication:
I am going to be setting up replication that will support replication from server in one country to another server in another country both residing in the same domain. Do I need to have the same SQL Server Agent account running under a non system domain account on both the publisher and subscription servers? Thanks, Anjelina
If you use all of the defaults and are not using ftp the sql server agent
accounts should be the same domain account on both servers. If this will not work for you then they could be local admin accounts with the same name and password, or the subscriber sql server agent account should be in the admin group on the publisher, or have rights to map to \\publisherServerName\c$ and have rights to access c$\program files\Microsoft sql server\mssql\repldata\unc and the underlying files and folders. You can always park the snapshot files in other locations or create a share on the publisher which the sql server agent account on the publisher has rights to map to and access. HTH. BTW - I used to live in Alberta, BC, Ont, and the NWT :) [quoted text, click to view] "anjelina" <ajturner@canada.com> wrote in message news:05cc01c39ace$853e9f00$a601280a@phx.gbl... > Hi! > > I am going to be setting up replication that will support > replication from server in one country to another server > in another country both residing in the same domain. > > Do I need to have the same SQL Server Agent account > running under a non system domain account on both the > publisher and subscription servers? > > Thanks, > Anjelina >
Thanks Hilary!
I will be setting them both with the same domain account and will give it a go. Is it recommened to create the snapshot folder in a different location that the default?? Lived mostly in Montreal and spent a few few yrs in NB when I was small. Now living in Dubai, U.A.E. Go figure.. NWT - Yikes - chilly!!! Anjelina [quoted text, click to view] >-----Original Message-----
>If you use all of the defaults and are not using ftp the sql server agent >accounts should be the same domain account on both servers. > >If this will not work for you then they could be local admin accounts with >the same name and password, or the subscriber sql server agent account >should be in the admin group on the publisher, or have rights to map to >\\publisherServerName\c$ and have rights to access c$\program >files\Microsoft sql server\mssql\repldata\unc and the underlying files and >folders. > >You can always park the snapshot files in other locations or create a share >on the publisher which the sql server agent account on the publisher has >rights to map to and access. > >HTH. > >BTW - I used to live in Alberta, BC, Ont, and the NWT :) >"anjelina" <ajturner@canada.com> wrote in message >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... >> Hi! >> >> I am going to be setting up replication that will support >> replication from server in one country to another server >> in another country both residing in the same domain. >> >> Do I need to have the same SQL Server Agent account >> running under a non system domain account on both the >> publisher and subscription servers? >> >> Thanks, >> Anjelina >> > > >.
As you can probably guess I'm new to setting up SQL
server replication.. I will be setting the Agent accounts under the same account so I won't have to create the folder elsewhere. However, how much space can I anticipate the snapshot folder taking? I would like to setup transactional replication, but to run at scheduled intervals, not continously, say every hour... The default location is located on the same drive as the O/S which has about 600MB of space, do you think that will be sufficient? Thanks, Anjelina... Did my bachelors at Concordia (about half of my courses taken at the Loyola Campus). Possible I had your dad as teacher.. 93-96 [quoted text, click to view] >-----Original Message-----
>I would not use a different folder for the snapshot unless you have space >issues or you want to optimize the reads by placing it on a raid 5 >partition. You can use a different folder is you want to use an account that >is not an admin account on your local machine - ie if you do not want to >give the subscriber SQL Server agent account rights to access the c$ or d$ >admin shares. > >My father use to teach at Loyola, and my sisters used to work in Saudi >Arabia. > >Good luck. > >"anjelina" <anonymous@discussions.microsoft.com> wrote in message >news:046501c39b99$009ce650$a601280a@phx.gbl... >> Thanks Hilary! >> >> I will be setting them both with the same domain account >> and will give it a go. >> >> Is it recommened to create the snapshot folder in a >> different location that the default?? >> >> Lived mostly in Montreal and spent a few few yrs in NB >> when I was small. Now living in Dubai, U.A.E. Go figure.. >> NWT - Yikes - chilly!!! >> >> Anjelina >> >-----Original Message----- >> >If you use all of the defaults and are not using ftp the >> sql server agent >> >accounts should be the same domain account on both >> servers. >> > >> >If this will not work for you then they could be local >> admin accounts with >> >the same name and password, or the subscriber sql server >> agent account >> >should be in the admin group on the publisher, or have >> rights to map to >> >\\publisherServerName\c$ and have rights to access >> c$\program >> >files\Microsoft sql server\mssql\repldata\unc and the >> underlying files and >> >folders. >> > >> >You can always park the snapshot files in other >> locations or create a share >> >on the publisher which the sql server agent account on >> the publisher has >> >rights to map to and access. >> > >> >HTH. >> > >> >BTW - I used to live in Alberta, BC, Ont, and the NWT :) >> >"anjelina" <ajturner@canada.com> wrote in message >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... >> >> Hi! >> >> >> >> I am going to be setting up replication that will >> support >> >> replication from server in one country to another >> server >> >> in another country both residing in the same domain. >> >> >> >> Do I need to have the same SQL Server Agent account >> >> running under a non system domain account on both the >> >> publisher and subscription servers? >> >> >> >> Thanks, >> >> Anjelina >> >> >> > >> > >> >. >> > > > >.
I would not use a different folder for the snapshot unless you have space
issues or you want to optimize the reads by placing it on a raid 5 partition. You can use a different folder is you want to use an account that is not an admin account on your local machine - ie if you do not want to give the subscriber SQL Server agent account rights to access the c$ or d$ admin shares. My father use to teach at Loyola, and my sisters used to work in Saudi Arabia. Good luck. [quoted text, click to view] "anjelina" <anonymous@discussions.microsoft.com> wrote in message news:046501c39b99$009ce650$a601280a@phx.gbl... > Thanks Hilary! > > I will be setting them both with the same domain account > and will give it a go. > > Is it recommened to create the snapshot folder in a > different location that the default?? > > Lived mostly in Montreal and spent a few few yrs in NB > when I was small. Now living in Dubai, U.A.E. Go figure.. > NWT - Yikes - chilly!!! > > Anjelina > >-----Original Message----- > >If you use all of the defaults and are not using ftp the > sql server agent > >accounts should be the same domain account on both > servers. > > > >If this will not work for you then they could be local > admin accounts with > >the same name and password, or the subscriber sql server > agent account > >should be in the admin group on the publisher, or have > rights to map to > >\\publisherServerName\c$ and have rights to access > c$\program > >files\Microsoft sql server\mssql\repldata\unc and the > underlying files and > >folders. > > > >You can always park the snapshot files in other > locations or create a share > >on the publisher which the sql server agent account on > the publisher has > >rights to map to and access. > > > >HTH. > > > >BTW - I used to live in Alberta, BC, Ont, and the NWT :) > >"anjelina" <ajturner@canada.com> wrote in message > >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... > >> Hi! > >> > >> I am going to be setting up replication that will > support > >> replication from server in one country to another > server > >> in another country both residing in the same domain. > >> > >> Do I need to have the same SQL Server Agent account > >> running under a non system domain account on both the > >> publisher and subscription servers? > >> > >> Thanks, > >> Anjelina > >> > > > > > >. > >
How is Dubai and where is NWT ? Is that the northwest ?
[quoted text, click to view] "anjelina" <anonymous@discussions.microsoft.com> wrote in message news:081001c39bce$dca03140$a301280a@phx.gbl... > As you can probably guess I'm new to setting up SQL > server replication.. > > I will be setting the Agent accounts under the same > account so I won't have to create the folder elsewhere. > However, how much space can I anticipate the snapshot > folder taking? I would like to setup transactional > replication, but to run at scheduled intervals, not > continously, say every hour... The default location is > located on the same drive as the O/S which has about > 600MB of space, do you think that will be sufficient? > > Thanks, > Anjelina... > > Did my bachelors at Concordia (about half of my courses > taken at the Loyola Campus). Possible I had your dad as > teacher.. 93-96 > > >-----Original Message----- > >I would not use a different folder for the snapshot > unless you have space > >issues or you want to optimize the reads by placing it > on a raid 5 > >partition. You can use a different folder is you want to > use an account that > >is not an admin account on your local machine - ie if > you do not want to > >give the subscriber SQL Server agent account rights to > access the c$ or d$ > >admin shares. > > > >My father use to teach at Loyola, and my sisters used to > work in Saudi > >Arabia. > > > >Good luck. > > > >"anjelina" <anonymous@discussions.microsoft.com> wrote > in message > >news:046501c39b99$009ce650$a601280a@phx.gbl... > >> Thanks Hilary! > >> > >> I will be setting them both with the same domain > account > >> and will give it a go. > >> > >> Is it recommened to create the snapshot folder in a > >> different location that the default?? > >> > >> Lived mostly in Montreal and spent a few few yrs in NB > >> when I was small. Now living in Dubai, U.A.E. Go > figure.. > >> NWT - Yikes - chilly!!! > >> > >> Anjelina > >> >-----Original Message----- > >> >If you use all of the defaults and are not using ftp > the > >> sql server agent > >> >accounts should be the same domain account on both > >> servers. > >> > > >> >If this will not work for you then they could be local > >> admin accounts with > >> >the same name and password, or the subscriber sql > server > >> agent account > >> >should be in the admin group on the publisher, or have > >> rights to map to > >> >\\publisherServerName\c$ and have rights to access > >> c$\program > >> >files\Microsoft sql server\mssql\repldata\unc and the > >> underlying files and > >> >folders. > >> > > >> >You can always park the snapshot files in other > >> locations or create a share > >> >on the publisher which the sql server agent account on > >> the publisher has > >> >rights to map to and access. > >> > > >> >HTH. > >> > > >> >BTW - I used to live in Alberta, BC, Ont, and the > NWT :) > >> >"anjelina" <ajturner@canada.com> wrote in message > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... > >> >> Hi! > >> >> > >> >> I am going to be setting up replication that will > >> support > >> >> replication from server in one country to another > >> server > >> >> in another country both residing in the same domain. > >> >> > >> >> Do I need to have the same SQL Server Agent account > >> >> running under a non system domain account on both > the > >> >> publisher and subscription servers? > >> >> > >> >> Thanks, > >> >> Anjelina > >> >> > >> > > >> > > >> >. > >> > > > > > > >. > >
how big are the tables you are replicating? If they are close to 400 Mgs
(IIRC - the OS needs 200 Free Mgs), you may run into problems. There is the compressed snapshot option which may help you, but it also needs to dump the snapshot in uncompressed form, before compressing it. It does allow you to create a temporary working folder where the uncompressed snapshot files will be dumped so if you have another drive with plenty of free space this might work. [quoted text, click to view] "anjelina" <anonymous@discussions.microsoft.com> wrote in message news:081001c39bce$dca03140$a301280a@phx.gbl... > As you can probably guess I'm new to setting up SQL > server replication.. > > I will be setting the Agent accounts under the same > account so I won't have to create the folder elsewhere. > However, how much space can I anticipate the snapshot > folder taking? I would like to setup transactional > replication, but to run at scheduled intervals, not > continously, say every hour... The default location is > located on the same drive as the O/S which has about > 600MB of space, do you think that will be sufficient? > > Thanks, > Anjelina... > > Did my bachelors at Concordia (about half of my courses > taken at the Loyola Campus). Possible I had your dad as > teacher.. 93-96 > > >-----Original Message----- > >I would not use a different folder for the snapshot > unless you have space > >issues or you want to optimize the reads by placing it > on a raid 5 > >partition. You can use a different folder is you want to > use an account that > >is not an admin account on your local machine - ie if > you do not want to > >give the subscriber SQL Server agent account rights to > access the c$ or d$ > >admin shares. > > > >My father use to teach at Loyola, and my sisters used to > work in Saudi > >Arabia. > > > >Good luck. > > > >"anjelina" <anonymous@discussions.microsoft.com> wrote > in message > >news:046501c39b99$009ce650$a601280a@phx.gbl... > >> Thanks Hilary! > >> > >> I will be setting them both with the same domain > account > >> and will give it a go. > >> > >> Is it recommened to create the snapshot folder in a > >> different location that the default?? > >> > >> Lived mostly in Montreal and spent a few few yrs in NB > >> when I was small. Now living in Dubai, U.A.E. Go > figure.. > >> NWT - Yikes - chilly!!! > >> > >> Anjelina > >> >-----Original Message----- > >> >If you use all of the defaults and are not using ftp > the > >> sql server agent > >> >accounts should be the same domain account on both > >> servers. > >> > > >> >If this will not work for you then they could be local > >> admin accounts with > >> >the same name and password, or the subscriber sql > server > >> agent account > >> >should be in the admin group on the publisher, or have > >> rights to map to > >> >\\publisherServerName\c$ and have rights to access > >> c$\program > >> >files\Microsoft sql server\mssql\repldata\unc and the > >> underlying files and > >> >folders. > >> > > >> >You can always park the snapshot files in other > >> locations or create a share > >> >on the publisher which the sql server agent account on > >> the publisher has > >> >rights to map to and access. > >> > > >> >HTH. > >> > > >> >BTW - I used to live in Alberta, BC, Ont, and the > NWT :) > >> >"anjelina" <ajturner@canada.com> wrote in message > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... > >> >> Hi! > >> >> > >> >> I am going to be setting up replication that will > >> support > >> >> replication from server in one country to another > >> server > >> >> in another country both residing in the same domain. > >> >> > >> >> Do I need to have the same SQL Server Agent account > >> >> running under a non system domain account on both > the > >> >> publisher and subscription servers? > >> >> > >> >> Thanks, > >> >> Anjelina > >> >> > >> > > >> > > >> >. > >> > > > > > > >. > >
Its the NorthWest Territories - Northern Canada - close the Arctic Circle.
[quoted text, click to view] "Hassan" <fatima_ja@hotmail.com> wrote in message news:uGTtyHAnDHA.2080@TK2MSFTNGP10.phx.gbl... > How is Dubai and where is NWT ? Is that the northwest ? > > "anjelina" <anonymous@discussions.microsoft.com> wrote in message > news:081001c39bce$dca03140$a301280a@phx.gbl... > > As you can probably guess I'm new to setting up SQL > > server replication.. > > > > I will be setting the Agent accounts under the same > > account so I won't have to create the folder elsewhere. > > However, how much space can I anticipate the snapshot > > folder taking? I would like to setup transactional > > replication, but to run at scheduled intervals, not > > continously, say every hour... The default location is > > located on the same drive as the O/S which has about > > 600MB of space, do you think that will be sufficient? > > > > Thanks, > > Anjelina... > > > > Did my bachelors at Concordia (about half of my courses > > taken at the Loyola Campus). Possible I had your dad as > > teacher.. 93-96 > > > > >-----Original Message----- > > >I would not use a different folder for the snapshot > > unless you have space > > >issues or you want to optimize the reads by placing it > > on a raid 5 > > >partition. You can use a different folder is you want to > > use an account that > > >is not an admin account on your local machine - ie if > > you do not want to > > >give the subscriber SQL Server agent account rights to > > access the c$ or d$ > > >admin shares. > > > > > >My father use to teach at Loyola, and my sisters used to > > work in Saudi > > >Arabia. > > > > > >Good luck. > > > > > >"anjelina" <anonymous@discussions.microsoft.com> wrote > > in message > > >news:046501c39b99$009ce650$a601280a@phx.gbl... > > >> Thanks Hilary! > > >> > > >> I will be setting them both with the same domain > > account > > >> and will give it a go. > > >> > > >> Is it recommened to create the snapshot folder in a > > >> different location that the default?? > > >> > > >> Lived mostly in Montreal and spent a few few yrs in NB > > >> when I was small. Now living in Dubai, U.A.E. Go > > figure.. > > >> NWT - Yikes - chilly!!! > > >> > > >> Anjelina > > >> >-----Original Message----- > > >> >If you use all of the defaults and are not using ftp > > the > > >> sql server agent > > >> >accounts should be the same domain account on both > > >> servers. > > >> > > > >> >If this will not work for you then they could be local > > >> admin accounts with > > >> >the same name and password, or the subscriber sql > > server > > >> agent account > > >> >should be in the admin group on the publisher, or have > > >> rights to map to > > >> >\\publisherServerName\c$ and have rights to access > > >> c$\program > > >> >files\Microsoft sql server\mssql\repldata\unc and the > > >> underlying files and > > >> >folders. > > >> > > > >> >You can always park the snapshot files in other > > >> locations or create a share > > >> >on the publisher which the sql server agent account on > > >> the publisher has > > >> >rights to map to and access. > > >> > > > >> >HTH. > > >> > > > >> >BTW - I used to live in Alberta, BC, Ont, and the > > NWT :) > > >> >"anjelina" <ajturner@canada.com> wrote in message > > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... > > >> >> Hi! > > >> >> > > >> >> I am going to be setting up replication that will > > >> support > > >> >> replication from server in one country to another > > >> server > > >> >> in another country both residing in the same domain. > > >> >> > > >> >> Do I need to have the same SQL Server Agent account > > >> >> running under a non system domain account on both > > the > > >> >> publisher and subscription servers? > > >> >> > > >> >> Thanks, > > >> >> Anjelina > > >> >> > > >> > > > >> > > > >> >. > > >> > > > > > > > > > >. > > > > >
Hilary,
I will be replicating 2 tables. One is currently 341MB and the other is 21MB. I feel like I'm probably better plcaing the snapshot folder on drive with more space... Another question. I was asked to clean up a Publisher/Publication so I ran the 'Disable publishing and distribution wizard.' I believe I'm still left with tables created as a result of the publication. Example of which are: MSdynamicsnapshotjobs, MSdynamicsnapshotviews, MSmerge_altsyncpartners etc.. What steps haven't I performed to remove this Publisher, Publication correctly? Thanks again!!!! Anjelina [quoted text, click to view] >-----Original Message-----
>Its the NorthWest Territories - Northern Canada - close the Arctic Circle. > >"Hassan" <fatima_ja@hotmail.com> wrote in message >news:uGTtyHAnDHA.2080@TK2MSFTNGP10.phx.gbl... >> How is Dubai and where is NWT ? Is that the northwest ? >> >> "anjelina" <anonymous@discussions.microsoft.com> wrote in message >> news:081001c39bce$dca03140$a301280a@phx.gbl... >> > As you can probably guess I'm new to setting up SQL >> > server replication.. >> > >> > I will be setting the Agent accounts under the same >> > account so I won't have to create the folder elsewhere. >> > However, how much space can I anticipate the snapshot >> > folder taking? I would like to setup transactional >> > replication, but to run at scheduled intervals, not >> > continously, say every hour... The default location is >> > located on the same drive as the O/S which has about >> > 600MB of space, do you think that will be sufficient? >> > >> > Thanks, >> > Anjelina... >> > >> > Did my bachelors at Concordia (about half of my courses >> > taken at the Loyola Campus). Possible I had your dad as >> > teacher.. 93-96 >> > >> > >-----Original Message----- >> > >I would not use a different folder for the snapshot >> > unless you have space >> > >issues or you want to optimize the reads by placing it >> > on a raid 5 >> > >partition. You can use a different folder is you want to >> > use an account that >> > >is not an admin account on your local machine - ie if >> > you do not want to >> > >give the subscriber SQL Server agent account rights to >> > access the c$ or d$ >> > >admin shares. >> > > >> > >My father use to teach at Loyola, and my sisters used to >> > work in Saudi >> > >Arabia. >> > > >> > >Good luck. >> > > >> > >"anjelina" <anonymous@discussions.microsoft.com> wrote >> > in message >> > >news:046501c39b99$009ce650$a601280a@phx.gbl... >> > >> Thanks Hilary! >> > >> >> > >> I will be setting them both with the same domain >> > account >> > >> and will give it a go. >> > >> >> > >> Is it recommened to create the snapshot folder in a >> > >> different location that the default?? >> > >> >> > >> Lived mostly in Montreal and spent a few few yrs in NB >> > >> when I was small. Now living in Dubai, U.A.E. Go >> > figure.. >> > >> NWT - Yikes - chilly!!! >> > >> >> > >> Anjelina >> > >> >-----Original Message----- >> > >> >If you use all of the defaults and are not using ftp >> > the >> > >> sql server agent >> > >> >accounts should be the same domain account on both >> > >> servers. >> > >> > >> > >> >If this will not work for you then they could be local >> > >> admin accounts with >> > >> >the same name and password, or the subscriber sql >> > server >> > >> agent account >> > >> >should be in the admin group on the publisher, or have >> > >> rights to map to >> > >> >\\publisherServerName\c$ and have rights to access >> > >> c$\program >> > >> >files\Microsoft sql server\mssql\repldata\unc and the >> > >> underlying files and >> > >> >folders. >> > >> > >> > >> >You can always park the snapshot files in other >> > >> locations or create a share >> > >> >on the publisher which the sql server agent account on >> > >> the publisher has >> > >> >rights to map to and access. >> > >> > >> > >> >HTH. >> > >> > >> > >> >BTW - I used to live in Alberta, BC, Ont, and the >> > NWT :) >> > >> >"anjelina" <ajturner@canada.com> wrote in message >> > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... >> > >> >> Hi! >> > >> >> >> > >> >> I am going to be setting up replication that will >> > >> support >> > >> >> replication from server in one country to another >> > >> server >> > >> >> in another country both residing in the same domain. >> > >> >> >> > >> >> Do I need to have the same SQL Server Agent account >> > >> >> running under a non system domain account on both >> > the >> > >> >> publisher and subscription servers? >> > >> >> >> > >> >> Thanks, >> > >> >> Anjelina >> > >> >> >> > >> > >> > >> > >> > >> >. >> > >> > >> > > >> > > >> > >. >> > > >> >> > > >.
The disable publishing wizard does leave some metadata or
system tables on your server. This is not a problem and if you check these tables should be empty. [quoted text, click to view] >-----Original Message-----
>Hilary, > >I will be replicating 2 tables. >One is currently 341MB and the other is 21MB. >I feel like I'm probably better plcaing the snapshot >folder on drive with more space... > >Another question. I was asked to clean up a >Publisher/Publication so I ran the 'Disable publishing >and distribution wizard.' I believe I'm still left with >tables created as a result of the publication. Example of >which are: MSdynamicsnapshotjobs, MSdynamicsnapshotviews, >MSmerge_altsyncpartners etc.. What steps haven't I >performed to remove this Publisher, Publication >correctly? > >Thanks again!!!! >Anjelina > >>-----Original Message----- >>Its the NorthWest Territories - Northern Canada - close >the Arctic Circle. >> >>"Hassan" <fatima_ja@hotmail.com> wrote in message >>news:uGTtyHAnDHA.2080@TK2MSFTNGP10.phx.gbl... >>> How is Dubai and where is NWT ? Is that the northwest ? >>> >>> "anjelina" <anonymous@discussions.microsoft.com> wrote >in message >>> news:081001c39bce$dca03140$a301280a@phx.gbl... >>> > As you can probably guess I'm new to setting up SQL >>> > server replication.. >>> > >>> > I will be setting the Agent accounts under the same >>> > account so I won't have to create the folder >elsewhere. >>> > However, how much space can I anticipate the snapshot >>> > folder taking? I would like to setup transactional >>> > replication, but to run at scheduled intervals, not >>> > continously, say every hour... The default location >is >>> > located on the same drive as the O/S which has about >>> > 600MB of space, do you think that will be sufficient? >>> > >>> > Thanks, >>> > Anjelina... >>> > >>> > Did my bachelors at Concordia (about half of my >courses >>> > taken at the Loyola Campus). Possible I had your dad >as >>> > teacher.. 93-96 >>> > >>> > >-----Original Message----- >>> > >I would not use a different folder for the snapshot >>> > unless you have space >>> > >issues or you want to optimize the reads by placing >it >>> > on a raid 5 >>> > >partition. You can use a different folder is you >want to >>> > use an account that >>> > >is not an admin account on your local machine - ie >if >>> > you do not want to >>> > >give the subscriber SQL Server agent account rights >to >>> > access the c$ or d$ >>> > >admin shares. >>> > > >>> > >My father use to teach at Loyola, and my sisters >used to >>> > work in Saudi >>> > >Arabia. >>> > > >>> > >Good luck. >>> > > >>> > >"anjelina" <anonymous@discussions.microsoft.com> >wrote >>> > in message >>> > >news:046501c39b99$009ce650$a601280a@phx.gbl... >>> > >> Thanks Hilary! >>> > >> >>> > >> I will be setting them both with the same domain >>> > account >>> > >> and will give it a go. >>> > >> >>> > >> Is it recommened to create the snapshot folder in >a >>> > >> different location that the default?? >>> > >> >>> > >> Lived mostly in Montreal and spent a few few yrs >in NB >>> > >> when I was small. Now living in Dubai, U.A.E. Go >>> > figure.. >>> > >> NWT - Yikes - chilly!!! >>> > >> >>> > >> Anjelina >>> > >> >-----Original Message----- >>> > >> >If you use all of the defaults and are not using >ftp >>> > the >>> > >> sql server agent >>> > >> >accounts should be the same domain account on >both >>> > >> servers. >>> > >> > >>> > >> >If this will not work for you then they could be >local >>> > >> admin accounts with >>> > >> >the same name and password, or the subscriber sql >>> > server >>> > >> agent account >>> > >> >should be in the admin group on the publisher, >or have >>> > >> rights to map to >>> > >> >\\publisherServerName\c$ and have rights to >access >>> > >> c$\program >>> > >> >files\Microsoft sql server\mssql\repldata\unc >and the >>> > >> underlying files and >>> > >> >folders. >>> > >> > >>> > >> >You can always park the snapshot files in other >>> > >> locations or create a share >>> > >> >on the publisher which the sql server agent >account on >>> > >> the publisher has >>> > >> >rights to map to and access. >>> > >> > >>> > >> >HTH. >>> > >> > >>> > >> >BTW - I used to live in Alberta, BC, Ont, and the >>> > NWT :) >>> > >> >"anjelina" <ajturner@canada.com> wrote in message >>> > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... >>> > >> >> Hi! >>> > >> >> >>> > >> >> I am going to be setting up replication that >will >>> > >> support >>> > >> >> replication from server in one country to >another >>> > >> server >>> > >> >> in another country both residing in the same >domain. >>> > >> >> >>> > >> >> Do I need to have the same SQL Server Agent >account >>> > >> >> running under a non system domain account on >both >>> > the >>> > >> >> publisher and subscription servers? >>> > >> >> >>> > >> >> Thanks, >>> > >> >> Anjelina >>> > >> >> >>> > >> > >>> > >> > >>> > >> >. >>> > >> > >>> > > >>> > > >>> > >. >>> > > >>> >>> >> >> >>. >> >.
Should I delete them?
[quoted text, click to view] >-----Original Message-----
>The disable publishing wizard does leave some metadata or >system tables on your server. This is not a problem and >if you check these tables should be empty. > >>-----Original Message----- >>Hilary, >> >>I will be replicating 2 tables. >>One is currently 341MB and the other is 21MB. >>I feel like I'm probably better plcaing the snapshot >>folder on drive with more space... >> >>Another question. I was asked to clean up a >>Publisher/Publication so I ran the 'Disable publishing >>and distribution wizard.' I believe I'm still left with >>tables created as a result of the publication. Example of >>which are: MSdynamicsnapshotjobs, MSdynamicsnapshotviews, >>MSmerge_altsyncpartners etc.. What steps haven't I >>performed to remove this Publisher, Publication >>correctly? >> >>Thanks again!!!! >>Anjelina >> >>>-----Original Message----- >>>Its the NorthWest Territories - Northern Canada - close >>the Arctic Circle. >>> >>>"Hassan" <fatima_ja@hotmail.com> wrote in message >>>news:uGTtyHAnDHA.2080@TK2MSFTNGP10.phx.gbl... >>>> How is Dubai and where is NWT ? Is that the northwest ? >>>> >>>> "anjelina" <anonymous@discussions.microsoft.com> wrote >>in message >>>> news:081001c39bce$dca03140$a301280a@phx.gbl... >>>> > As you can probably guess I'm new to setting up SQL >>>> > server replication.. >>>> > >>>> > I will be setting the Agent accounts under the same >>>> > account so I won't have to create the folder >>elsewhere. >>>> > However, how much space can I anticipate the snapshot >>>> > folder taking? I would like to setup transactional >>>> > replication, but to run at scheduled intervals, not >>>> > continously, say every hour... The default location >>is >>>> > located on the same drive as the O/S which has about >>>> > 600MB of space, do you think that will be sufficient? >>>> > >>>> > Thanks, >>>> > Anjelina... >>>> > >>>> > Did my bachelors at Concordia (about half of my >>courses >>>> > taken at the Loyola Campus). Possible I had your dad >>as >>>> > teacher.. 93-96 >>>> > >>>> > >-----Original Message----- >>>> > >I would not use a different folder for the snapshot >>>> > unless you have space >>>> > >issues or you want to optimize the reads by placing >>it >>>> > on a raid 5 >>>> > >partition. You can use a different folder is you >>want to >>>> > use an account that >>>> > >is not an admin account on your local machine - ie >>if >>>> > you do not want to >>>> > >give the subscriber SQL Server agent account rights >>to >>>> > access the c$ or d$ >>>> > >admin shares. >>>> > > >>>> > >My father use to teach at Loyola, and my sisters >>used to >>>> > work in Saudi >>>> > >Arabia. >>>> > > >>>> > >Good luck. >>>> > > >>>> > >"anjelina" <anonymous@discussions.microsoft.com> >>wrote >>>> > in message >>>> > >news:046501c39b99$009ce650$a601280a@phx.gbl... >>>> > >> Thanks Hilary! >>>> > >> >>>> > >> I will be setting them both with the same domain >>>> > account >>>> > >> and will give it a go. >>>> > >> >>>> > >> Is it recommened to create the snapshot folder in >>a >>>> > >> different location that the default?? >>>> > >> >>>> > >> Lived mostly in Montreal and spent a few few yrs >>in NB >>>> > >> when I was small. Now living in Dubai, U.A.E. Go >>>> > figure.. >>>> > >> NWT - Yikes - chilly!!! >>>> > >> >>>> > >> Anjelina >>>> > >> >-----Original Message----- >>>> > >> >If you use all of the defaults and are not using >>ftp >>>> > the >>>> > >> sql server agent >>>> > >> >accounts should be the same domain account on >>both >>>> > >> servers. >>>> > >> > >>>> > >> >If this will not work for you then they could be >>local >>>> > >> admin accounts with >>>> > >> >the same name and password, or the subscriber sql >>>> > server >>>> > >> agent account >>>> > >> >should be in the admin group on the publisher, >>or have >>>> > >> rights to map to >>>> > >> >\\publisherServerName\c$ and have rights to >>access >>>> > >> c$\program >>>> > >> >files\Microsoft sql server\mssql\repldata\unc >>and the >>>> > >> underlying files and >>>> > >> >folders. >>>> > >> > >>>> > >> >You can always park the snapshot files in other >>>> > >> locations or create a share >>>> > >> >on the publisher which the sql server agent >>account on >>>> > >> the publisher has >>>> > >> >rights to map to and access. >>>> > >> > >>>> > >> >HTH. >>>> > >> > >>>> > >> >BTW - I used to live in Alberta, BC, Ont, and the >>>> > NWT :) >>>> > >> >"anjelina" <ajturner@canada.com> wrote in message >>>> > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... >>>> > >> >> Hi! >>>> > >> >> >>>> > >> >> I am going to be setting up replication that >>will >>>> > >> support >>>> > >> >> replication from server in one country to >>another >>>> > >> server >>>> > >> >> in another country both residing in the same >>domain. >>>> > >> >> >>>> > >> >> Do I need to have the same SQL Server Agent >>account >>>> > >> >> running under a non system domain account on >>both >>>> > the >>>> > >> >> publisher and subscription servers? >>>> > >> >> >>>> > >> >> Thanks, >>>> > >> >> Anjelina >>>> > >> >> >>>> > >> > >>>> > >> > >>>> > >> >. >>>> > >> > >>>> > > >>>> > > >>>> > >. >>>> > > >>>> >>>> >>> >>> >>>. >>> >>. >> >.
you don't have too.
[quoted text, click to view] >-----Original Message-----
>Should I delete them? > >>-----Original Message----- >>The disable publishing wizard does leave some metadata >or >>system tables on your server. This is not a problem and >>if you check these tables should be empty. >> >>>-----Original Message----- >>>Hilary, >>> >>>I will be replicating 2 tables. >>>One is currently 341MB and the other is 21MB. >>>I feel like I'm probably better plcaing the snapshot >>>folder on drive with more space... >>> >>>Another question. I was asked to clean up a >>>Publisher/Publication so I ran the 'Disable publishing >>>and distribution wizard.' I believe I'm still left with >>>tables created as a result of the publication. Example >of >>>which are: MSdynamicsnapshotjobs, >MSdynamicsnapshotviews, >>>MSmerge_altsyncpartners etc.. What steps haven't I >>>performed to remove this Publisher, Publication >>>correctly? >>> >>>Thanks again!!!! >>>Anjelina >>> >>>>-----Original Message----- >>>>Its the NorthWest Territories - Northern Canada - >close >>>the Arctic Circle. >>>> >>>>"Hassan" <fatima_ja@hotmail.com> wrote in message >>>>news:uGTtyHAnDHA.2080@TK2MSFTNGP10.phx.gbl... >>>>> How is Dubai and where is NWT ? Is that the >northwest ? >>>>> >>>>> "anjelina" <anonymous@discussions.microsoft.com> >wrote >>>in message >>>>> news:081001c39bce$dca03140$a301280a@phx.gbl... >>>>> > As you can probably guess I'm new to setting up SQL >>>>> > server replication.. >>>>> > >>>>> > I will be setting the Agent accounts under the same >>>>> > account so I won't have to create the folder >>>elsewhere. >>>>> > However, how much space can I anticipate the >snapshot >>>>> > folder taking? I would like to setup transactional >>>>> > replication, but to run at scheduled intervals, not >>>>> > continously, say every hour... The default >location >>>is >>>>> > located on the same drive as the O/S which has >about >>>>> > 600MB of space, do you think that will be >sufficient? >>>>> > >>>>> > Thanks, >>>>> > Anjelina... >>>>> > >>>>> > Did my bachelors at Concordia (about half of my >>>courses >>>>> > taken at the Loyola Campus). Possible I had your >dad >>>as >>>>> > teacher.. 93-96 >>>>> > >>>>> > >-----Original Message----- >>>>> > >I would not use a different folder for the >snapshot >>>>> > unless you have space >>>>> > >issues or you want to optimize the reads by >placing >>>it >>>>> > on a raid 5 >>>>> > >partition. You can use a different folder is you >>>want to >>>>> > use an account that >>>>> > >is not an admin account on your local machine - >ie >>>if >>>>> > you do not want to >>>>> > >give the subscriber SQL Server agent account >rights >>>to >>>>> > access the c$ or d$ >>>>> > >admin shares. >>>>> > > >>>>> > >My father use to teach at Loyola, and my sisters >>>used to >>>>> > work in Saudi >>>>> > >Arabia. >>>>> > > >>>>> > >Good luck. >>>>> > > >>>>> > >"anjelina" <anonymous@discussions.microsoft.com> >>>wrote >>>>> > in message >>>>> > >news:046501c39b99$009ce650$a601280a@phx.gbl... >>>>> > >> Thanks Hilary! >>>>> > >> >>>>> > >> I will be setting them both with the same domain >>>>> > account >>>>> > >> and will give it a go. >>>>> > >> >>>>> > >> Is it recommened to create the snapshot folder >in >>>a >>>>> > >> different location that the default?? >>>>> > >> >>>>> > >> Lived mostly in Montreal and spent a few few >yrs >>>in NB >>>>> > >> when I was small. Now living in Dubai, U.A.E. Go >>>>> > figure.. >>>>> > >> NWT - Yikes - chilly!!! >>>>> > >> >>>>> > >> Anjelina >>>>> > >> >-----Original Message----- >>>>> > >> >If you use all of the defaults and are not >using >>>ftp >>>>> > the >>>>> > >> sql server agent >>>>> > >> >accounts should be the same domain account on >>>both >>>>> > >> servers. >>>>> > >> > >>>>> > >> >If this will not work for you then they could >be >>>local >>>>> > >> admin accounts with >>>>> > >> >the same name and password, or the subscriber >sql >>>>> > server >>>>> > >> agent account >>>>> > >> >should be in the admin group on the publisher, >>>or have >>>>> > >> rights to map to >>>>> > >> >\\publisherServerName\c$ and have rights to >>>access >>>>> > >> c$\program >>>>> > >> >files\Microsoft sql server\mssql\repldata\unc >>>and the >>>>> > >> underlying files and >>>>> > >> >folders. >>>>> > >> > >>>>> > >> >You can always park the snapshot files in other >>>>> > >> locations or create a share >>>>> > >> >on the publisher which the sql server agent >>>account on >>>>> > >> the publisher has >>>>> > >> >rights to map to and access. >>>>> > >> > >>>>> > >> >HTH. >>>>> > >> > >>>>> > >> >BTW - I used to live in Alberta, BC, Ont, and >the >>>>> > NWT :) >>>>> > >> >"anjelina" <ajturner@canada.com> wrote in >message >>>>> > >> >news:05cc01c39ace$853e9f00$a601280a@phx.gbl... >>>>> > >> >> Hi! >>>>> > >> >> >>>>> > >> >> I am going to be setting up replication that >>>will >>>>> > >> support >>>>> > >> >> replication from server in one country to >>>another >>>>> > >> server >>>>> > >> >> in another country both residing in the same >>>domain. >>>>> > >> >> >>>>> > >> >> Do I need to have the same SQL Server Agent >>>account >>>>> > >> >> running under a non system domain account on >>>both >>>>> > the >>>>> > >> >> publisher and subscription servers? >>>>> > >> >> >>>>> > >> >> Thanks, >>>>> > >> >> Anjelina >>>>> > >> >> >>>>> > >> > >>>>> > >> > >>>>> > >> >. >>>>> > >> > >>>>> > > >>>>> > > >>>>> > >. >>>>> > > >>>>> >>>>> >>>> >>>> >>>>. >>>> >>>. >>> >>. >> >.
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |