[dba-SQLServer] sqlexpress upgrade

Doing that as we speak, 

in so far as bringing over the maintenance routines and logins, is there a way to do it?

the basic routines are , hourly transaction log backups, daily full, weekly integrity


  

Jean-Paul Natola

 


> From: marklbreen at gmail.com
> Date: Mon, 1 Dec 2014 18:38:14 +0000
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] sqlexpress upgrade
> 
> Hello JP,
> 
> there sure is,
> 
> 1) grab any old windows 8.1 box and install SQL 2014 express on it
> 2) change your connections strings and test your app against that new temp
> machine.
> 
> I would expect that you have a very good change that it will work straight
> away unless you are using advanced features, DTS etc.
> 
> You may be lucky but the other route will also require plenty of luck.
> 
> 
> 
> 
> 
> On 1 December 2014 at 18:14, J- P <jnatola at hotmail.com> wrote:
> 
> > Yes the box is being replaced, my concencern is that this custom database
> > was developed in 1997 (started  as access)
> > then went on to sql 2k express then 2005 express, how can i be  SURE that
> > it will function under 2014?
> >
> > I have read (and I'm by no means a DBA) that alot of features were
> > deprecated ,
> >
> > is there a way to test this?
> >
> >
> >
> >
> >
> >
> >
> > > From: marklbreen at gmail.com
> > > Date: Mon, 1 Dec 2014 09:05:29 +0000
> > > To: dba-sqlserver at databaseadvisors.com
> > > Subject: Re: [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
> > > >
> > > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>