It's threads which have had a post in the last 24 hours. I think we have some limit, 50,100, something like that for how many get in.

I don't see one around technet, but there is this one.

When you go with mirroring, the logs are moved, which means full recovery mode. If you truncate, you'd break mirroring.

Are you running log backups? You should be doing this to...

no better, in general. I hate to say it, but "it depends"

Do you get better performance on the local v remote? Maybe a SQL IOSIM to test some throughput and...

Or it's removal is coming in SQL 11 :w00t::hehe:

Ah, that button has been there a long time. Part of the editor for the forums.

Where do you see "Local Area Connection"? Isn't that in the control panel/networking?

There is a "Local Server Connection" I see. That typically, I think, uses "(local)" as the connection, which...

I'm torn here. I wouldn't be surprised if he got the job since most candidates can't answer those questions. At least not from the stories I hear.

So do we teach...

closed thread.

Please don't double post.

We are more than happy to help, but we want you to do a little work first. Go research those questions, search in Books Online. If you don't understand something...

New link??!? Ah, yeah...

see, we, ah...

no idea what you're talking about.

but I am glad it's working.

No offense intended, but we are in the "teach a person to write SQL" camp as opposed to the "give them the" SQL camp.

We want you to learn. If you...

First the backups from SQL going to disk and then tape is way more stable and BE. Issues like this are one reason that the agent with BE makes me...

Moe the logical names, not the physical ones.

There's definitely something wrong. Can you backup and restore the source without issues to itself?