POSTING IT AGAIN TO RESOLVE THE ERROR

Hi,
When i use the "sp_copysubscription" procedure, i am getting the following
error.
"Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line
64
The subscription(s) to Publisher 'CNS_SQL1' does not allow subscription copy
or it has not been synchronized.".
My subscription datbabase contains only PULL subscription.It worked
previously and now started to give the above error.
Any help would be appreciated?
NOTE:
I do have anonymous pull subscription.
Copy subscription was working earlier and it is not now.
How to enable my publication for the copy subscription option?
Thanks,
Vijay
just for kicks, lets try this, go to your subscription database which you
pulled using anonymous authentication. Run the merge agent until it stops or
stop and start it until it goes idle, then stop it again.
Then start up profiler to trace the commands.
Then right click on your database in EM, select all tasks, and copy
subscription database. Does it work now? Does profiler give a different set
of parameters than what you are using?
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
"Vijay" <vijay@.infosysusa.com> wrote in message
news:%23L$h4jWNFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When i use the "sp_copysubscription" procedure, i am getting the following
> error.
> "Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line
> 64
> The subscription(s) to Publisher 'CNS_SQL1' does not allow subscription
copy
> or it has not been synchronized.".
> My subscription datbabase contains only PULL subscription.It worked
> previously and now started to give the above error.
> Any help would be appreciated?
> NOTE:
> I do have anonymous pull subscription.
> Copy subscription was working earlier and it is not now.
> How to enable my publication for the copy subscription option?
> Thanks,
> Vijay
>
>
|||No, it doesn't work. I couldn't find any difference in the trace also.
..
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ewB10weNFHA.2136@.TK2MSFTNGP14.phx.gbl...
> just for kicks, lets try this, go to your subscription database which you
> pulled using anonymous authentication. Run the merge agent until it stops
or
> stop and start it until it goes idle, then stop it again.
> Then start up profiler to trace the commands.
> Then right click on your database in EM, select all tasks, and copy
> subscription database. Does it work now? Does profiler give a different
set[vbcol=seagreen]
> of parameters than what you are using?
> --
> 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
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:%23L$h4jWNFHA.1172@.TK2MSFTNGP12.phx.gbl...
following[vbcol=seagreen]
Line
> copy
>
|||what happens if you reinitialize, and resync. Can you do it now?
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
"Vijay" <vijay@.infosysusa.com> wrote in message
news:edD4fDhNFHA.3788@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> No, it doesn't work. I couldn't find any difference in the trace also.
> .
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ewB10weNFHA.2136@.TK2MSFTNGP14.phx.gbl...
you[vbcol=seagreen]
stops[vbcol=seagreen]
> or
> set
> following
> Line
subscription
>
|||Hi,
I reinitialized and resync it. It doesn't help.
Any other ideas?
Thanks,
Vijay
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxnXX2iNFHA.2556@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> what happens if you reinitialize, and resync. Can you do it now?
> --
> 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
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:edD4fDhNFHA.3788@.tk2msftngp13.phx.gbl...
> you
> stops
different[vbcol=seagreen]
sp_copysubscription,
> subscription
>
sql

Posting again as i had no reply : Moving dbs

Is there a way that one can detach/move a database that is in norecovery or
standby state thats awaiting more T-logs to be applied and then attach/bring
it
back in the same state and continue with T-logs restores ? I know one can
detach a nonrecovered/standby database but while attaching it it recovers
it... and
that what i want to avoid.
Any way to modify some system tables (sysdatabases) to achieve this. Any
help would be much appreciated. Using SQL 2000.Not that I can see. I had a couple of tries at this but I see no documented
way to do it. As you rightly say, FOR ATTACH recovers the database. I guess
you could probably do something with the status but I would not recomend
hacking the system tables.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OPA7f$$cDHA.2416@.TK2MSFTNGP09.phx.gbl...
Is there a way that one can detach/move a database that is in norecovery or
standby state thats awaiting more T-logs to be applied and then attach/bring
it
back in the same state and continue with T-logs restores ? I know one can
detach a nonrecovered/standby database but while attaching it it recovers
it... and
that what i want to avoid.
Any way to modify some system tables (sysdatabases) to achieve this. Any
help would be much appreciated. Using SQL 2000.|||All I would say is that it would probably be unsupported should you
encounter any issues so you're on your own. If this is a production
environment I would strongly recomend against it.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%237mkvdJdDHA.2804@.TK2MSFTNGP11.phx.gbl...
I tried to do this and was successful. It does involve hacking sysdatabases
. But am also hesitant as I am not too sure what the future holds. It works
fine now...But would hate to see some error later down the line
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ucdZNaIdDHA.1128@.tk2msftngp13.phx.gbl...
> Not that I can see. I had a couple of tries at this but I see no
documented
> way to do it. As you rightly say, FOR ATTACH recovers the database. I
guess
> you could probably do something with the status but I would not recomend
> hacking the system tables.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OPA7f$$cDHA.2416@.TK2MSFTNGP09.phx.gbl...
> Is there a way that one can detach/move a database that is in norecovery
or
> standby state thats awaiting more T-logs to be applied and then
attach/bring
> it
> back in the same state and continue with T-logs restores ? I know one can
> detach a nonrecovered/standby database but while attaching it it recovers
> it... and
> that what i want to avoid.
> Any way to modify some system tables (sysdatabases) to achieve this. Any
> help would be much appreciated. Using SQL 2000.
>
>