Thanks. Another question.So i am looking to setup always on high availability for DR and reporting purposes.So, i can take all access of users from Production and point it to...

Thanks! So DB mirroring won't work? If not, what would be the option with DB Mirroring.

Thanks. That answer my failed logins question. I never realized error log entry is happening through failed login settings.
Yes, i am looking for total hits against user on a...

Thanks! I can see the auditing option as failed logins enabled. That is the reason the SQL Server error log has failed logins activity? However, i am still trying to...

Thanks Sue! There is no audit configured. Are saying if i configure the server level trigger would that audit all the hits from the users against particular database?

Sorry i wasn't clear. I was referring to AlwaysOn FCIs.

Any thoughts using SSIS to load multiple tables?

Thanks!

Sue,
So the idea is to setup 2 node clustering i.e Active/Passive. Can you elaborate how does the two node cluster will fulfill the Redundancy and DR option. You mean...

:-). I like replication. However, i need to setup clustering(Active/Passive) on 2 nodes, need help on list of things i need before setting up clustering. However, if i setup DR...

Thanks Sue! Have you worked on Clustering setup?

Thanks Sue! I see the performance is Excellent right now. However, i checked the warning threshold which is default 30 secs. Does it mean replication is running 30 secs behind...

Thanks. What happens when developer drop and recreate the object. Do you have to Grant execute to the role again?

Ok.I found the problem is that developer is dropping and recreating the store procedure. He says that he is routinely drop and then recompile procedures. I suggested it is not...

Error log does not have any information for the DBCC shrink. Also, i  looked at the trace files in the error log directory and those trace files does not have...