[dba-SQLServer] sql2005 express to standard

hmmm yes could be an issue, Im sure someone will correct me if I am wrong
but I think all the express editions utilise a maximum of about 1GB.


On 18 March 2014 16:05, J- P <jnatola at hotmail.com> wrote:

> the main/only reason is the RAM, database size is not an issue I am going
> to have a teleconference with them at some point this week.
>
> I think they may be saying that in order to cover their rears should
> express not handle it well.
>
>
>
> Jean-Paul Natola
>
>
>
>
> > Date: Tue, 18 Mar 2014 15:29:05 +0000
> > From: paul.hartland at googlemail.com
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [dba-SQLServer] sql2005 express to standard
> >
> > Well then it comes down to cost and whether you or your company take the
> > chance on support ending and something going wrong, I had little
> > involvement with my two previous companies about the versions we
> installed.
> >  In this case I would probably go the to company supplying the timtrack
> > software and ask them about newer express versions first, maybe SQL
> Express
> > 2012 Advanced maybe an option or why they recommend going to a standard
> > edition i.e. why do they say this, if it's the size of the databases 2012
> > and (i think) 2008 upwards can support 10GB databases.  Then when you get
> > the answers from them, put that along together with costs, pro's and
> con's
> > for your company and see what they say, or when you find out why your
> > timtrack supplier recommends standard editions, post back on here, just
> > because a company recommends it, doesn't mean it won't work with an
> express
> > version.
> >
> > Paul
> >
> >
> > On 18 March 2014 15:03, J- P <jnatola at hotmail.com> wrote:
> >
> > > My only hesitation about purchasing 2005 std is the fact that its
> > > approaching MS EOL
> > >
> > > > Date: Tue, 18 Mar 2014 08:10:14 +0000
> > > > From: paul.hartland at googlemail.com
> > > > To: dba-sqlserver at databaseadvisors.com
> > > > Subject: Re: [dba-SQLServer] sql2005 express to standard
> > > >
> > > > I have always been the if not broke don't fix it guy (with a few
> > > > exceptions), if 2005 works for you why change it, also if you remove
> the
> > > > management studio before upgrading (not re-installing) to SQL Server
> 2005
> > > > standard, it "should" go without a hitch, without the need to
> > > > backup/restore or detach/attach the databases and the server instance
> > > > should remain the same.
> > > >
> > > > Paul
> > > >
> > > >
> > > > On 17 March 2014 20:29, J- P <jnatola at hotmail.com> wrote:
> > > >
> > > > > Hi all,
> > > > >
> > > > > we have an sql express database that has been running  for many
> many
> > > many
> > > > > years, we are getting a new timtrack software that they recommend
> to
> > > run on
> > > > > sql standard, a few vendors still have sql 2005std on hand for a
> really
> > > > > good price (we need the cpu license) , so the question i have is
> > > two-fold;
> > > > >
> > > > > a) is the best way to upgrade the current db to standard via back
> up
> > > > > /restore?
> > > > >
> > > > > b) is it foolish to purchase sql 2005 given that we are in 2014?
> > > > >
> > > > > Any thoughts/feedback. opinions would be greatly appreciated.
> > > > >
> > > > > TIA
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > dba-SQLServer mailing list
> > > > > dba-SQLServer at databaseadvisors.com
> > > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > > > http://www.databaseadvisors.com
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Paul Hartland
> > > > paul.hartland at googlemail.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
> > >
> > >
> >
> >
> > --
> > Paul Hartland
> > paul.hartland at googlemail.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
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com