You can do this, though I'd suggest not using a crossover cable and setting up a small hub/switch with a network in between. You might find this makes more sense...

The /3GB switch is only for systems with 4 or more GB or physical RAM. This specifically determines how physical ram is allocated between the user and process spaces.

For all...

I tend to agree with Anders here. I've not seen them stick around.

More, I'd find the connection that is causing the issue and terminate it. The table should disappear. Also,...

you have some pathing problems somewhere.

The way this works is you have an MDF, which stores your data, and an LDF, that stores your log records (track the changes...

Markus has the best advice.

Can you not just send some backups to tape or another disk and then delete them? I typically only keep 1-2 backups on disk.

Ahh, I hate those. Any chance you can open a case with MS? If you have TechNet or MSDN, I think you get some free ones.

This is likely some crazy...

YES!

You should know, but that doesn't mean you get to decide. There's a difference and a storage group needs to have control over their storage. Just as you want control...

That's a good question. I'd open the MS case, since they will need to give you proof anyway.

Love to hear the answer. My suspicion is they'll say it won't work....

This was in administration. I moved it 😉

Can you query the raw data in msdb and see what's listed? sysjobhistory?

Please do.

Also, just to be clear, are you connecting to the actual instances or virtual instances?

Any failover events? Can you double check that

- you're hitting the virtual instances...

If you have 3 separate NICs, you might be able to do this, but my suspicion is that the default instance will bind to 1433 on all NICs.

If this...

As soon as you limit it, someone will come along and ask for more.

You could easily do this with an identity and set a trigger to stop anything after 999....

Sorry, edited my post as well. I think B (using datetime) makes more sense. Include the other int columns if it helps performance.

Can you give an example? Are you using two post windows/edit boxes at the same time?