Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to do "WITH MOVE" in MSDE?

Status
Not open for further replies.
SatishPutcha

SatishPutcha

Programmer
Joined
Mar 12, 2002
Messages
256
Location
IN
Hello to Everybody

I have the backup-ed file of an SQL database. I am trying to restore it using "MSDE"(SQL Server 2000 Desktop Engine). However, I am getting the error

"The physical file name d:\database\db1_backup.mdf cannot be found. Use WITH MOVE to identify a valid location"

Now since I am using an Access Data Project for restorng this DB I am not sure how to use WITH MOVE.

Can anybody please help?

Regards
Satish
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
How Do I Add Column to Middle of Table
Replies
4
Views
1K
BobSuruncle
BobSuruncle
grnzbra
  • Locked
  • Question Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros
WomanPro
  • Locked
  • Question Question
Insert into query adds records to unreadable format, how do I change that?
Replies
5
Views
832
Chris Miller
Chris Miller
dgillz
  • Locked
  • Question Question
How to convert varchar to time?
Replies
1
Views
1K
Chris Miller
Chris Miller
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
921
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top