The worst case is that it could require more space due to a collation that forces everything to a Unicode comparison based on the data types, but it should not...

Jeffrey has the solution that will probably work best, but you might want to test a couple scenarios out. Ultimately the way your system responds best is what you want...

Wow, that's interesting. I'll ask some people at MS.

Does that 28 days matter if the old primary node then becomes the inactive one? Isn't it OK as long as you always have one node inactive?

I wasn't thinking it was easy for many people. Also, restores are critical.

Shared components are client tools and non-instance aware services. Not all SQL Server services are multi-instance.

My reading of this: http://www.google.com/url?sa=t&source=web&cd=3&ved=0CCwQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F1%2Fe%2F6%2F1e68f92c-f334-4517-b610-e4dee946ef91%2F2008%2520SQL%2520Licensing%2520overview%2520final.docx&rct=j&q=sql%20server%20licensing&ei=g-QxTY3cJcbpgAf0uc3ACw&usg=AFQjCNG-uwJLVzdsMDmXMjfsjof5SGObzA&sig2=apGsuUhzdrjJMzFTMwPWtA&cad=rja

says that passive nodes don't need licensing. this assumes the passive node has <= number of CPU sockets as the active node.

When you say you...

1. Is this the same server name?

2. sp_help_revlogin

3. permissions move. Or are you talking at a server level? You'll need to script these out.

4. script them out

5. save to...

I tend to like scripts for this, instead of a separate program. Especially as you'll start to have multiple versions of things quickly since SQL Server changes rapidly. Scripts seem...

If you have a lot of schema changes, then replication can be a hassle. However, have you considered instead using SSIS and building more of a reporting warehouse? It's...

Are you connecting with SSMS? You might be using that one connection in the Object Explorer

Use SQLCMD for your one connection from a different command like window.

Congrats!

Brian is correct. The tool is using credentials (current or RUNAS ones) so there is no need for a login.

This should depend on how the SAN vendor has implemented the snapshot. They may be integrating with SQL Server.

However I'd let them know if they are marking the snapshot as...

I believe this is because the OR clause doesn't mean you are selecting how many rows out of tablA match, but rather you are making two comparisons. The 3 rows...