When you create a new database by means of restore you usually need to options added: REPLACE is needed to disable a normal check that occurs during RESTORE and which prevents you from replacing a database with the content of another database from a backup set. MOVE is needed to move logical files in the backup set to new locations.
For details see Copying Databases with Backup and Restore. Remus Rusanu Remus Rusanu k 39 39 gold badges silver badges bronze badges. ForceMagic 5, 11 11 gold badges 63 63 silver badges 85 85 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta.
New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Server Express. Sign in to vote. Wednesday, October 21, PM.
Thanks, Leks. Thursday, October 22, AM. Yeah am sure that's the file extension which it has got when backing up my database. Thanks for information supplied which I need to be careful in future while backing up my database. Ps: "D drive is the place where my backup file is store". I am still confused on what to write after the "Database". The errors which i get when executing :. Operating system error 2 failed to retrieve text for this error.
I tried it out last night and I was able to restore without any problems. Narayana Narayana 3 3 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
0コメント