August 25, 2009 at 10:56 am
Hi all,
What I would need to know is if it is possible to create databases with a format of an older version of Sql Server from Sql Server 2008.
I need to do this to be able to create bak files from some tables of my Sql Server 2008 database that can be replicated by remote Sql Server 2005 instances.
Does anyone know how it can be achieved?
Thanks!
August 25, 2009 at 11:02 am
you could set compatibility level to 90 (for 2005) or 80 (for 2000)
August 25, 2009 at 11:28 am
dambuster (8/25/2009)
Hi all,What I would need to know is if it is possible to create databases with a format of an older version of Sql Server from Sql Server 2008.
I need to do this to be able to create bak files from some tables of my Sql Server 2008 database that can be replicated by remote Sql Server 2005 instances.
Does anyone know how it can be achieved?
Thanks!
no it is not possible. as soon as SQL 2008 touches a database, it is upgraded to the SQL 2008 format.
it is not possible to to restore or attach a database from a higher version to a lower version.
setting database compatibility mode tries to regulate the syntax of commands hitting the database to, say the 8.0 syntax, it has nothing to do with the way the data is structured or saved behind the scenes...if you think about it, that's gotta be how it works, because you know you can change compatibility on the fly, back and forth. there are some commands that can be run, that are the higher compatibility version, regardless of the database's compatibility level..so like i said, it tries to restrict it, but not 100%.
If you need a 2005 backup, it must come from a 2005 server. Otherwise, you'll have to use the SSIS or the database copy wizard to copy a database from 2008 to a real 2005 server, and then backup that copy on that real 2005 server.
Lowell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply