its unlikely to shrink while there is an active connection, try disabling the account that's connecting and try again. Ensure you are aware of the impact of doing that...

point 2 would only be valid if...

Paul Treston (5/24/2013)

---

Hello there,

I have a database where we have archived and purged 95% of the data, leaving a 230GB file where only 7GB of it is in use by...

Funnily enough I've just had a similar problem but with a local backup path. I had to add the sql ENGINE service account to the backup folder not the...

niladri.primalink (5/24/2013)

---

[font="Verdana"]Hi All,

Yesterday I installed 2012 and trying to know its features. Here I am facing a problem. I am trying to take back up of my AP database in...

Great article! Some really good pointers there!

sqlfriends (5/23/2013)

---

Loundy (5/23/2013)

---

Did you physically install 4 instances (all with different names)? or did you install an instance on node A then add the instance on Node B (for...

Did you physically install 4 instances (all with different names)? or did you install an instance on node A then add the instance on Node B (for both instances)...

Have you tried a different set of binaries? I've had issues before with the binaries I was using so used a different set and it worked ok.

unfortunately downgrade isn't possible.

you could install standard next to enterprise and copy the dbs to it before uninstalling to minimize any downtime, but as mentioned, back your dbs up first...

You need to purge some old data first - whether that is permanently deleting it or moving it to another db...

ROFL - that...

Could you find the inserts / updates for this table and baseline the I/O, execution time for them WITH the indexes in place then baseline WITHOUT. Convert the figures into...

PREEMPTIVE_OS_AUTHENTICATIONOPS could indicate problems talking to a domain controller - not personally experienced this though.

In future versions of sql server the ; will be compulsory after a statement too I believe.