Follow us

Monday, November 28, 2011

MS SQL Troubleshoot #2 :: Specified cast is not valid

Error

"Specified cast is not specified. (SqlManagerUI)" while restoring Database.

Specified cast is not specified. (SqlManagerUI)

Scenerio

I took database backup on SQL SERVER 2008 and tried restoring it on SQL SERVER 2008 R2. Ideally, it should work fine but while selecting backup file, SQL Management Studio 2208 R2 was raising error "Specified cast is not specified. (SqlManagerUI)".

Reason & Troubleshoot

This was due to .BAK file corruption during FTP transfer (transfer mode is set to ASCII).
Always, remember to set FTP transfer mode to BINARY while transferring database .BAK file.

Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

1 comments: on "MS SQL Troubleshoot #2 :: Specified cast is not valid"

Maximuz Jams said...

I had same problem with downloading from http://yadi.sk

Post a Comment