I took the first option use the windows authentication

Thanks for the reply. Please let me know how to restore that certificate that was created in another instance.

sure. Thank you

Thank you

Is it mandatory to have windows server 2012 for always on high availability groups or it works in windows 2003 and windows 2008 also. Is there any high availability options...

Thank you. So we can't do anything VLF. It automatically depends upon Log file. What is the usual relation b/n those. Usually we can configure temp db according to the...

Thank you

Actually I solved the problem. Initially some how error log was missed, at that time I couldn't able to connect to the Sql server. Then I created new Log and...

If I use TDE on a database in one instance and did the back up of certificate. But when I am creating certificate, I use only encryption key password only...

If I use TDE on a database in one instance and did the back up of certificate. But when I am creating certificate, I use only encryption key password only...

Actually, I install SQLServer2008R2 developer edition. At that time I configured database mail it works fine to me. After I uninstalled and and re-install the instance again. But this time...

Actually, I install SQLServer2008R2 developer edition. At that time I configured database mail it works fine to me. After I uninstalled and and re-install the instance again. But this time...

Is it possible to insert values in only one column? Actually there are two columns in table they updating only one column what will happen to second