I think it's just bad luck and timing. The active portion of the log was near the end of the file when the log filled and you tried to shrink...

Some people do this. It can help, but it depends. Also, if you recover the database partially, you may have really poor performance if you are missing indexes.

People may move...

+1 to what Gail said. You need to test, test, test. If nothing else, test multiple configurations and compare them.

I don't have a simple, easy solution for you. Anything I give you quick is as likely to break things as help if you don't understand.

If you're a new...

It's possible, but it's not simple. how do account numbers get populated, and then used in other tables? This entire process has to change if you are going to re-use...

you can't do this. If this data is used in joins, you can't do it. you've designed things poorly.

I would agree that you and your boss don't understand encryption.

someone has to see the account number, who is it? And when? Can you change the code that allows them...

I'd tend to say Standard as well. Without the need for Enterprise features, and without a large load you can measure, stick with SE.

stefano.bozzoni (7/22/2013)

---

I totally agree. I guess that the reason why Microsoft is like that is because they have to please shareholders more then clients. Shareholders are amazed and can understand...

It's not clear what you're asking, I think somewhat from the language barrier.

So , as you are saying that I should not provide the key to other user, whom I...

Yeah, that sucks. Was hoping to see Jeter play and climb the hit list. 🙁

Rockies are doing well, getting close to .500 and keeping the (worst) division competitive.

Thanks, I suspected as much since this is a change in features that access the sqlservr.exe.

your post isn't clearly written. You mentioned fibers, but you say you activated them. Did you mean you haven't?

You haven't really given enough information about what is or is not...

I agree. You're need to rebuild the nonclustered indexes on the new filegroup as well.

AlwaysOn isn't just a 2012 feature, it's an Enterprise 2012 feature, so that can be a consideration.

You haven't really defined the problem, Austin, and we can't see your environment, so...