I try and reply to stuff I have experience with because I've learned a lot from this site, also...a sort of "pay it forward" type of thing.

<soapbox>

If everyone acted this...

Yeah, we're on the same page. But a couple of things:

If you like, you can test your failover by issuing the 'SET PARTNER FAILOVER' command on ServerA, instead of...

The first command:

ALTER DATABASE [yourDatabase]

SET PARTNER FAILOVER

GO

should be run on your current PRINCIPAL (which is your desired MIRROR, if I understood correctly). It will set your primary instance back...

Search on 'default database' and 'initial catalog'.

If I'm understanding your question correctly:

To set your primary instance back to being the PRINCIPAL, issue the following command:

-- http://msdn.microsoft.com/en-us/library/bb522476(v=sql.100).aspx

ALTER DATABASE [yourDatabase]

SET PARTNER FAILOVER

GO

To change the timeout setting:

ALTER DATABASE [yourDatabase]

SET...

The link takes you to the SQL Server 2012 entry, it just doesn't tell you that very well. Look on the left hand navigation hierarchy, it shows 'Books Online...

Sounds a lot like a typical Giants game. I'd pinch run for Posey on first with Blanco (the speedy jack rabbit) and let Pill pinch hit for Huff. ...

1. I'm using the 'zBench' theme. I wish I could find one that I could make do what I want and not look like everyone else. And of...

Got it to accept the dynamic connection string using the above layout but didn't think past that. The Maintenance Plan tasks are asking for more than just a connection...

Grats Steve, sounds like fun. Tell anyone who asks about the lip that you were in a bar fight and that they should see the other guy. Then...

Markus (4/19/2012)

---

I heard an interesting stat last night.

Jamie Moyer pitching for the Rockies and got the win and with that win he became the oldest player ever to win a...

Thanks, learned something new.

Thanks Jerry. Indeed, I did not register the database first as a data tier application then try and upgrade it. I kept reading the same areas in BOL...

I snooze, I lose!

I'm just glad it got written. Take all the feedback with an open mind, it'll only make you better in the long run.

Giants start out 0-3, starting pitching gets rocked and the bats are talkin'....weird opening weekend for SF. At least the Yankees and Red Sox are in the same boat.

Steve,...