I would not worry about this at all. SQL Server gradually reserves whatever RAM is available to it. This is by design.

Most SQL Servers are dedicated to only being a...

Jayanth_Kurup (7/18/2011)

---

I guess most people would agree with me when I say being a DBA is about on the job experience , it doesn't matter what age you acquire the...

heard.nathan (7/18/2011)

---

Hello -

I'm currently working as a database analyst. I've been working with SQL Server for 2.5 years now, I have experience writing good queries, basic stored procedures, SSRS,...

Very good question. I would say yes. Double is A LOT of money....

calvo (7/13/2011)

---

You would be correct in your assumptions. The MCTS is a pre-req for the MCITP and they have separated administration and development.

Administrative track-

70-432 MCTS: SQL Server 2008, Implementation and...

SQLRNNR (7/11/2011)

Though a big paycheck is nice, I much prefer happiness and family time myself. Within reason, taking a paycut is much more rewarding for myself than to be...

GilaMonster (7/8/2011)

---

That said, are you sure you should be shrinking at all?

Unless the log grew very large as a product of some unusual operation, the size that it is is...

GilaMonster (7/8/2011)

---

JamesMorrison (7/8/2011)

---

I have done this many times without any problem. If you are having an issue, it is likely the exception, not the norm.

It is a well documented process...

I brought it up because that is a perfectly good reason for needing to shink the...

GilaMonster (7/8/2011)

---

Unless the log grew very large as a product of some unusual operation, the size that it is is the size it needs to be for regular operation. If...

GilaMonster (7/8/2011)

---

JamesMorrison (7/8/2011)

---

If that still fails, detach the database, then rename the .LDF file.

Then reattached the .MDF file, but remove the .LDF file from the process. Force SQL Server...

Try putting the database into SIMPLE mode, then back into FULL mode. Then do a full backup and a transaction log backup.

See if your DBCC shrinkfile will work properly.

If that...

In my opinion, it is a combination of the needs of the business and the space limitations you have for the backups.

There needs to be a happy meeting place between...

Wow, that sounds like it could be...

In that case, you need to just...