Click here to Skip to main content
15,306,445 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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)
Posted
Comments
Jan Steyn 9-Nov-12 5:00am
   
Does the SQL server service user have access to the path on which the backup is?

1 solution

Try:
SQL
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'
   

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900