March 3, 2010 at 2:57 am
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.
March 3, 2010 at 3:13 am
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.
March 3, 2010 at 3:20 am
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/
March 3, 2010 at 3:40 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply