Error: Specified cast is not valid. (SqlManagerUI)


Error: Specified cast is not valid. (SqlManagerUI)

Description: While trying to restore a database using SQL Server Management Studio, this error dialogue box pops up. When we go for detailed error, there is nothing much helps us to identify the root cause of the problem. Before restoring we should follow below steps.

Solution:

1. Make sure the source and target database server version is same or not.

2. Check whether the backup database copy is not corrupted.

RESTORE VERIFYONLY FROM DISK = N’C:\Backup\12345test.bak’

3. If using FTP transfer softwares to move the backup files, make sure to set the FTP transfer mode to BINARY from ASCII.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s