Can you restore a backup from newer version of SQL Server to older version, if in compatibility mode?
in [Server Configuration]
|
From: JimLad on 25 Feb 2010 11:35 Can you restore a backup from newer version of SQL Server to older version if in compatbility mode? i.e. there is a db on SQL2005 running in SQL2000 compatibility mode. Can you restore a backup of this db onto SQL 2000? I'm pretty sure the answer is no - I just want an authoratitive answer. Cheers, James
From: Russell Fields on 25 Feb 2010 11:40 The answer is 'no'. The compatibility mode only controls the way that TSQL is interpreted. However, the disk bits are updated to 2005 format, which cannot be restored to 2000. RLF "JimLad" <jamesdbirch(a)yahoo.co.uk> wrote in message news:e10133c2-bda1-48c5-ac0b-44ce4ef9664f(a)z35g2000yqd.googlegroups.com... > Can you restore a backup from newer version of SQL Server to older > version if in compatbility mode? > > i.e. there is a db on SQL2005 running in SQL2000 compatibility mode. > Can you restore a backup of this db onto SQL 2000? > > I'm pretty sure the answer is no - I just want an authoratitive > answer. > > Cheers, > > James
From: JimLad on 26 Feb 2010 13:10 On 25 Feb, 16:40, "Russell Fields" <RussellFie...(a)nomail.com> wrote: > The answer is 'no'. The compatibility mode only controls the way that TSQL > is interpreted. However, the disk bits are updated to 2005 format, which > cannot be restored to 2000. > > RLF > > "JimLad" <jamesdbi...(a)yahoo.co.uk> wrote in message > > news:e10133c2-bda1-48c5-ac0b-44ce4ef9664f(a)z35g2000yqd.googlegroups.com... > > > > > Can you restore a backup from newer version of SQL Server to older > > version if in compatbility mode? > > > i.e. there is a db on SQL2005 running in SQL2000 compatibility mode. > > Can you restore a backup of this db onto SQL 2000? > > > I'm pretty sure the answer is no - I just want an authoratitive > > answer. > > > Cheers, > > > James- Hide quoted text - > > - Show quoted text - Many thanks. James
|
Pages: 1 Prev: perfmon counter Next: problem slow queries after installing sp4 on sql 2000 |