What's the edition and service pack of the sql server?

Is your distribution cleanup job working? Or do you have anonymous subscription enabled? It looks like your old data in msrepl_commands and msrepl_transactions are not being cleaned up.

What's your...

GilaMonster (11/4/2008)

---

Lynn Pettis (11/4/2008)

---

Don't simply truncate the transaction log. You will break your log chain, and won't be able to do a restore to a point in time. ...

Lynn Pettis (11/4/2008)

---

Sanjay Rohra (11/4/2008)

---

sudeepta.ganguly (11/4/2008)

---

One of our database writes huge logs as as we have created a Transactional Replication on that. I was trying to automate the process of...

I'd put in a 5 GB increment for a 75 GB data size. Small increments would lead to frequent growths. Pre-allocate the data with the right size, depending on the...

What you did only truncates the virtual log file, a shrink would then reduce the physical size.

From BOL: "Log truncation does not reduce the size of a physical log file,...

Is this "server/lan administrator" you're referring to a local account?

Just wanna make sure you're using a domain account to login which has proper permissions on the shared folder. (as...

What's your error message?

or

try this id with hyphens = 'B3AE1271-2686-40F8-9A50-50C611B771B9'

You may also want to check eventvwr.

It ran under your account when you manually fired it. But when it is run as scheduled, it uses the sql agent startup...

"For some of the queries forcing the right index works but for some it still doesn’t use the forced index."

Did you mean using index hints on some queries yet...

I assume the log shipping monitor does not get the correct backup dates.

In log_shipping_primaries table, check if the primary_server_name column has the same value as when running SELECT @@SERVERNAME.

Do the...

It happened to me also, I'm not sure if there is a...

I hear you. And excluding a database from a backup just simply blew that feature away.

Thanks for the input guys. I hold it off making changes for now. There are just some handful of servers that seems to be not in our total control...and they...

How about increasing the size of your job history log..