Solved

Restore database from another computer

Posted on 2003-10-29
2
382 Views
Last Modified: 2012-05-04
How to setup automatic restore of the backup which was made on another computer, and path of the folder Data iks not the same?
0
Comment
Question by:TanjaMar
2 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 9643923
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
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 50 total points
ID: 9644547
If the data files are in a different location, you need to specify the MOVE option also:

RESTORE DATABASE yourDatabaseNameHere
FROM DISK = 'x:\full\path\to\backup\backup.bak'
WITH MOVE 'logical_data_file_name' TO 'operating_system_data_file_name',
                   'logical_log_file_name' TO 'operating_system_log_file_name',
          RECOVERY
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question