Should be ok to install from RDP. I do this always. I have the media locally and use the VirtualCD control panel to map ISO files as drive letters.

The installer...

Do you have a AS400 compatible driver on your system? Have you created an odbc connection or can you connect via the client software to the AS400 box?

No, just go through the functionality you need and the sizing. You can now use Standard Edition to cluster. If you need to setup reporting services, notification services etc you...

Create a maintenance plan with backup all databases. This will add a job to the SQL Agent. If you don't want it to run scheduled turn off enabled and run...

I think the Installer will tell you if you can install the default instance. Should be possible.

Have you tested this in x86 version?

From BOL: When listening on IP_ANY, when you enable listening on specific IP's the user must configure the same TCP port on each...

Thanks Linda

I'll give it a try. Seems strange though, install SQL client tools on a windows 2003 server.

Rune

SELECT DATABASEPROPERTYEX('Northwind', 'Recovery')

It then displays the Recovery Models.

Look at DATABASEPROPERTYEX in Books Online (the helpfile )

Runaldo

You are looking at the logical filename and not the physical filename. Expand the column physical name and you should see the path where the data files were placed on the...

I found another thread questioning SP4 on active/active cluster. We are running a/a cluster so I just installed the SP on both nodes - booted them and it seems to...

Hi Chubbsm

I have exactly the same problem. I have installed 2 new instances on a IA64\Win2003 cluster. Both nodes shows SP4 on the node I installed the sp from (with...

Thanks - I'll use your input and the sp_spaceused (I forgot i could just get the code :hehe and try get a script working.

BOL - Books Online (SQL Server Helpfile)

Performance Counter - Open Administrative Tools on your server and clik Performance. Check out the different counters that are there.

I awe. Works great!!!!

Thanks

Or simpler. Change the recovery model to Simple. Backup the database and shrink the file!