[dba-SQLServer] sqlexpress upgrade

Hello Jp,

Are you planning on also replacing the 2003 box?  If so, I would suggest

1) purchase a new machine and install Win2012
2) install sql 2014 express
3) back up and restore your db
4) forget about it for another 10 years.

if you do not want to purchase an expensive server, just use a pc with 16gb
ram.
if you are really on a budget, use Win 8.1 as the host OS,

regardless, I would not waste hours and risk all sorts of unknown errors in
doing a multi-stage upgrade.

Your time is more valuable and a €600 machine.

Mark




On 30 November 2014 at 16:27, J- P <jnatola at hotmail.com> wrote:

> Hi all, this is a 2 parter
>
> 1.) I have a sqlexpress 2005 database on a 2003 server, as 2003 is nearing
> EOL (as is the hardware ) i *THINK* perhaps this may be a good time to
> upgrade the DB to a newer version ? (any thoughts/suggestions )
>
> Assuming I do upgrade to 2008r2 express, is it better to install a fresh
> 2008express and do  a restore of the database via SSMS, or install
> 2005express restore the DB, then install 2008 and let the wizard do the
> upgrade?
>
> 2.) There are a bunch of mtc routines amongst other things I'd like to
> keep/migrate to the new server, is it possible to restore the master DB to
> the new machine? if so is this recommended/advised?
>
> **This is a production server so upgrading to 2008express  on the live
> server is not an option**
>
> TIA,
>
> J
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>