<div>
Got an error with that too but tried another backup which worked so I may have a corruption
</div>


Got an error with that too but tried another backup which worked so I may have a corruption

<div>
Another backup worked ok so I guess it must have been some sort of corruption
</div>


Another backup worked ok so I guess it must have been some sort of corruption

<div>
please checck the database using the query<br />
<br />
restore verifyonly from disk='c:\***********path of the backup file'<br />
<br />
RESTORE &nbsp;filelistonly<br />
from disk = 'C:\Krishna\Krishnafile pathn.bak'<br />
<br />
<br />

</div>


please checck the database using the query

restore verifyonly from disk='c:\***********path of the backup file'

RESTORE  filelistonly
from disk = 'C:\Krishna\Krishnafile pathn.bak'




<div>
<div class="content wysiwyg-content">
I was under the impression you could do this however when I try when I select the backup file as the source I get an error dialog saying<br />
<br />
&quot;Specified cast is invalid. (SQLManagerUI)&quot;<br />
<br />
Am I missing something?<br />
<br />
TIA
</div>
</div>


I was under the impression you could do this however when I try when I select the backup file as the source I get an error dialog saying

"Specified cast is invalid. (SQLManagerUI)"

Am I missing something?

TIA

Restore 2005 backup to 2008 database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.