<div>
What do you mean &quot;automatic restore&quot;?<br />
<br />
You can use enterprise manager to setup a scheduled job with TSQL:<br />
<br />
RESTORE database yourdatabasenamehere from disk='yourdrive\pathhere'<br />
<br />
Brett
</div>


What do you mean "automatic restore"?

You can use enterprise manager to setup a scheduled job with TSQL:

RESTORE database yourdatabasenamehere from disk='yourdrive\pathhere'

Brett

<div>
<div class="content wysiwyg-content">
How to setup automatic restore of the backup which was made on another computer, and path of the folder Data iks not the same?
</div>
</div>


How to setup automatic restore of the backup which was made on another computer, and path of the folder Data iks not the same?

Restore database from another computer

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.