Find a quiet time when the active portion of the log is at the beginning of the log file. Shrink the log as small as possible. Grow it back to...

Standard edition cannot create compressed backups. It's an enterprise-only feature in SQL 2008 (It's in Standard Edition in SQL...

No. By setting max server memory to 52...

That the log file is not been reused because a log backup is required

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

If you're adding files just to relieve allocation contention, they can be on the same drive. If you're adding files because you have IO contention on TempDB, then adding more...

Please post new questions in a new thread. Thank you.

It's not a DBCC command. Just the ALTER...

tafountain (11/26/2012)

---

On the CPU side I was referring to how SQL Server manages the multiple backup files - my understanding is there is a limit of 1 file per...

It'll work.

Use ShrinkFile, not ShrinkDB and just shrink the files that have lots of free space in them. Don't shrink as small as possible, leave some free space in the...

You don't. It's an MS Access and VB function. Doesn't exist in SQL Server.

Weird.

When you have some time, see if you can dig up a memory test tool, make sure your memory's working properly.

Please don't post multiple threads for the same problem.

No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1388609-149-1.aspx

CREATE PROCEDURE <procedure name>

AS

-- statement one

-- statement two

-- statement three

GO

What specific problem are you having?

Have you installed anything new, any patches, drivers, etc?

Maybe a reinstall of SQL?

Send them the book Anthony mentioned and tell them to read chapter 4, and explain to them that high memory usage is normal and that they should stop telling you...