|
Well, I figured out how to do it:
The command prompt is run like this:
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\OSQL.EXE" -E
Then write these lines to restore the database:
restore database mydbname from DISK = 'C:\xxx\xxx\xxx' with move 'database_Data' to 'C:\Database\xxx\database_Data.mdf', move 'database_Log' to 'C:\Database\xxx\database_Log.LDF'
go
It was the "WITH MOVE" that gave me problems. If you're restoring on another machine that doesn't have the exact same directory structure, then you need to add that.
|
|
Expert:
|
theDude
|
|
Date:
|
Oct 10, 2006
|
|
Time:
|
11:18
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
|
|
|
|
This question has been answered, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for this question by clicking on the "Answer Summaries" Tab.
|
|