It is not possible to restore a SQL Server 2008 R2 database on SQL Server 2008 due to the physical version numbers being incompatabile. You can run DBCC DBINFO to read the database header page to collect the actual information:
DBCC TRACEON (3604);
GO
DBCC DBINFO
GO
DBCC TRACEOFF (3604);
dbi_version = 661
A summary of versions
* SQL Server 7.0 databases have version number 515
* SQL Server 2000 databases have version number 539
* SQL Server 2005 databases have version number 611/612
* SQL Server 2008 databases have version number 655
* SQL Server 2008 R2 databases have version number 660
An excellant post The Rambling DBA: Jonathan Kehayias
and Paul Randal
explain this.
Chaos, complexity, curiosity and database systems. A place where research meets industry
Tuesday, 29 June 2010
Wednesday, 23 June 2010
SQLBits
The next SQLBits conference, SQLBits 7: The Seven Wonders of SQL, will be taking place from September 30th to October 2nd at York University.
Friday, 11 June 2010
Database Management Methods
I am currently researching what methodologies, tools or processes are currently used in the day to day management of SQL Servers.
Can you help with my survey on Database Management Method on bit.ly/aMEqbW
Thank you helping with the research
Can you help with my survey on Database Management Method on bit.ly/aMEqbW
Thank you helping with the research