还原数据库问题SQL 2008 [英] Restore database prblem sql 2008

问题描述

嗨
我已经备份了sql server 2005中的数据库.我需要在另一个服务器sql server 2008中恢复该备份数据库.但是在选择备份路径时出现以下错误...请尽快提供帮助


指定的演员表无效. (SqlManagerUI)

Hi
I have taken back up of database which is in sql server 2005..I need to restore that back up database in another server which is sql server 2008..But am getting the following error which selecting the backup path ...please help soon


Specified cast is not valid. (SqlManagerUI)

推荐答案

尝试:

Use Master
Go
RESTORE DATABASE YourDB
FROM DISK = 'C:\YourBaackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:\DataYourMDFFile.mdf',--adjust path
MOVE 'YourLDFLogicalName' TO 'D:\DataYourLDFFile.mdf'

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