Hi Anthony..thx for responding...I just want to know Does it Lock the Data\Database if I Actually run any Query while Running CHECKDB

Thanx for you responses Gail..you are a Great Help Dude... I still need to know the Steps \Queries how to recover the Files from Point 2.

Gila lets take a Scenerio :

There are 3 file groups for My db

Primary

Secondary

Log

Point 1.Now in case Anything goes WRONG with my Primary File Group ..then we need...

OK thanks for your Answer.But as you been very precise I would like to elaborate the Answer Kindly Confirm and Correct me in Case I am Wrong somewhere kindly correct...

Yes Lynn I do have the back up ..but My question is is there a way to just recover the certain 2 files without doing all the restoration process of...

Thanks All for your Clear and Wonderful Answers

Thanks both of you ...I just wanted to know the exact reason y do we need to do this .

Would try the same as Advised .

Thanks again .

Y do I need to restore the complete database Y cant I just restore the LOGS backup Post Rebuilding the Indexes.

That would be the same scenerio isnt it.

Atlast you need...

what alerts have you missed?

Logshipping Alerts

how are they configured?

Logshipping Configurs automaticaly

where do they pick up the email address settings from?

Thats What I want to know

do all alerts...

Great thanks Anyways you were really Helpful:-)

I have posted one more issue in case you can help please it would be Great .

http://www.sqlservercentral.com/Forums/Topic1301523-1550-1.aspx

Thanks Again

r u Available on CHAT ..

Would like to learn some more from you .

can you help me more where and how can I add my name in that List Please Suggest

Is it Possible if I Stop the Log Backup ,Copy Back and Restore Backup while I perform the Rebuild indexing Activity .

And Then If

1.I actually run the rebuilding...

are the primary and secondary servers the same spec? especially in terms of drive sizes?

Yes The Configuration is Exactly Same .

Do you think that rebuliding index can cause Sync issue...