Just curious here, do you have some kind of vendor requirement to hard code the port number in the connect string?

SQL Browser listens in on port 1434 and then reconciles...

If you purchased "Software Assurance" with your initial license, then there is no upgrade cost. If not, you have to purcfhase from scratch.

We deal with a lot of 3rd party vendor software here that uses SQL Server as their DB platform. If it were a bigger problem and I didn't have...

Update:

The query in David's first link will return the "Total Bytes Free" in the MemToLeave memory area. (in kb)

PerfMon:

PROCESS - PRIVATE BYTES (Choose "sqlserv" on the right side)

will return...

Thanks,

Just another guess, since the Total Avail changes over time, this could be the total available memtoleave for SQL in the total pool of 512. I saw it dip...

Thanks David, I had seen this blog and ran the script, I just wasn't so sure how to read the output.

Total Avail = 314776

Max free = 51776

An interesting note...

The port number you're using may be the whole problem or it may be the dns name you're using. as the prior post suggest, make sure the port is...

I'm trying not to get caught up in the shoulda, woulda, coulda's but only thinking about any and all possibilities to get the data back.

Maybe there is a copy of...

Just a shot in the dark.... if you have any kind of system level backup you can get your .mdf and .ldf files from...... you could then just...

Actually it was Chris that suggested a couple of alternatives for you.

I have used the Bulk Mode strategy in a production environment and it works just fine.

One caveat, if your...

A rebuild index is minimally logged in Bulk-Logged mode;

http://msdn.microsoft.com/en-us/library/ms191484(SQL.90).aspx

or, option #3, use the bulk mode strategy.

Works for me.

I'd just like to add that having Windows only authentication disables the super 'sa' admin account. That may or may not be a good thing, depending......

The articles rlondon points out are far better than my simple explanation. It would do you a lot of good to read through those thoroughly. we posted at...

When you have a DB in full recovery model, you take periodic transaction log dumps. this process allows you to restore your database to a point in time. ...