You need to checkpoint the database(s) before dropping clean buffers. Did you run checkpoint first?

I'm assuming the OP is referring to

DBCC DROPCLEANBUFFERS

Do you have lock pages in memory policy set or any trace flags

Same as any other time. The services go offline so SQL Servers memory...

ramyours2003 (3/6/2014)

---

i have 100 + of tables want to provide select permissions to all the tables which starts with A in a database with dbo is schema ,...

@murali (3/6/2014)

---

Hi

I would like to enforce password policy for non-AD accounts.

when I select enfocre password policy on SQL server it will enforce default policy (minimum 8 char with...

No it's not. Mirroring will...

Grant Fritchey (3/6/2014)

---

It's not about what the 'sa' account has access to. It's about what the account that SQL Server is running under has access to. That account determines what...

The only way SA can access the local...

Thomas Mucha (3/5/2014)

---

I have established that the TCP ports are open and with the command "telnet 192.168.11.xx 5022" I seem to be getting a successful connection via CMD shell.

But I...

Pass through authentication will work but it's by no means secure hence why MS specify certificates.

This link has a complete example on setting up mirroring using certs

You can query to find the date stats were last updated, then initiate a rebuild

ramadesai108 (1/18/2014)

---

Hello,

I searched on the internet for hours but cannot resolve my issue, so this is my last resort.

I have 2 instances of SQL Server 2012 on...

Typically, if you do not have permission on the remote server to stop and start services, you will not see the green arrow indicators.

Which agent is it that will not start, the SQL 2008 R2 instances agent or the SQL 2012 instances agent?