You'll need to increase the available space on the drive of where the database is being restored to, in order to restore that backup.Īlso when i checked i can see db restore can also be done by mdf files attaching It is not possible to even omit the Transaction Log file ( LDF) and create a new one, when restoring from a backup. Nope, you need both to have a functioning database. Is there a way to do it by omiting these files. The LDF file is the Transaction Log file, which logs all the transactions that occurred in the database to put the MDF in it's current state, essentially. The MDF is the data file for your database, that holds all the data in its current state. When i tried it is showing insufficient disk space becuase the mdf and ldf files are also moving and in those ldf is aroud 100GB.Ĭorrect, the MDF and LDF files are the database, which are stored in the backup file.
0 kommentar(er)
