[dba-SQLServer] SQL Server 2008 compression

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
>
>



More information about the dba-SQLServer mailing list