How many mirrrored databases can I have on a server?
Here are some notes on “SQL Server 2008 Database Mirroring” I took while attending an advanced class
When you state 'processors' do you mean cores or processors? Do I need a 32 processor with quad cores ==> 128 cores or 8 processor with each 4 cores ==> 32 cores?
I use the term "processors" to mean logical processors. It is the number of processors as SQL sees them. So if you have 8 quad core processors, then SQL sees 32 processors. If you have 32 quad core processors, then SQL sees 128 processors.
Ok, clear. Maybe adjust your post to Cores. It makes more sense to people. Then you make a clear distinction between processors and cores.
The following scripts can be downloaded as text files. You will need to change the file extension to .ps1 in order to execute them. Backup a database Restore a database Scan a server to find a free port Query DNS to get the FQDN of a server
To see some examples of my other forms of writing, please visit my page on WritersCafe.org. It is almost exclusively horror fiction, but I sometimes throw other things in there too from time to time. There's one science fiction story, a couple of poems, and quite a few humor pieces as well.
Look for me in the SQL Q&A section of the August, 2007 issue of TechNet Magazine. August issue of TechNet Magazine's SQL Q&A column
