Backup and Restore from SQL Server 2005 to 2008 express edition?

Try this code RESTORE DATABASE databasename FROM DISK = 'c:\database_backup_20091228_1500. Bak' WITH NOFORMAT, NOINIT.

You can restore a SQL Server 2005 database to SQL Server 2008 Express edition provided your database is no greater than 4GB in size.

– rgoytacaz Dec 28 '09 at 17:37 If the database is bigger than 4GB it will not work with SQL Server Express.So in a round about way, yes. – John Sansom Dec 28 '09 at 17:53.

The RESTORE operation iscapable of upgrading the database on the fly from the 2005 format to 2008 one. When you create a new database by means of restore you usually need to options added: REPLACE is needed to disable a normal check that occurs during RESTORE and which prevents you from replacing a database with the content of another database from a backup set. For details see Using the REPLACE Option.

MOVE is needed to move logical files in the backup set to new locations. The RESTORE operation will attempt to create the same locations for the MDF, LDF and all NDF files in the database, and this may not work on your particular drive structure. For details see Copying Databases with Backup and Restore.

If your client is using any feature that does not work in Express then you're going to have to upgrade to an edition that supports the features you need. The best option by far is to buy a Developer edition license, that costs around $50 only and gives you all. Fully functional.

Enterprise features at the restriction that it can only be used for development purposes (which you are).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.