Restore database backup issue

Question

I downloaded the backup file from Mochahost website Pabel. But when i restore it on my local computer using SQL Server 2008 it gives me error.

Error Description:

Specified cast is not valid. (SqlManagerUI)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.PopulateGridWithBackupSetsFromDevices()
   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.GetBackupSetsFromDevices()
   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.textDeviceSelected_TextChanged(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnTextChanged(EventArgs e)
   at System.Windows.Forms.TextBoxBase.OnTextChanged(EventArgs e)
   at System.Windows.Forms.Control.set_Text(String value)
   at System.Windows.Forms.TextBoxBase.set_Text(String value)
   at System.Windows.Forms.TextBox.set_Text(String value)
   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I am using MS SQL Server 2008

Bridge · Accepted Answer · 2014-12-19T12:25:36.773

1

It sounds like your backup is a newer version of SQL Server than what you have installed.

SQL Server is backwards compatible, but not forwards compatible. You'll need an instance newer or equal version of SQL Server to the backup you are trying to restore.

edited Dec 19 '14 at 12:25

answered Dec 19 '14 at 08:38

Bridge

29,818
9
60
82

I am trying to restore backup of sql server 2012 to 2008 database. – user3441151 Dec 19 '14 at 11:23
You cannot restore backup taken on higher version to lower version – Shanky Dec 19 '14 at 16:09

Restore database backup issue

1 Answers1