Select Categories Below
Status: Closed Points: 100 Time: 22:15 - Oct 06, 2006
theDude
I need to restore a backup on an ms sql server 2000 (msde version). But it's on a remote server, and I don't have access via enterprise manager, only through remote desktop connection. So I've uploaded the backup of the database, but I can't figure out how to restore the database through the command prompt. Can anybody help me?
Categories:
Add Categories
When adding more than one category, separate them with commas.
Advertisement
Date:: Oct 10, 2006
Time:: 11:18
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.
Question Answered
This question has been closed, 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 a Tutorial in the Tutorial Area.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
does the msde database have limitations on scheduled backups?
A server with this name already exists - sql server 2000 problem
how to export a database from ms sql server to access?
change owner of objects in ms sql server
You have 100 characters to use
Rank
Expert
Points
1.
50
2.
30
3.
25
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software Real Estate Postcards Marketing Fulfillment