Thanks!!

Currently we are running out of disk space on our c drive, the file size of C:\pagefile.sys is 2.1 GB and I am trying to reduce this size to 1GB,...

In the past I had this issue and increasing the space allocated resolved the issue, also check your disk space.

Uncheck AUTOSHRINK! Autoshrink should not be turned on for any production...

george,

Per your suggestion, just captured the stored proc events and started the trace last night, I was able to capture the stored proc which I was thinking is doing that....

george sibbald (2/22/2008)

---

Mh,

if you are sure you have identified the stored proc altering database the only event you have to capture is stored procedures\sp:completed. This will tell you when the...

Matt Miller (2/21/2008)

---

Mh (2/21/2008)

---

Matt Miller (2/21/2008)

---

I haven't seen this mentioned yet - but the SQL Server log seems to capture changes to the RECOVERY model. I just did that...

Matt Miller (2/21/2008)

---

I haven't seen this mentioned yet - but the SQL Server log seems to capture changes to the RECOVERY model. I just did that and I get...

Since upgrading the existing production db to sql 2005 is not recommended, we are planning to install sql 2005 in a new server and then migrate the sql 2000 databases...

george sibbald (2/21/2008)

---

well if you've got sp_completed and sqlstatement completed (or whatever called - pushed for time here), it should be in there.

run your tlog backups through the night or...

Thanks for the quick response! I am pulling all the events to make sure I do'nt eliminate anything. I can't tie back the tran log backup sql job with the...

I see a stored proc which belongs to the application, that might be altering the db recovery model, So 2 days back the trace was started to run and I...

I think there is one application's stored proc which might be changing the recovery model.

Thanks!!

I checked the date created on the db, it's on 9/24/07. Thx!

Greg Charles (2/14/2008)

---

I have a couple more ideas. Changing the recovery model should be logged in the Windows Server Application log. Look in Event Viewer to see if...

Mike Hinds (2/12/2008)

---

We have a similar plan to what you propose, as our standard for about 60 servers, varying in size from 1/2 GB to 128 GB.

Sun 7:00 pm -...