Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it involves...

Sorry for the delay. I typically do what Eric has written here, even back in SQL 2000/7, but I might run 3-4 batches manually at different sizes and time them...

Michael,

Still?

Please send a note to the webmaster and we'll get a ticket open.

We'd be happy to help. What you really need is to post some DDL and sample data so we have a better idea of what you're dealing with. Here are...

+1 to what Gail mentioned. I would't have moved the data to another instance in the first place because of the hassles of moving it back.

Please feel free to mail the webmaster here if you don't get it. Things should be working fine, but the email delivery processes and paths are always changing.

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