Those are small amounts of memory usually, few...

What times do you have log backups from?

VastSQL (6/16/2016)

---

k2000.rajesh (6/16/2016)

---

can you guide me how to recover the data

The full back up was taken at 7:00 AM

Users did the work till 4:30 PM

Records were deleted at 4:45 PM

I...

The application will request memory, windows will ask SQL to reduce memory usage, SQL will reduce.

Better would be for you to go and set max server memory slightly lower to...

Nope, those are for when you're moving a database without data loss or a database...

ztoddw (6/15/2016)

---

But there is a ton of unused space now, and it still won't shrink! (I just barely tried it again.) Even when I check the box for...

ztoddw (6/15/2016)

---

So it still thinks the trans log backup is still happening? I left that backup running last night and it showed backup successful this morning and I clicked...

You can call it that, yes.

The what edition? Where does 'breadth' come from and in what context? It's not an edition of SQL

No page has that ID (resource DB would be 32767:1:XX). Could be referring to an entry in the metadata, but not sure.

Yes, that will insert successfully, and that's the correct, expected behaviour.

You've defined the primary key on two columns, therefore the combination of the two has to be unique, not the...

And example of duplicates that succeed? Because

INSERT INTO C (V, CT)

VALUES ('1234567890', 'aa')

GO

INSERT INTO C (V, CT)

VALUES ('1234567890', 'aa')

GO

Msg 2627, Level 14, State 1, Line 5

Violation of PRIMARY KEY constraint...

It'll break your recovery process and leave you unable to restore to point in time until another full backup is taken. Won't break mirroring, but that may be a small...

Bear in mind that the majority of SQL's memory won't belong to any session, it'll be the data cache and the plan cache

Y.B. (6/13/2016)

---

works in Chrome just fine, not so much with IE. Yes, I still need to use IE for testing purposes from time to time...don't hate me for it....