Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

corrupted relations in database Expand / Collapse
Author
Message
Posted Wednesday, March 3, 2010 2:57 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 11:25 PM
Points: 14, Visits: 152
hello,

i have a database on sql 2005 server std edition sp1.
in my database, the relation between some table are corrupted.
its ok to rebuild relations between this table with database online on production?

note: the database are transactional replicated, and the downtime must be 0,000001 per year

tks.


G.
Post #875771
Posted Wednesday, March 3, 2010 3:13 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, May 11, 2014 8:07 PM
Points: 891, Visits: 235
Corrupt means? are u getting any corruption related errors? or it has been deleted from the database? .. If it is deleted and if database is subscriber database in transactional replication. I think u can add those again without any impact.


Post #875777
Posted Wednesday, March 3, 2010 3:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:28 AM
Points: 2,114, Visits: 5,502
I’m sorry but I don’t understand the question. Can you clarify it? What do you mean when you say that you have corrupted relations between the tables? What do you mean about rebuilding the relations?

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #875784
Posted Wednesday, March 3, 2010 3:40 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 11:25 PM
Points: 14, Visits: 152
some of the relationships between tables, missing...

I want to rebuild this relation.

The problem is :I need some suggestions, how can i fix the problem, and affect the entire system as less possible.

tkx


G.
Post #875795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse