How do I restore to another SQL database with BrightStor ?

Not possible to extract the mdf/ldf files, but you can very well restore to alternate server/ alternate path to the same server with different DB name. you need to do the restore of each database with one restore job as this is a restore to alternate location. just specify the different database name in the destination tab and in the source tab, change the local path of the mdf/ldf files. Follow the instructions in the link below.

https://www.experts-exchange.com/questions/24140436/Restore-SQL-Data-files-in-ARCserve-11-5.html

Let me know if you have further questions.

Hi Aswin,

Unfortunatly this doesn't work. I get this error:

BrightStor ARCserve Backup -- Restore


Job No....................... 6
Job ID....................... 396
Workstation.................. SRV002
Source....................... WK1WOENSDAG, ID D7E5, Sequence #1
Session...................... 4
Target....................... \\DB01\dbasql@MSSQLSERVER
Start Time................... 02-03-09 14:08  


N8647
Restoring Database 'TempPrijzen'.
E8617
Failed to end restore. (DBNAME=TempPrijzen, EC=DB01:[SQL Server] szSqlState = 37000,fNativeError = 3154, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The backup set holds a backup of a database other than the existing 'TempPrijzen' database.)
\\DB01\dbasql@MSSQLSERVER                                                      


Total Database(s)............ 1
Total Skip(s)................ 0
Total Size (DB).............. 192 KB
Total Size (Media)........... 256 KB
Elapsed Time................. 13s
Average Throughput........... 1,15 MB/min
Total Error(s)/Warning(s).... 1/0

Any thoughts ?

Thanks,
Gerard

Can you check if you are trying to restoring from an incremental backup? post the screen shots of the restore window- Source Tab, Agent options and destination tab.

See attachments. This is a restore from a full backup (we only run full back-ups). I also tried the 'files or filegroups' option in the agent. The folder c:\temp does exist on the destination (database) server as well as on the back-up server.

Also tried another approach: In the prevous scenario (of the screenshots) the destination database already existed. Because I miss the 'Force Overwrite' in the Agent I also tried it after deleting the destination database first. The error I get then is:

Failed to end restore. (DBNAME=MyTempDB, EC=DB01:[SQL Server] szSqlState = 37000,fNativeError = 1834, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'G:\MSSQL\DATA\AX2009.mdf' cannot be overwritten.  It is being used by database 'AX2009'.)
\\DB01\dbasql@MSSQLSERVER

To be clear: The MyTempDB does not exist on the destination server. The location he's trying to write to (G:\MSSQL....) is the location of the original database, even if I have set this to c:\temp in the Agent.

Maybe this sheds some additonal light ?

Thanks for your help !
Gerard

Destination.png
source.png
AgentOptions.png

Cool !!!! That did the trick !

Thanks very much for your support !

Cheers,
Gerard