"Hilary Cotter" <hilaryk@att.net> wrote in message
news:uIpE6MRaEHA.3112@tk2msftngp13.phx.gbl...
> there error you are probably getting is because an account or dbuser is
not
> present in the target database.
>
> repeat the copy and post back here with the exact error message you are
> getting.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "Sam" <sam@info.com> wrote in message
> news:10f89dua28ama86@corp.supernews.com...
> > I understand that there is a limitation in windows for compressing 2gb
+.
> I
> > am trying to create an msf by "copying a subscription". As an
alternative
> > method I have tried to copy the subscription database using the "copy
> > database" wizard it gives me an error that is supposedly suppost to be a
> > permissions problem. Has anyone in the group been able to figure out
where
> > the permissions are to be set to copy a database between two servers.
> I've
> > already tried the domain administrator in which both machines are
members
> > of.
> >
> >
>
>

"Sam" <sam@info.com> wrote in message
news:10f89dua28ama86@corp.supernews.com...
> I understand that there is a limitation in windows for compressing 2gb +.
I
> am trying to create an msf by "copying a subscription". As an alternative
> method I have tried to copy the subscription database using the "copy
> database" wizard it gives me an error that is supposedly suppost to be a
> permissions problem. Has anyone in the group been able to figure out where
> the permissions are to be set to copy a database between two servers.
I've
> already tried the domain administrator in which both machines are members
> of.
>
>

"Sam" <sam@info.com> wrote in message
news:10faqndd1576a3d@corp.supernews.com...
> I figured out how to copy a database. Thank you for your help. But the
> original issue was to avoid using the copy subscription method which is
> limited to 2gb. The copy database wizard does not allow me to copy a
> replication database. How do I get a subscription on another machine
without
> using snapshot folders. I loved the msf files because you can manage it
> easily with novice users but like I said before it has a 2gb limit. What
is
> the simplest way to move the subscriptions without a snapshot folder
(merge
> replication)?
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:uIpE6MRaEHA.3112@tk2msftngp13.phx.gbl...
> > there error you are probably getting is because an account or dbuser is
> not
> > present in the target database.
> >
> > repeat the copy and post back here with the exact error message you are
> > getting.
> >
> > --
> > Hilary Cotter
> > Looking for a book on SQL Server replication?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Sam" <sam@info.com> wrote in message
> > news:10f89dua28ama86@corp.supernews.com...
> > > I understand that there is a limitation in windows for compressing 2gb
> +.
> > I
> > > am trying to create an msf by "copying a subscription". As an
> alternative
> > > method I have tried to copy the subscription database using the "copy
> > > database" wizard it gives me an error that is supposedly suppost to be
a
> > > permissions problem. Has anyone in the group been able to figure out
> where
> > > the permissions are to be set to copy a database between two servers.

> > I've
> > > already tried the domain administrator in which both machines are
> members
> > > of.
> > >
> > >
> >
> >
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:uH#hwylaEHA.3692@TK2MSFTNGP09.phx.gbl...
> back up the publication database, copy the backup file to the subscriber
and
> restore it there. Then do a nosync subscribption.
>
> A small snapshot will be generated and distributed to your subscription
with
> procs, triggers, and metadata merge needs to work.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "Sam" <sam@info.com> wrote in message
> news:10faqndd1576a3d@corp.supernews.com...
> > I figured out how to copy a database. Thank you for your help. But the
> > original issue was to avoid using the copy subscription method which is
> > limited to 2gb. The copy database wizard does not allow me to copy a
> > replication database. How do I get a subscription on another machine
> without
> > using snapshot folders. I loved the msf files because you can manage it
> > easily with novice users but like I said before it has a 2gb limit. What
> is
> > the simplest way to move the subscriptions without a snapshot folder
> (merge
> > replication)?
> >
> > "Hilary Cotter" <hilaryk@att.net> wrote in message
> > news:uIpE6MRaEHA.3112@tk2msftngp13.phx.gbl...
> > > there error you are probably getting is because an account or dbuser
is
> > not
> > > present in the target database.
> > >
> > > repeat the copy and post back here with the exact error message you
are
> > > getting.
> > >
> > > --
> > > Hilary Cotter
> > > Looking for a book on SQL Server replication?
> > > http://www.nwsu.com/0974973602.html
> > >
> > >
> > > "Sam" <sam@info.com> wrote in message
> > > news:10f89dua28ama86@corp.supernews.com...
> > > > I understand that there is a limitation in windows for compressing
2gb
> > +.
> > > I
> > > > am trying to create an msf by "copying a subscription". As an
> > alternative
> > > > method I have tried to copy the subscription database using the
"copy
> > > > database" wizard it gives me an error that is supposedly suppost to
be
> a
> > > > permissions problem. Has anyone in the group been able to figure out
> > where
> > > > the permissions are to be set to copy a database between two
servers.
>
> > > I've
> > > > already tried the domain administrator in which both machines are
> > members
> > > > of.
> > > >
> > > >
> > >
> > >
> >
> >
>
>