If you can connect to the server with the SA account, login to the Server and grant your Windows user the rights you want it to have on the SQL...

Did any of the tips help you?

Sapen, Could you please tell me what was causing the errorlog to become 35GB. When was the SQL Server Service restarted from the last time. By the way you should...

Ninja's_RGR'us (10/10/2011)

---

Ignacio A. Salom Rangel (10/9/2011)

---

Ninja's_RGR'us (10/7/2011)

---

Personally I'd just rather give them access to a test server and restore the latest copy of prod.

Any reason you can't go that route?

If...

Could you check if there is any other job thta may be rebuilding the indexes at the same time. You can try changing the schedule for the job. I had...

Ninja's_RGR'us (10/7/2011)

---

Personally I'd just rather give them access to a test server and restore the latest copy of prod.

Any reason you can't go that route?

If that's not an option I'd...

Could you please let us know how did you solved the problem? Did you restore a backup or did you try to recover the database?

sqlbuddy123 (9/13/2011)

---

SQL Server will try to use all the memory (64 bit) if you don't limit its usage by using Max Memory.

Good practice on dedicated SQL Servers is to set...

sqlbuddy123 (9/12/2011)

---

I never meant to set Max Memory to be equal to the total memory on the box. You need to set something like Max Memory = (Total Server Memory...

Jeff Moden (9/12/2011)

---

Ignacio A. Salom Rangel (9/12/2011)

---

I agree with Jeff. I always though that setting max memory was bad practice! Could you please provide a link to a Microsoft article...

Thanks for your reply!

GilaMonster (9/12/2011)

---

You almost must set max server memory on a 64-bit server, with that left at default (2000 terabytes or so), SQL can and will take all the memory on...

I agree with Jeff. I always though that setting max memory was bad practice! Could you please provide a link to a Microsoft article that supports what you said. I...

Glad to hear you solved your problem and thank you for sharing!

GilaMonster (9/5/2011)

---

With the exception...