Well, this seems to back up what I found: http://www.pythian.com/blog/are-you-switching-to-bulk_logged-recovery-model-know-your-risks/%5B/url%5D although with the recommendation that you *HAVE* to take a TLog backup IMMEDIATELY after you finish the bulk operation and...

OK, where I work, it seems that when they were remodelling (before I started) they "fixed" the air conditioning...

As in, one of the old hands stated where I'm sitting used...

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio button...

Where I work, we're going to get double-whammied next week I think...

People have taken next week off, plus (being govm't) we've got people starting their mandatory furloughs because of sequestration...

Except...

Lynn: Stay safe!

Everyone else: Did everyone (in the US at least) start their July 4 weekend early? Sheesh...

Nothing in here since ~5:30am and that from someone I...

I believe that yes, you would need to run a full backup of the recently restored DB in order to "re-start" the log chain for it.

If you're going to restore...

Stefan Krzywicki (6/26/2013)

Fal (6/25/2013)

I put mine in the oven.

And sometimes I accidentally do one when I put it through the wash...

Brandie Tarvin (6/25/2013)

Blasphemy. Sheer Blasphemy.

Someone take away his golden SysAdmin key. Expel him from the ranks of the...

Uhh, with this:

DBCC SHRINKFILE('WBT', 150000)

😉

(Yes, I know everyone is kidding around, and it's not something I intend to do regularly...):-D

My thanks to Gail!

With her clarifying a few things for me (such as SQLs usage of multiple transaction log files) I was able to run a compression, shrink, clustered index...

Likely if you don't think you're using it, you're probably not (Filestream that is), but easy enough to check:

exec sp_configure 'filestream access level'

If the config value is 0, then Filestream...

OK, I don't know if this might help, but I found a similar issue elsewhere:

Link to topic

Yes, it's from 1999 and concerns Sybase, but it sure sounds like a similar...

Excellent, thank you!

(So my bucket analogy was close, except the buckets are also on an escalator getting emptied out eventually and recycled to the bottom... 😉 )

Once more, thanks!

Jason

OK, I might have a solution to this, if what I've heard is correct:

Lets say I have a DB with two log files, lets call them log A and B,...

OK, thanks.

Sounds like I won't be compressing this index / table any time soon then, as using the current size of the index as a guideline I don't believe we've...