I am trying to restore a database but i keep getting an eror message saying
"reissue restore statement using with replace to overwrite existing files."
How can I get around this problem to get my datatabsed restored? I am abit of a novice as well so i could do with some easy to understand instructions.
Thank you for your time
RESTORE DATABASE MyDb FROM <insert info here>WITH REPLACE
The above will "get around" the problem you experience. Essentially you are OVERWRITING YOUR EXISTING DATABASE THOUGH so be careful!
Hope this helps -
Scott Whigham
Check out my SQL Server 2005 Video Tutorials: http://www.learnsqlserver.com/
|||Cheers for the help scott.
Do i need to type that into a query? Also this bithere RESTORE DATABASE MyDb FROM <insert info here>
is this the destination of my backup for example mydocuments/testdb
No comments:
Post a Comment