Friday, March 23, 2012

Reissue restore statement

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