Database Restore in Tran replication

Some problem happen from Appliction side & it was brought to my
attention that i have to restore the production database & same
production Database is used for transactional replication. i am not
sure if i restore the database it will break the replication or what
is better way to RESTORE. any help is appreciated & thanking in
advance.
If you restore to an earlier version of the production database, that means
that potentially you'll have non-convergence with the subscribers. You could
then do a comparison with a subscriber and decide which records to upload
from the subscriber, although this could end up being really complicated.
After that, I'd reinitialize the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks for your reply, that is what i thought. thanks for your help
again.

DAtabase Recovery from emergency mode

We had a RAID breakdown that brought around 20 of our
databases each around 100 GB in Emergency mode.
What is the best way to recover the database.
We have tried the method of renaming the database files
and log files and running the following set of commands:-
sp_configure 'allow updates', 1
go
reconfigure with override
go
use master
go
Update sysdatabases set status = 32768 where name = 'TEST'
go
sp_configure 'allow updates', 0
go
reconfigure with override
But when we try to re gendrate the logs it fails with the
DBNETLIB error.
How shoule we procede to recover the databasesrecreate the RAID and attach the databases. There is also a way to reset the database state in the configuration table.
rgn|||The best way is from good backups. If your Raid crashed that hard you can
not be sure of the integrity of the files and restoring from backups is the
proper way to recover them.
--
Andrew J. Kelly
SQL Server MVP
"YOGI.GUPTA@.MAIL.SPRINT.COM" <anonymous@.discussions.microsoft.com> wrote in
message news:019001c3ca6e$92327720$a401280a@.phx.gbl...
> We had a RAID breakdown that brought around 20 of our
> databases each around 100 GB in Emergency mode.
> What is the best way to recover the database.
> We have tried the method of renaming the database files
> and log files and running the following set of commands:-
> sp_configure 'allow updates', 1
> go
> reconfigure with override
> go
> use master
> go
> Update sysdatabases set status = 32768 where name = 'TEST'
> go
> sp_configure 'allow updates', 0
> go
> reconfigure with override
> But when we try to re gendrate the logs it fails with the
> DBNETLIB error.
> How shoule we procede to recover the databases
>