June 10, 2009 at 8:57 am
I'm getting an error when trying to backup a database on a 64 bit machine. I've previously benn able to do this on another 64 bit machine. What am I doing wrong? Is there some setting I need to change?
BACKUP DATABASE WITH COMPRESSION is not supported on Standard Edition (64-bit).
Here is my query
BACKUP DATABASE CaseLevelData
TO DISK = 'F:\Backup\WednesdayCaseLevelData.bak'
WITH COMPRESSION, INIT,FORMAT,CHECKSUM,STOP_ON_ERROR
June 10, 2009 at 9:08 am
Native compressed backups are only supported with SQL Server 2008 Enterprise Edition. From what I understand, SQL Server 2008 Standard Edition will restore a compressed backup taken on a SQL Server 2008 Enterprise Edition system.
It is possible the other x64 servers you were successful on doing a compressed backup was running either SQL Server 2008 Enterprise Edition, Evaluation Edition, or Developer Edition.
June 10, 2009 at 9:09 am
you dint mention the version of SQL you are using , i am assuming that this is 2008
June 10, 2009 at 9:24 am
I looked at the properties and I am actually using Std Ed. On that server. Doh!
May 24, 2012 at 3:22 am
Just come across this issue - why offer the option in the drop down if it isn't available on the edition you using :angry:
May 24, 2012 at 3:41 am
dave.sexton (5/24/2012)
Just come across this issue - why offer the option in the drop down if it isn't available on the edition you using :angry:
Because management Studio doesn't have an edition, only the server does. I can use Management Studio from SQL Express to connect to Enterprise Edition and I'd sure like to see the compression option.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy