Monthly Archives: April 2009

Backup Compression with SQL Server 2008

Posted on April 15, 2009 by johnsterrett| 3 Comments

I wanted to share my results towards using the backup compression utility built into SQL Server 2008 Enterprise Edition.   I have noticed a compression range from 65% to 75%.

Database SQL 2005 backup SQL 2008 (compression enabled) Compression
DB One 18.2 GB 5.6 GB 69%
DB Two 3.7 GB 1.3 GB 65%
DB Three 1.2 GB .3 GB 75%

By default, backups are not compressed. You can change this setting by using sp_configure to set the value of the backup_compression_default setting or by selecting the option in the Server Properties dialog box. ( I don’t recommend  this as you can specify the compression type as shown below)

For anyone using SQL Server 2008 who is  not familiar with the compression feature you can enable it by using the following example.

When you create a backup on the options page you will notice a compression section at the bottom of the screen.  There are three values in the dropdown including use default server settings, Compress backup, and do not compress backup.  Select compress backup and click OK (I highly recommend you also check the checkbox to verify backup when finished)

SQLBackup

For those who are using the backup compression what are your results?  Shoot a responses.  I want to know how its working out for you.

→ 3 Comments

Posted in SQL Server 2008, SQLServerPedia Syndication

Tagged

AITP Tours the Center of Educational Technology

Posted on April 1, 2009 by johnsterrett| Leave a comment

This month’s meeting of the Greater Wheeling Chapter of AITP is tour of the Center for Educational Technologies. It will start at the CET office located on the WJU campus at 316 Washington Ave. Wheeling, WV 26003-6243 on Wednesday, April 8th 2009. The meeting will include a presentation of video conferencing and a tour of CET given by Dr. Bruce Howard.

Social hour will start at 5:30 P.M. We will meet in the CET lobby on the third floor.  The tour and presentation will start at 6:00 P.M.  Dinner will follow at 7:15 P.M and it will be held at the White Palace in Wheeling Park.  Dinner will be followed by a tech session on IE 8 presented by Chuck Hill.
 
Cost for the evening is $18.00 for AITP members, $10.00 for AITP student members, and $23.00 for guests.  To RSVP please email kkovacs@dwc.org.  If you have any questions or need help with directions please call John at 304-780-8532.

Driving Directions:
The Center for Educational Technologies® is located on the campus of Wheeling Jesuit University in Wheeling, WV. To reach the center, take exit 2B off I-70 in Wheeling
If you’re coming from the West, turn left at the end of the exit ramp and follow Washington Ave., bearing right at the end of the bridge. If you’re coming from the East, turn right onto Washington Ave. From either direction, then, the entrance to the campus is on the left. The center is the first building to the left off the main campus drive. Parking is available in the rear of the building.

campusMap

→ Leave a comment

Posted in Events

Tagged , ,