SQL 2005 back up the database. dat or BAK solution for structural errors

The disk structure version of the backed up Database tutorial is 611. The server supports version 539 and cannot restore or upgrade this database, and the RESTORE database operation terminates abnormally.
The remote server host installed SQL Server 2005, backup using the virtual host from the Restore tool to back up the database in Data.dat format, when the local sql2000 want to restore the database, prompted the "backed up the database on the disk structure version of 611." The server supports version 539 and cannot restore or upgrade this database, and the RESTORE database operation terminates abnormally. ”

This is due to the high version 2005 backward compatibility of the SQL database, but the lower version of SQL2000 cannot handle the SQL2005 database format. The client must use sql2005 to properly restore the database files that have been backed up. This requires the installation of SQL 2005, but SQL 2005 of a development version of the source file up to 3.76GB size, x86 also have 1GB size, the installation process is more than an hour, which for the drift is undoubtedly a huge waste of time.

So how do we solve it? Drift easy to take is to download the compact version of the SQL 2005 server and client, 2 files add up to a total of 85m size, the actual installation of only need 10 minutes, which is more than the original installation time that is a huge contrast.

All right, let's go. How to install a compact version of MSSQL 2005, first download the server-side software: Microsoft SQL Server, Express Edition, which is actually a refined version of SQL 2005.

Microsoft SQL Server Edition Express (SQL Server Express) is a free, easy-to-use lightweight version of SQL Server 2005 that is quick and easy to master and can be used to quickly develop and deploy dynamic data-driven Application. SQL Server Express provides powerful and reliable data management tools that are rich in functionality to protect data and improve performance. It applies to embedded application clients, lightweight Web applications, and local data stores. SQL Server Express features easy deployment and rapid prototyping, which you can obtain free of charge and redistribute freely with your application. If you need more advanced database functionality, you can seamlessly upgrade SQL Server Express to a more complex version of SQL Server.

Download address: Microsoft SQL Server, edition Express, official Simplified Chinese version:

Http://download.microsoft.com/download/c/e/6/ce626f95-ebd3-4ab8-aa35-c1bfaf98b7d5/sqlexpr32_chs.exe

It's just a server software, and we're going to download a graphical client-side management tool: Microsoft SQL Server Management Studio Express. Download Address:
Http://download.microsoft.com/download/5/4/f/54f476b4-2348-4d4a-b705-0c8c9ab2a14a/sqlserver2005_ssmsee.msi

The above 2 software download is good, in order to install complete, restore just 2005 of the backup file is no problem, no more "the backed-up database of the disk structure version of 611." Server support version 539, unable to restore or upgrade this database, restore database operation abnormally terminated "such a prompt, if you back up the database suffix is. bat, you can change it directly to. bak, because sql2005 only the suffix of. Bak.

The following statements can be executed in Query Analyzer or stored procedures in response to a different database schema that occurs after sql2000 is upgraded to sql2005:
exec sp_msforeachtable @command1 = "Exec sp_ Changeobjectowner '? ', ' dbo '
The statement calls the system stored procedure sp_msforeachtable the schema name of the bulk modified datasheet is dbo