You can't take a T-Log backup if your database is in Simple recovery mode. So, basically you can't do point in time restores. In other words, The earliest point you...

BTW, here is the KB article on how you can do that...

http://support.microsoft.com/kb/2019698

Hi Rod,

T-Log logging works the same way in both Enterprise Edition(Most expensive) and Express edition(Free of cost). All the same rules apply to T-Log management irrespective of what edition you...

Yeah.....It's buggy sometimes. Did you tried refreshing your IntelliSense local cache? You can do that from Edit->Intellisense->Refresh local cache.

Also, patch your SSMS to the latest build. If you are not...

Make sure path exists and retry your operation by opening your SSMS with "Run as Admin".

Perry Whittle (2/20/2014)

---

muthyala_51 (2/14/2014)

---

I am facing the following issues while setting up alwayson.

1) Not able to set the listener to the alwayson group. Error--

The WSFC cluster could not bring...

If they are Windows logins, nothing to worry...Windows got you covered. SID remains same.

You can't update the database when the database is in Standby/Read-only mode.

BTW, As long as the SID for Logins in your primary and Secondary Server are same, you should be...

Yes, You need a Quorum for your Windows cluster to be functional. No Quorum => No Cluster to keep it very simple.

Please see below post where Perry explained Quorum models...

Agree with George...

msdb..sp_update_job @job_name = 'Job Name', @enabled = 0 will disable the job, but the respective job schedule will be untouched. By this, the job wont run as scheduled,...

Close your SSMS and try reopening it as an admin. Don't click on connect. click on new query and then connect. This should work...

Is it throwing the same error message...

When you start an instance of SQL Server in single-user mode, SQL Server Management Studio can connect to SQL Server. Object Explorer in Management Studio might fail because it requires...

while using SSMS, IIRC Object Explorer is treated as a separate connection and query pane as a separate connection. Disconnect from Object Explorer and try running your query and see...

In Place Upgrade from SQL Server 2008 R2 SP1 Developer -> SQL Server 2012 Enterprise - Not Supported.

In Place Upgrade from SQL Server 2008 R2 SP1 Developer -> SQL Server...

Well, you should see this as well in that case 🙂 Below are the lines from the same Brad in one of his technical articles in SimpleTalk.

"One of the most...