<div>
<div class="content wysiwyg-content">
I'm trying to copy an SQL backup file from tape using backup exec, the problem is i do not want to restore the SQL file &nbsp;i want to be able to copy the file to another location (external hdd) for testing in a different environment.<br />
<br />
if i try to restore to the external hdd it fails.<br />
<br />
Any ideas?
</div>
</div>


I'm trying to copy an SQL backup file from tape using backup exec, the problem is i do not want to restore the SQL file  i want to be able to copy the file to another location (external hdd) for testing in a different environment.

if i try to restore to the external hdd it fails.

Any ideas?

how to copy an sql backup file from backup exec without using restore

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

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.