Viewing 15 posts - 11,371 through 11,385 (of 39,963 total)
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...
March 6, 2014 at 5:13 am
+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.
March 6, 2014 at 5:12 am
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.
March 6, 2014 at 5:09 am
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...
March 5, 2014 at 5:40 am
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...
March 5, 2014 at 5:38 am
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...
March 5, 2014 at 5:36 am
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)
March 5, 2014 at 3:16 am
Thanks, I'll take a look and get you feedback.
March 5, 2014 at 3:04 am
Thanks. I see it, might take a day or two to get to it.
March 5, 2014 at 2:52 am
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 looks like.
I am. Might be slightly longer...
March 3, 2014 at 10:14 am
March 3, 2014 at 9:50 am
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...
March 3, 2014 at 9:29 am
Steve Jones - SSC Editor (3/3/2014)
Going to submit to SQLBits. Gonna be a busy summer, it looks like.
I am. Might be slightly longer in real time as I might interrupt...
March 3, 2014 at 9:25 am
You need to remove replication from this database. If you don't have replication running, the log can't clear.
March 3, 2014 at 9:24 am
Thanks, after about 3-4 weeks, I'll bump this for a reminder
March 3, 2014 at 9:14 am
Viewing 15 posts - 11,371 through 11,385 (of 39,963 total)