|
Home > Archive > MS SQL Server Replication > April 2006 > Restoring a replicated database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restoring a replicated database
|
|
|
| Hi I have a problem where a replicated database has been restored onto a
different server without any replication.
When I try to shrink the log I get the error below
The log was not truncated because records at the beginning of the log are
pending replication
I have tried to detach the database rename the log files and attach with
sp_attach_single_fil
e_db ....but not sure if this does not work because I
have 3 log files...but any advice welcomed...
thanks Sammy
| |
| Hilary Cotter 2006-04-05, 9:31 am |
| If you issue an sp_repldone does this solve the problem?
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Sammy" <Sammy@discussions.microsoft.com> wrote in message
news:7D8DE4FA-1896-43E2-A848- 6384B3FB9027@microso
ft.com...
> Hi I have a problem where a replicated database has been restored onto a
> different server without any replication.
>
> When I try to shrink the log I get the error below
>
> The log was not truncated because records at the beginning of the log are
> pending replication
>
>
> I have tried to detach the database rename the log files and attach with
> sp_attach_single_fil
e_db ....but not sure if this does not work because I
> have 3 log files...but any advice welcomed...
>
> thanks Sammy
>
>
| |
|
| Hi Hilary,
When I issue the following command i get the error below
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time =
0, @reset = 1
Server: Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 1
The database is not published.
"Hilary Cotter" wrote:
> If you issue an sp_repldone does this solve the problem?
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> 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
>
>
>
> "Sammy" <Sammy@discussions.microsoft.com> wrote in message
> news:7D8DE4FA-1896-43E2-A848- 6384B3FB9027@microso
ft.com...
>
>
>
| |
| Paul Ibison 2006-04-05, 9:31 am |
| Sammy,
you might have to set up this database as a transactional publisher to be
able to then run Hilary's command, then remove the publication afterwards.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
| |
|
| Ok I'll try that thanks Paul
"Paul Ibison" wrote:
> Sammy,
> you might have to set up this database as a transactional publisher to be
> able to then run Hilary's command, then remove the publication afterwards.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
| |
| Hilary Cotter 2006-04-05, 8:26 pm |
| or restore with the keep_replication switch and then try it.
--
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
"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:eJFc0TLWGHA.1196@TK2MSFTNGP03.phx.gbl...
> Sammy,
> you might have to set up this database as a transactional publisher to be
> able to then run Hilary's command, then remove the publication afterwards.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|
|
|
|
|