Database mdf ldf files

Michael Green 22k 12 12 gold badges 44 44 silver badges 85 85 bronze badges. Hope this helps! Hector Hector 1, 1 1 gold badge 8 8 silver badges 22 22 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. Linked 2. Related Hot Network Questions.

If a database is being used by any application, this step cannot be accomplished, unless all connections to a database are closed. Otherwise, the following error will appears:. Instead of the current account, switch to the one that has access to a drive where files are moved:. Once this is done, a SQL database will be hosted on a drive with sufficient free space and the user can continue using it.

FROM sys. Author Recent Posts. Marko Radakovic. These files play a very crucial role in the backup and recovery process of the database. They can be:. Before following either of the above-mentioned methods, certain prerequisites need to be fulfilled:. Once you execute this command successfully, refresh the database and you will see the newly restored database under the Object Explorer. The above-mentioned manual methods may not work if the SQL primary database is corrupted. In such a situation, you first need to repair the corrupted MDF file and then attach the healthy file with the SQL server.