This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hello,
We have Sql Server 2019 and we need to restore the database using .MDF and .LDF file into existing database.
We have received .MDF and .LDF file from another server which is also Sql 2019 and our current server which has already database which is also Sql 2019.
I would like to know what's the best way and how I can restore using .MDF and .LDF file on different server which has already database.
Please keep in mind that Source server which contains .MDF and .LDF files has same Database name which had into Target database name
Source: .MDF and .LDF file
Target Database: SqlDB
Thanks for your help!
If you have a pair of MDF and LDF files, you need to attach them as:
CREATE DATABASE thisdb ON (NAME = 'thisdb', FILENAME = '<path>.mdf')
LOG ON (NAME = 'thisdb_log', FILENAME = '<path>.ldf')
FOR ATTACH
If the database you want to attach the database under is already taken, you need to do one of:
Erland,
Thanks for prompt response.
I have already database running so I need to refresh same existing database.
Is it I can overwrite or replace the database?
When you attach a database you are effectively creating a new database on the server. Which you do with RESTORE as well, for that matter. However, while with RESTORE you can over-write an existing database, you cannot do this when you attach file. If you wish to replace an existing database, you need to drop that database first.
Thanks Erland.
I was just little confused as need to first Detach then attach but it didn't, your suggestion was helpful.
Appreciate your tips.