数据库恢复问题 [英] database restore problem

问题描述

你好朋友，



我在数据库恢复方面遇到问题，

我从我的域中获取数据库备份作为数据库备份存储库文件，我试图在我的本地系统中恢复显示问题，因为指定的强制转换是无效的。 （SqlManagerUI）。

有人可以帮我这个。





谢谢和问候，

Abdul Rahman。

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.

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)

推荐答案

恢复数据库时请记住以下事项

1.两个版本的SQL服务器应该相同

2.如果你想要另一个版本，那么从另一个版本创建脚本并在你的本地站点上运行。但是带有dat的脚本一代是可能的只有sql server大于2005

3.如果两个版本相同，那么检查你从本地管理员提供的权限。

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.

我'我在我的本地机器上使用SQL Server 2008，我托管我的网站的域是支持mylittleadmin 2005版本，​​我不知道它是否适合sql server 2008，请有人帮我解决这个问题。

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.

reffer this .. :)



数据库恢复问题.. :) [ ^ ]



SQL Server数据库恢复错误：指定的强制转换无效。 （SqlManagerUI） [ ^ ]

reffer this.. :)

Database restore issues.. :)[^]

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

这篇关于数据库恢复问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！