Cari Blog Ini

01 Juni 2012

Error Messages - Incompatible Server Version When Restore Database

Apply To :
Microsoft SQL Server 2008 R2

Error Messages :

Msg 3169, Level 16, State 1, Line 2 

The database was backed up on a server running version 10.50.1600. 

That version is incompatible with this server, which is running version 10.00.1600. 

Either restore the database on a server that supports the backup, 

or use a backup that is compatible with this server. 


Msg 3013, Level 16, State 1, Line 2 

RESTORE DATABASE is terminating abnormally.








Running for Script:

-----code:start

use [master]
go

restore database [HRD]
from disk ='C:\Backups Principal\HRD.Bak' with norecovery, replace,

move 'HRD'  to 'C:\DB Mirror\HRD.mdf',

move 'HRD_1'  to 'C:\DB Mirror\HRD_1.ldf'
go

-----code:end





Causes:
1. File Backup "HRD.bak" is backup from server Principal



2. Database [HRD] is in server Mirror



Solution:
Use the same version of server.