If you commit after every row, it will run slower, but it also allows you to manage your log size. If it's one big commit, it's one big transaction that...

There isn't necessarily a list of daily/monthly/weekly tasks for all environments. The list you have is a fine place to keep track of your systems. If you are looking for...

Gail is correct. You cannot move a file or filegroup between databases.

SSIS can help you, or T-SQL, in transferring data over. If you have Enterprise and can snapshot, or just...

Ed Wagner (3/3/2014)

---

Steve Jones - SSC Editor (3/3/2014)

---

Ed Wagner (3/3/2014)

---

Steve Jones - SSC Editor (3/3/2014)

---

Steve Jones - SSC Editor (3/3/2014)

---

Going to submit to SQLBits. Gonna be a busy summer, it...

Thanks, I'll take a look and get you feedback.

Thanks. I see it, might take a day or two to get to it.

Ed Wagner (3/3/2014)

---

Steve Jones - SSC Editor (3/3/2014)

---

I am. Might be slightly longer...

Try this: http://blogs.msdn.com/b/repltalk/archive/2010/11/17/how-to-cleanup-replication-bits.aspx

Yes, replication may be the rest for log growth. If replication was set up, and you have publications in this database, and replication was just let go, with subscribers turned...

I am. Might be slightly longer in real time as I might interrupt...

You need to remove replication from this database. If you don't have replication running, the log can't clear.

Thanks, after about 3-4 weeks, I'll bump this for a reminder

Going to submit to SQLBits. Gonna be a busy summer, it looks like.

If you're trying to save money on licensing, I don't believe you an upgrade. However you can purchase 2012 Standard and "migrate" to this version.

Read through Gail's article. We can't see your...