corrupted relations in database

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » corrupted relations in database

corrupted relations in database

Rate Topic

Display Mode

Topic Options

Author

Message

Mr_Q

Posted Wednesday, March 3, 2010 2:57 AM

Grasshopper

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

vidya_pande

Posted Wednesday, March 3, 2010 3:13 AM

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

Adi Cohn-120898

Posted Wednesday, March 3, 2010 3:20 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 2,134, Visits: 5,604

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

Mr_Q

Posted Wednesday, March 3, 2010 3:40 AM

Grasshopper

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 »

Permissions