database restore problem

Question

0.00/5 (No votes)

See more:

Hello friends,

I have a problem in database restoring,
I took the database backup from my domain as database backup repositary file, i tried to restore in my local system is showing problem as Specified cast is not valid. (SqlManagerUI).
Can somebody help me in this.

Thanks and regards,
Abdul Rahman.

C#

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)

Posted 22-Jan-14 3:04am

M.Abdul Rahman

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sp_suresh · Answer 1 · 2014-01-22T14:07:00

Solution 2

When Restoring database please do remember following things
1. Version of both SQL server should be same
2. If you want to another version then create script from another version and run on your local site.But script with data generation is possible only possible is sql server greater than 2005
3. IF both versions are same then check permissions you have provided from local admin.

Posted 22-Jan-14 14:07pm

sp_suresh

Comments

Christian Graus 22-Jan-14 20:15pm

No, the one you're restoring TO, can be newer than the one you created the backup from.

M.Abdul Rahman · Answer 2 · 2014-01-23T00:56:00

Solution 3

I'm using SQL server 2008 in my local machine and the domain to which i hosted my website is supporting mylittleadmin 2005 version, I dont know is it suitable to sql server 2008 or not, please somebody help me to solve this.

Posted 23-Jan-14 0:56am

M.Abdul Rahman

**Nirav Prabtani** · Answer 3 · 2014-01-23T01:11:00

Solution 4

reffer this.. :)

Database restore issues.. :)[^]

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)[^]

Posted 23-Jan-14 1:11am

Nirav Prabtani

Christian Graus · Answer 4 · 2014-01-22T11:25:00

Solution 1

I googled and found this advice:

Do "RESTORE FILELISTONLY FROM DISK = N'path to .bak file'" and adjust your RESTORE command's MOVE options to match the files as indicated, so that the RESTORE command can create those files for you.

Posted 22-Jan-14 11:25am

Christian Graus