Mirror Operating Mode change problem

I am unable to change the mirror operating mode on a test database mirror I have set up. I installed (from MSDN) the RTM SQL 2005 Std Edition and applied SP1, then set up a mirror, which works fine but only on High Safety mode. I want to use High Performance mode, but the operation mode radio buttons are greyed out for me in the mirror properties page. Also, I tried running:

alter database TestDB set safety off

and recieve the error:

Msg 1473, Level 16, State 6, Line 1
This SQL Server edition does not allow changing the safety level. ALTER DATABASE command failed.

Are the various mirror modes not supported on the Std edition or am I overlooking something?

Thanks.

From the db engine server properties:
Product: Microsoft SQL Server Standard Edition
OS: Microsoft Windows NT 5.2 (3790)
Platform: NT INTEL X86
Version: 9.00.2047.00

In STD saftey can only be FULL.

Thanks,

Mark

|||I was hoping this wasn't going to be the case when mirroring became fully supported in sp1. To me it doesn't make sense to give the standard edition only synchronous which requires far more resources and infrastructure. Even microsoft's own best practices suggest you should try mirroring in asynchronous form in a production environment before you transition to synchronous to make sure your infrastructure can support it. For us that just killed 90% of the scenarios we were considering using mirroring for.|||

Asynchronous mirroring is fully supported in Enterprise Edition.

Simply upgrade your installations to Enterprise Edition, and you will have your scenarios back. Yes, it costs more, but as you have found out that asynchronous mirroring has a lot more benefits as far as disaster recovery and high performance workloads. It was natural to put it in a higher SKU.

Thanks,

Mark

|||Unfortunately that would cost a few tens of thousands of dollars. I guess my point was that if you're running the kinds of machines that are needed for synchronous mirroring chances are you won't be using standard edition anyway. I'm not trying to criticize, just letting you know that cost-benefit wise it's not even close for us and I would venture to guess for a lot of other people.|||

Understood. It's always about money, isn't it?

It all depends on the workload actually. If you have a moderate workload, and the systems are right next to each other, then synchronous mirroring will probably be OK. I have plenty of customers running like that now; in fact over half of my internal customers were synchronous at SP1 ship, and not all of them had huge powerful servers.

Thanks,

Mark

|||

Lol, yeah that's why I hate talking to hardware vendors, they only have one answer to any question.

I may look into syncrhonous mirroring more. I tried it with 2 of our test servers and it was less than stellar but I admit I didn't do any full blown application testing. Thanks for the feedback!

sql

Minimum Install MSI for SQL Server 2005

Off of the MSDN SQL Server 2005 Enterprise Edition, what is the MSI I should use to install SQL Server 2005.

I have to Upload all files to a server, and this is going to be painfully slow. Can anyone tell me what the minimum is to upload and install SQL Server Enterprise (not Express)?

(For 32 and 64 bit non-Itanium machines)

That partially depends upon what functionality you intend to install.

MSSQL SSIS AS NS BIDS SSMS Other Client tools|||MSSQL
SSIS
and Reporting Services.
|||

Calling the MSIs directly is not a supported install method. You need to go through setup.exe to install the product.

Thanks,
Sam Lester (MSFT)

|||Does this mean my only choice to get these set up is to upload the entire 985 Meg on each and every server I need to install this on?
|||

Nope, you don't need to copy the files to each machine. You can copy it to a network location and run that install from each machine or you could insert the cd/dvd's into each local machine. The most common approach is probably to copy it to a network share and run the setup.exe from there.

Thanks,
Sam

|||If you have Dedicated Hosted Internet Servers, what are the options?

I don't have physical access to the machine. And I don't have access to an internal Microsoft network to create a Network install.

This is for an Internet Service Provider that is hosting the machine, and our access to it is primarily through Remote Desktop, and FTP.

Can one do a Network Install, and then copy up a smaller file signature to the hosted server?

Otherwise I'm looking at a 800Meg + Upload for EACH machine I need to install this on.
|||** bumpsql

Minimum Install MSI for SQL Server 2005

Off of the MSDN SQL Server 2005 Enterprise Edition, what is the MSI I should use to install SQL Server 2005.

I have to Upload all files to a server, and this is going to be painfully slow. Can anyone tell me what the minimum is to upload and install SQL Server Enterprise (not Express)?

(For 32 and 64 bit non-Itanium machines)

That partially depends upon what functionality you intend to install.

MSSQL SSIS AS NS BIDS SSMS Other Client tools|||MSSQL
SSIS
and Reporting Services.
|||

Calling the MSIs directly is not a supported install method. You need to go through setup.exe to install the product.

Thanks,
Sam Lester (MSFT)

|||Does this mean my only choice to get these set up is to upload the entire 985 Meg on each and every server I need to install this on?
|||

Nope, you don't need to copy the files to each machine. You can copy it to a network location and run that install from each machine or you could insert the cd/dvd's into each local machine. The most common approach is probably to copy it to a network share and run the setup.exe from there.

Thanks,
Sam

|||If you have Dedicated Hosted Internet Servers, what are the options?

I don't have physical access to the machine. And I don't have access to an internal Microsoft network to create a Network install.

This is for an Internet Service Provider that is hosting the machine, and our access to it is primarily through Remote Desktop, and FTP.

Can one do a Network Install, and then copy up a smaller file signature to the hosted server?

Otherwise I'm looking at a 800Meg + Upload for EACH machine I need to install this on.
|||** bump