Thanks for the question..hurray I got it correct...but only after reading explanation about it in BOL...I never heard about it before...but its a very useful function...

Yes..the explanation given by OP...

Good question....learnt from it...tnx

hmmm...good lesson to learn....

and how did you reconised keyboard's setting? Did you typed your 'sa' password on notepad or something?

Your language is little confusing...what I understood is you have taken backup 2 days back and now your system is crashed...

In this scenario..You will be able to restore the DB...

Paul..can you give some link to read on this?..I am not aware of this..need to gain more knowledge on this concept.

Not sure how you guys suggesting mirroring...as per my understanding mirrored DB is not accessible (till failover) .....how that can be used for reporting?

tke402..

run below command on your replicated DB

EXEC sp_change_users_login 'Update_One', 'UserName', 'LoginName'

Theory:

When you restore DB only users are replicated not Logins....that is one of the reason of Orphaned users in the...

Gail Thanks for the link..I will read it completely and will post if I have any doubts...

Yup..its 24x7 prod box...so cant restart services very often...

There is maint plan which does tasks like update stats, reindexing etc...at that time only tempdb grows....

sp_who2 shows some INSERT command on...

I dont have Cluster server with me as of now...but I guess you should able to get this info in Cluster Management Console..or in event logs

Login to your Cluster (Virtual Server) and type hostname at command prompt.

Hi Colin..Thanks for your reply

I know the fragmentation impact and thats my worry at the moment....I had already suggested to have system databases on different drive(currently one user DB ~...

As per my understanding and exp one should never modify any system objects...if you really wish some modification why dont you copy the code of system SP to new SP...

why all CAPS???????