<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
could you please provide the procedure to upgrade SQL express to SQL Web / Standard 2008 R2 edition<br />
<br />
&nbsp;SQL 2008 R2<br />
OS: Windows 2008 R2 standard<br />
<br />
this server got live Databases, so I have to make sure there shouldn't be any data loss<br />
<br />
and also provide me procedure Backup all Databases including logs at one go <br />
<br />
Thank You<br />
Regards,
</div>
</div>


Hi Guys,

could you please provide the procedure to upgrade SQL express to SQL Web / Standard 2008 R2 edition

 SQL 2008 R2
OS: Windows 2008 R2 standard

this server got live Databases, so I have to make sure there shouldn't be any data loss

and also provide me procedure Backup all Databases including logs at one go 

Thank You
Regards,

Upgrade SQL express to SQL Standard or Web edition

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.