?
Solved

Upgrade SQL express to SQL Standard or Web edition

Posted on 2012-03-19
1
Medium Priority
?
320 Views
Last Modified: 2012-04-14
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,
0
Comment
Question by:Moonatwork
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 37739064
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question