We help IT Professionals succeed at work.

Restore SQL Data files in ARCserve 11.5

Supportteam
Supportteam asked
on
Medium Priority
2,677 Views
Last Modified: 2013-01-22
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?
Comment
Watch Question

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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thats it perfect, thank you very much.
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
Sorry... Posted this in the wrong thread !
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.