Ms sql web edition

broken image

I should note with the large downtime option. Attach database(s) through the MSSQL interface (Right click attach in server manager).Optional (very recommended): Make backups of your data mds files (likely in %progfiles%\MSSQL\Data).Swap backup site onto main port (80, 443) if option 4 was used.Optional (recommended): Create a copy of your web server (or at least one site).Import the database(s) into the SQL Web Edition.Make a backup copies of database(s) (through the SQL Server Manager, it is a right click option).This is option will be present during initial install of MSSQL. The new edition will be have to be named something else. Normally SQL Server Editions are installed with the default name so the connect string you are using is likely 192.0.x.x and valid. There will just be choices if you want to minimize your downtime. Multiple SQL Server editions are allowed to be installed on the same box.