turning off replication won't help, as this database is published you need to identify the transaction preventing the log truncating. Use dbcc opentran whilst connected to the database to do...

Cindy,

is replication actually set up for the database?

If it isn't follow the workarounds in this thread

http://www.sqlservercentral.com/Forums/Topic509307-146-1.aspx

another workaround is to quickly set up a dummy replication and then remove it.

another question,...

llevity (4/7/2010)

---

I didn't run into any resource db issues in my experiments, but luckily, my sql binaries go to the default c:\... location on all installs.

What a recipe...

Jason Shadonix (4/7/2010)

---

george sibbald (4/7/2010)

---

Jason Shadonix (4/7/2010)

---

Why do you say that? Is there a reason you...

In SQL2008 (unlike SQL2005) you cannot move the resource database, which would mean you cannot run alter database against it

http://msdn.microsoft.com/en-us/library/ms345408.aspx

so it's still up for grabs where this info is held

Jason Shadonix (4/7/2010)

---

--to enable compression

sp_configure 'backup comp', 1

go

reconfigure

go

Just curious but I don't recall reading anything within the TechNet article that mentioned a hierarchy requirement when doing WITH command. Why compression...

Jason Shadonix (4/7/2010)

---

Why do you say that? Is there a reason you wouldn't want to compress...

actually, there is an is_compressed column in msdb..backupmediaset

Jason Shadonix (4/7/2010)

---

I don't have COMPRESSION first in my list of...

llevity (4/7/2010)

---

Interesting discussion, thanks guys!

To answer some of the speculation, yes, this is absolutely just a "What if..." type of practice thing for me. I'm trying to go through...

they have gone to great lenghts to protect it, basically they don't want people touching it, which is fair enough.

I'm not angry. Just difficult to give correct information if I'm not sure what you are trying to achieve and you won't tell me.

Have you tried copying resource files somewhere...

Steve Jones - Editor (4/7/2010)

---

george sibbald (4/7/2010)

---

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the...

this one is on a need to know basis only!

sounds top secret. I'll leave you to it.