Francisco Tapia
fhtapia at gmail.com
Fri Sep 11 12:49:16 CDT 2009
SELECT @@VERSION yeilds Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) -Francisco http://sqlthis.blogspot.com | Tsql and More... On Fri, Sep 11, 2009 at 10:43 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > How do you tell once installed, whether you have the X32 or X64 SQL Server > installed? I assume it > must be X64 because I can give it 12 gigs of ram on my X64 2003 server. > > John W. Colby > www.ColbyConsulting.com > > > Francisco Tapia wrote: > > Compression backups? > > one thing to remember is that if you run a backup to a backup device you > > can't have an uncompressed backup with a compressed backup. as far as > cost > > it might be cheaper to invest in redgate's backup software wich is fast > and > > robust we use it here to backup our 2TB databases. for 295 you really > can't > > beat the price on other solutions... its definitely cheaper than going > 2008 > > enterprise. > > > > > > more info here: http://msdn.microsoft.com/en-us/library/bb964719.aspx > > http://msdn.microsoft.com/en-us/library/ms186865.aspx > > > > alternitavely you may wish to use a free compression product such as: > > http://www.idera.com/Products/Free-Tools/SQL-safe-Freeware-Edition/ > > > > -Francisco > > http://sqlthis.blogspot.com | Tsql and More... > > > > > > On Fri, Sep 11, 2009 at 7:05 AM, jwcolby <jwcolby at colbyconsulting.com > >wrote: > > > >> Does anyone have experience with using compression in 2008? I > understand > >> it is only available in > >> the enterprise edition? > >> > >> -- > >> John W. Colby > >> www.ColbyConsulting.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 > >