Post reply

Need t-sql script to backup a sql 2005 sp2 database with compression

  • September 1, 2011 at 11:15 am

    #244107

    Need t-sql script to backup a sql 2005 sp2 database with compression.

    This is not working on SQL 2005:

    BACKUP DATABASE myDatabase TO DISK = 'C:\BackupFolder\myDatabase.BAK' WITH COMPRESSION

    BT

  • September 1, 2011 at 11:18 am

    #1376078

    Compression is a 2008 feature. Didn't exist in SQL 2005. You can use third-party solutions for that, or back up to a compressed directory/drive. Or upgrade SQL Server, of course.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • September 1, 2011 at 11:19 am

    #1376079

    Express12 (9/1/2011)

    Need t-sql script to backup a sql 2005 sp2 database with compression.

    This is not working on SQL 2005:

    BACKUP DATABASE myDatabase TO DISK = 'C:\BackupFolder\myDatabase.BAK' WITH COMPRESSION

    compression was introduced in SQL 2008 i believe;

    the backup command for SQL 2005 doesn't mention compression at all:

    http://msdn.microsoft.com/en-us/library/ms186865(v=SQL.90).aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 1, 2011 at 11:20 am

    #1376080

    thx ALL.. my bad !

    BT

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply