Could you expain me how to restore a masterkey?

I mean, after restoring the database, we need to restore the masterkey? what is the order of restore like database 1st &...

Thanks,

In which case or when excatly we need this backed up master key to restore?

Thanks

Could you please advice me how to backup the master key for each database?

I would like read this article but there is NO ARTICLE in that link. If anybody already been saved this article, then please email me to pshaship@hotmail.com

http://www.sqlservercentral.com/articles/Clustering/65968/

Thanks

please advice me on sql server 2008 r2 installation in a clustered environment (Windows server 2008 R2)of having mount points.

I did not any documentation oon this topic. I appreciate your...

My requirement is to have...

Could you please advice me on this?

Thanks

I tested restoring the full backup again and mirroring is working fine.

So restoring t-log backup is NOT a MUST requirement

Thanks

Could you please advice me whether we need to enable named pipes or not for SQL Server hosting Share Point 2010 databases?

But, we do not have much control to separate data files log files while creating databases from...

Issue resolved:-)

Reason for the issue:

The SQL Server service account abc\mssqlsrv did not exit in logins on both Principal & Mirror

Solution:

Add the service account in logins on both the servers and...

we have 100 90 databases and out of them 20 should be in FULL recovery. Is there way to set this in single step?

Thanks for the links.

Below are the error messages from the errorlog

On Principal server's error log:

Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly...

No. ABC.COM is NOT the actual domain. I have replaced my actual domain name with ABC while posting in the forum.

Thanks,

I have created the trigger as below and I'm getting the email once the database is created. But I'm looking to get an email

before the users attempts to create...