Error: Specified cast is not valid. (SqlManagerUI)

Question

My environment is:

Operating System: Windows 7 Pro (32bit), Finnish

I use Virtual PC including in Windows 7

Operating system in Virtual PC: Windows Server 2008 Standard.

SQL Sever 2008 R2

Under SQL Server Management Studio,

I have a database backup file created by different user in same environment (Virtual PC + Windows Server2008 + SQL Server 2008 R2)

When I try to restore a Database from backup file I get following message:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Specified cast is not valid. (SqlManagerUI)

------------------------------
BUTTONS:

OK
------------------------------

What I made wrong ?

 

 

Answer 1

This is a tool issue which i got some times back.

Try using TSql

RESTORE DATABASE [MyDatabase]

FROM    DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Backup\AdventureWorks2008.bak'

WITH  FILE = 1,     MOVE N'AdventureWorks2008_Data'

TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\MyDatabase.mdf',

MOVE N'AdventureWorks2008_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\MyDatabase_5.ldf',

NOUNLOAD,  REPLACE,  STATS = 10

RESTORE DATABASE [MyDatabase]

FROM    DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Backup\AdventureWorks2008.bak'

WITH  FILE = 1,     MOVE N'AdventureWorks2008_Data'

TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\MyDatabase.mdf',

MOVE N'AdventureWorks2008_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\MyDatabase_5.ldf',

NOUNLOAD,  REPLACE,  STATS = 10

RESTORE DATABASE <dbname> from <path>..........

Answer 2

Hi,

 

Thank's for your answer.

I tried it, but I got following message:

Msg 3203, Level 16, State 1, Line 1

Read on "E:\ERP\DW.bak" failed: 38(failed to retrieve text for this error. Reason: 15105)

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

 

BR,

Rauno

Answer 3

Did you have admin rights to do this operation. Run this as Administrator.

Answer 4

Yes I have Admin rights,

 

Answer 5

send ur script

Answer 6

Hi,

 

Here is my script:

RESTORE

 

DATABASE DW

FROM

 

DISK = N'E:\ERP\DW_31052010.bak'

 

WITH FILE = 1, MOVE N'DW_Log'

 

TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\DW.ldf',

 

NOUNLOAD, REPLACE, STATS = 10

 

and here is the message i got:

Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\DW.ldf" failed with the operating system error 3(failed to retrieve text for this error. Reason: 15105).

Msg 3156, Level 16, State 3, Line 1

File 'DW_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\DW.ldf'. Use WITH MOVE to identify a valid location for the file.

Msg 3119, Level 16, State 1, Line 1

Problems were identified while planning for the RESTORE statement. Previous messages provide details.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

 

BR,

Rauno

Answer 7

Do "RESTORE FILELISTONLY FROM DISK = N'E:\ERP\DW_31052010.bak'"  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.

---

Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi

Answer 8

Any suggestions for this case? Got the same error when use SSMS to restore, but got this message, backup "created using Microsoft Tape Format version 1.240. SQL Server supports version 1.0." when use tsql to restore with move or not, filelistonly, veryfiy, etc.. confirmed the backups were fine, but were taken from 2008R2 on Win2k8 server and try to restore to 2008R2 on Win2k3 server. Thanks!

Answer 9

So, in addition to the issue with SSMS, you have yeat another problem, probably unrelated. And that problem is that you cannot restore from the backup, even if we take the GUI (SSMS) out of the picture. That is a bit worse and I recommend you open a new thread on this focusing on the "tape format" error message - just to get apropriate focus on the issue. I can't say what the problem is, unless thet backup was in fact done to tape, which would sort of explain the problem (or at least might lead us to the explanation).

---

Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi

Answer 10

Hi,

I am having a similar issue:

Restore 2000 backup to 2008 express

When I try the restore I am getting:

Specified cast is not valid. (SqlManagerUI)

Any help would be appreciated.

---

Thanks, Doug

Answer 11

I would fiurt try do the restore using T-SQL commands directly (not click the GUI), just in case SSMS has some bug. You can script the RESTORE command from SSMS. Also, I would try RESTORE VERIFYONLY to see if the backup is healthy.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 12

I have seem the same error even when using restore verifyonly.

Since I've got this database from a Customer, not sure what was the backup method used by him, therefore not sure what the incompatibility or cause of the problem is.

-DB

 

Answer 13

I used your script when I got the same error as the original poster using the UI. I got this error message. It was a SQL Server 2005 database and I was restoring to a 2008 instance. Could that be a problem?

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "AFMISWeb" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Lisa Morgan

Answer 14

I believe there was a bug in Management Studio when restoring from 2005 to 2008. Using the restore command from a query window worked just fine. Bug possibly fixed in more recent builds of SSMS.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 15

When you do what you guys say:

Restore database

from= N'C:\BI4ALL\Base_Dados\Backup_AgenciaViagens.bak' FILE = 1,

Appears to me the following error:

WITH

MOVE N'Backup_AgenciaViagens_Log'

TO

N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Backup_AgenciaViagens_5.ldf',, replace, stats = 10

NOUNLOAD

Msg 3234, Level 16, State 2, Line 1

Logical file 'Backup_AgenciaViagens_Log' is not part of database 'agenciaViagens'. Use RESTORE FILELISTONLY to list the logical file names.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Help me , i don't understand what is happening

Answer 16

Execute below whcih will tell you what files the database were using. The logical file name os what you then use in the MOVE option.

RESTORE HEADERONLY

FROM DISK = N'C:\BI4ALL\Base_Dados\Backup_AgenciaViagens.bak'

WITH FILE = 1

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 17

 

Hi

I've executed the script and got the same errors.

When trying the RESTORE HEADERONLY I receive a line with the values:

BackupName = *** INCOMPLETE ***

Position =1

And the rest of the fields = NULL

What does it mean? How can I progress with the DB restore?

Answer 18

The database may have been backed up with a passwords.

I just got the same error... here is my situation and solution..

Example...

===================

Here is the backup code..

===================

BACKUP DATABASE [myDatabase] TO DISK = \\myComputer\backup\myData.bak with INIT, PASSWORD='password123';

========================

Here is the restore command...

========================

RESTORE database myDatabase FROM DISK = N'c:\backup\myData.bak' with PASSWORD='password123';

---

VFP Programmer

Answer 19

That is because the backup file failed halfway through, need to restore from tape or backup the file again :)

Answer 20

May be the back varies the sql server version.

---

DA