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...

You could use Powershell here. A job that calls this script and outputs to a filename based on the date.

There's a rename script here: http://ss64.com/ps/syntax-stampme.html

Here's a text file export:...

One big thing would be to move to a stable x64 platform. That was an add-on in SQL 2000, but in SQL2K8 you can easily use more memory, which should...