[dba-SQLServer] sql2005 express to standard

J- P jnatola at hotmail.com
Tue Mar 18 11:14:06 CDT 2014


yes, all express are limited to 1GB per database

  



 


> Date: Tue, 18 Mar 2014 16:12:30 +0000
> From: paul.hartland at googlemail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
 		 	   		  


More information about the dba-SQLServer mailing list