You need to make sure that the port for the endpoint is not already being used. So on the same server, use a different port for each endpoint.

Only 1 thing...

Yes, you just need to make sure each endpoint on the server is using a different port (or different IP address).

Why is the other using a named instance? Is there another instance on the same server? If so, does it have a mirroring endpoint as well? The endpoint and IP...

Amen to that. And in my...

Microsoft still recommends 1 data file per CPU, unfortunately. And they will continue to recommend this as long as they are able to produce tempdb contention with less than 1:1....

Perry Whittle (8/7/2012)

---

Hernán Rojas (8/6/2012)

---

The tempdb can only have 1 filegroup so no you can't put 8 files into 2 different filegroups. The recommendation now is files equal to 1\4...

To get real performance benefits, you need each LUN to be on completely separate disks. Bad disk/SAN design can very easily negate the benefits of multiple LUNs.

If the SAN/disks are...

GSquared (8/6/2012)

---

The whole idea is to maximize bandwidth that can be used to read/write in tempdb.

....

Same for multiple files. It will often create zero advantage to have multiple...

Recovery pending means that it waiting an attempt to recover a file, not the it tried to recovery the file and failed.

Thanks! databases and endpoitns look good. Are you following all of the steps for preparing the database?

Restoring the full backup and a log backup? Are you using T-SQL to set...

Please provide the information requested or we won't help you. Those screenshots showed me a little of the information. The mirroring dialog would have been helpful except you scribbled out...

Go through the set up process again. If you get an error, post the exact error message and show us screen shots of both databases.

If you can do it, that's the option I would go with.

Of that won't work, there's full restore or run checkdb with repair (last option) and reinsert lost data.

Do you have backups sufficent to perform a page-only restore? You'll need a full and log backups.

Well done!