Steve Jones - SSC Editor (12/11/2010)

---

I've used them, often as a base maintenance setup for systems that aren't stressed or critical. They have worked fine.

However when I need finer control,...

I would say this is not a common task...

snivas (12/10/2010)

---

Version is " Microsoft SQL Server 2005 - 9.00.1399.06 (X64)"

OS "Windows 2003 64 bit SP2

MEMEORYCLERK_SQLBUFFERPOLL

Virtual memory Reserved is :33 GB

Virtual memory commited...

thang_ngo_2002 (12/9/2010)

---

As I said, for some reasons now I don't want to upgrade to SQL 2005 or 2008 so much.

So I think the temporary best way now is install SQL...

I knew that 🙂

Now, if I could only convince the vendor that this job needs to be...

GSquared (12/7/2010)

---

I prefer a bigger job with some custom logging over splitting it up. It makes it more obvious that it's all part of the same sequence. More...

Take a look at this article: http://www.mssqltips.com/tip.asp?tip=2167

I would download and use a tool like WinDirStat to identify what files are using the space. Until you know what files are using the space - you really...

The point is - everytime you restart the server, SQL Server starts without any data in the buffer cache and no plans cached. So, the first time data is...

Lowell (11/30/2010)

---

she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?

if the server was beefy enough...

You need to also realize that the developer edition is licensed by individual - not by server. So, if you install developer edition on a server and have 5...

GSquared (11/30/2010)

---

Batch files from a scheduler is how I'd go about it, except I can't think of any reason I'd ever want to reboot a server on a fixed schedule....

AlexSQLForums (11/29/2010)

---

Thank you.

I was able to recover needed data by creating a different db with same size and replacing the mdf file and than using emergency mode and running...

You don't need to add local system to that right - it is part of the local administrators group already and has that right by default.

Check for any jobs setup to rebuild/reorganize your indexes - that is generally where someone will add code to truncate the log (e.g. BACKUP LOG ... WITH TRUNCATE_ONLY).

Also look for...