This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › How to restore an MDF format database file without a .ldf log file...
View: 10851|Reply: 0

[Source] How to restore an MDF database file without a .ldf log file

[Copy link]
Posted on 2/9/2015 9:49:12 AM | | |
After SQL installation, you can link the local instance, and normally you can attach the database directly, but these decompressed files do not have .ldf log files, and all can only be restored through commands
For example: the database name is in front and the unzipped file location is followed

  1. sp_attach_single_file_db @dbname=  ’GroupData5_Data’ ,
  2. @physname= ‘E:\baiduyundownload\QQ数据库\QQ数据库\QQ数据库\QQ数据库\QunData\GroupData5_Data.MDF’
Copy code






Previous:iPhone lock screen password is only set to 4 digits? Crack in 10 minutes
Next:The identification column in the table 'Area' can only be used if a list of columns is used and IDENTITY_INSERT is ON

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com