Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2626
  • Last Modified:

Restore SQL Data files in ARCserve 11.5

Hi I hope someone can help.

Does any one know how to restore an SQL Database to an alternate location when using ARCserve 11.5 & the SQL Agent?
0
Supportteam
Asked:
Supportteam
  • 2
1 Solution
 
ashwin_kumar525Commented:
I am assuming that you want to restore to the same server but to an alternate path.

When u r in the restore by session, locate the SQL DB session. right click on it,  Agent Options-> change the physical file location for both mdf and ldf files pointing to a new path. It should be a local path on the SQL Server. Make sure the path exists on the SQL server.

now go to destination tab and uncheck the option restore files to their original location, expand the SQL server from the list and highlight the SQL golden platter. Specify a new name for the DB under the restore path so that it wont conflict with the existing one. Restore path looks something like \\SQLServerName\dbasql@SQLInstance\<NewSQLDBName>

Click on start and make sure to provide credentials in both the Machine and DBAgent tab.

all the best.

0
 
SupportteamAuthor Commented:
Thats it perfect, thank you very much.
0
 
Jubal1234Commented:
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
0
 
Jubal1234Commented:
Sorry... Posted this in the wrong thread !
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now