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 >