I have a database backup file I need to restore in SQL Server 2008. I get an error
Specified cast is not valid. (SqlManagerUI)
I have a database backup file I need to restore in SQL Server 2008. I get an error
Specified cast is not valid. (SqlManagerUI)
Try this first and see if the backup is healthy:
DO
RESTORE FILELISTONLY FROM DISK = N'YOURFILE.bak'
then we can take it from there
Please check the Sql server version of the database from where you have backed up the version of database must be same or upper .Only then you can restore the database backup