2 typo
source | link

iYesYes, it is quite possible to restore a SQL Server 2005 backup to SQL Server 2008.

The restore command is the same as of restoring to SQL Server 2005. E.g.

RESTORE DATABASE [Xyzzy] 
  FROM  DISK = N'\\Server\Share\Path\Xyzzy_FULL_20130915.bak' WITH  FILE = 1,  
  MOVE N'Xyzzy_Data' TO N'D:\Data\Xyzzy_Data.MDF',  
  MOVE N'Xyzzy_Log' TO N'F:\Data\Xyzzy_log.LDF',  RECOVERY,  NOUNLOAD,  STATS = 10

The restore will be followed by some upgrade steps to bring the SQL Server 2005 database format up to the SQL Server 2008 database format.

(Note: You will not be able to restore the 2008 database back to 2005.)

There are limits to how early a version of SQL Server can be restored to 2008, but 2005 should work fine. Here is a link to the supported upgrade paths to SQL Server 2008:

http://technet.microsoft.com/en-us/library/ms143393(v=sql.100).aspx

iYes, it is quite possible to restore a SQL Server 2005 backup to SQL Server 2008.

The restore command is the same as of restoring to SQL Server 2005. E.g.

RESTORE DATABASE [Xyzzy] 
  FROM  DISK = N'\\Server\Share\Path\Xyzzy_FULL_20130915.bak' WITH  FILE = 1,  
  MOVE N'Xyzzy_Data' TO N'D:\Data\Xyzzy_Data.MDF',  
  MOVE N'Xyzzy_Log' TO N'F:\Data\Xyzzy_log.LDF',  RECOVERY,  NOUNLOAD,  STATS = 10

The restore will be followed by some upgrade steps to bring the SQL Server 2005 database format up to the SQL Server 2008 database format.

(Note: You will not be able to restore the 2008 database back to 2005.)

There are limits to how early a version of SQL Server can be restored to 2008, but 2005 should work fine. Here is a link to the supported upgrade paths to SQL Server 2008:

http://technet.microsoft.com/en-us/library/ms143393(v=sql.100).aspx

Yes, it is quite possible to restore a SQL Server 2005 backup to SQL Server 2008.

The restore command is the same as of restoring to SQL Server 2005. E.g.

RESTORE DATABASE [Xyzzy] 
  FROM  DISK = N'\\Server\Share\Path\Xyzzy_FULL_20130915.bak' WITH  FILE = 1,  
  MOVE N'Xyzzy_Data' TO N'D:\Data\Xyzzy_Data.MDF',  
  MOVE N'Xyzzy_Log' TO N'F:\Data\Xyzzy_log.LDF',  RECOVERY,  NOUNLOAD,  STATS = 10

The restore will be followed by some upgrade steps to bring the SQL Server 2005 database format up to the SQL Server 2008 database format.

(Note: You will not be able to restore the 2008 database back to 2005.)

There are limits to how early a version of SQL Server can be restored to 2008, but 2005 should work fine. Here is a link to the supported upgrade paths to SQL Server 2008:

http://technet.microsoft.com/en-us/library/ms143393(v=sql.100).aspx

1
source | link

iYes, it is quite possible to restore a SQL Server 2005 backup to SQL Server 2008.

The restore command is the same as of restoring to SQL Server 2005. E.g.

RESTORE DATABASE [Xyzzy] 
  FROM  DISK = N'\\Server\Share\Path\Xyzzy_FULL_20130915.bak' WITH  FILE = 1,  
  MOVE N'Xyzzy_Data' TO N'D:\Data\Xyzzy_Data.MDF',  
  MOVE N'Xyzzy_Log' TO N'F:\Data\Xyzzy_log.LDF',  RECOVERY,  NOUNLOAD,  STATS = 10

The restore will be followed by some upgrade steps to bring the SQL Server 2005 database format up to the SQL Server 2008 database format.

(Note: You will not be able to restore the 2008 database back to 2005.)

There are limits to how early a version of SQL Server can be restored to 2008, but 2005 should work fine. Here is a link to the supported upgrade paths to SQL Server 2008:

http://technet.microsoft.com/en-us/library/ms143393(v=sql.100).aspx