Recently I encountered an SQL server 2000 file. ldf is damaged, but mdf is still there. So I tried to restore it. I found some methods on the Internet,
Summary
1) back up the original database files (such as test. mdf) to other places in time2) Stop the server3) Delete the test. mdf file.4) re-create a database with the same name as test.5) Delete the test. ldf
create a database for recovery (such as test ). It can be created in SQL Server Enterprise Manager.B. Stop the database server.C. Delete the log file test_log.ldf of the database you just generated, and overwrite the generated database data file test_data.mdf with the MDF file to be restored.D. Start the database server. In this case, the database test status is "Suspect ". At this time, you cannot perform any operations on this database.E. Set the d
recovery use. Can be built in SQL Server Enterprise Manager.
B Deactivate the database server.
C Delete the log file test_log.ldf the database you just generated, overwriting the database data file you just generated with the database MDF file you want to recover test_data.mdf.
D Start the database server. You will see that the state of the database test is suspect. No action can be made on this database at this time.
E. Setting the database allows d
mdf file to be restored.D. Start the database server. In this case, the database test status is "Suspect ". At this time, you cannot perform any operations on this database.E. Set the database to allow direct operation of system tables. In SQL server enterprise manager, right-click the database server and select "properties". On the "server Settings" Page, select "allow direct modification to system directory. You can also use the following statement
Restoration Technology for MDF files in SQLServer
Restoration Technology for MDF files in SQL Server
First, place the file to be restored in the DATA file in ms SQL, and enter the ms SQL master database server.
1. We use the default method to create a database for recovery (such as MHDYF2005 ). It can be created in SQL Server.
2. Stop the database server.
3. Delete the log file MHDYF2005_log.ldf of the
It is very convenient to use the mdf file embedded in the program in the project for SQL Server database tutorial development. It is convenient to release open-source projects. You can click it to run it without deployment, this is especially useful in teaching. teachers do not need to detach database files to students or attach database files. The mdf file is embedded in the project. The instructor sends t
It is very convenient to use the MDF file embedded in the program in the project for sqlserver database development. It is convenient to release open-source projects. You can click it to run it without deployment, this is especially useful in teaching. teachers do not need to detach database files to students or attach database files. The MDF file is embedded in the project. The instructor sends the lecture
It is very convenient to use the mdf file embedded in the program in the project for SQLServer database development. It is convenient to release open-source projects. You can click it to run it without deployment, especially in teaching, it is more convenient to use. teachers do not need to detach database files and send them to students, and students do not need to attach database files. When the mdf file
Anatomy of the Swiss Army Knife of SQL Server 16th orcamdf rawdatabase--mdf file (translated)http://improve.dk/orcamdf-rawdatabase-a-swiss-army-knife-for-mdf-files/When I first started to develop Orcamdf, I had only one goal, more than most of the books on the market to get a deeper level of knowledge inside MDF filesAs time went on, Orcamdf did. At the time I ha
server| Recovery | data | database
First the files to be recovered in MS SQL data file, into the MS SQL master database server
1. We use the default method to establish a database (such as MHDYF2005) for recovery use. Can be built in SQL Server.
2. Deactivate the database server.
3. Delete the log file mhdyf2005_log.ldf the database you just generated, overwriting the database data file mhdyf2005_data.mdf that you just generated with the database MDF
In the project to embed the MDF file in the program to do the SQL Server database tutorial development is very convenient, used to publish open source projects and so very convenient, click on can run, no deployment, especially in teaching to use more convenient, teachers do not have to first detach the database files to students, Students also do not have to attach database files. Using the embedded MDF fi
First, the preface
As we all know, with the rapid development of the telecommunications industry, online operation of MDF has reached hundreds of millions of. In particular, the environment around the rural end of the perimeter cable is relatively complex, so there are often a variety of external hazards on the cable line, including the impact of the power line is the most serious. If the MDF fire accident
During the demonstration of layer-3 architecture development for my students, I used winform in vs2005 to establish the Dal, BLL, and uilayer-3 architectures, and used strong datasets in the Dal layer, bll layer processing logic.
ProgramAfter running, the update, insert, delete, and other operations on the tableadapter take effect. Then I observe the MDF file and the data is not updated. when winform is disabled and winform is restarted, it is found
Written in front:Work often encounter the need to move the database to another computer, back up and then lead in it is very troublesome, simply to copy the entire data file in the past.If copying the. mdf file from the source database is unsuccessful, you must stop the DB instance. Drop to new database pathC:\Program Files (x86) \microsoft SQL Server\mssql10_50.mssqlserver\mssql\data Startup Discovery does not recognize the database.However, my datab
First, place the file to be restored in the DATA file in ms SQL, and enter the ms SQL master database server.
1. We use the default method to create a database for recovery (such as MHDYF2005 ). It can be created in SQL Server.
2. Stop the database server.
3. Delete the log file MHDYF2005_log.ldf of the generated database and overwrite the generated database data file MHDYF2005_data.mdf with the mdfyu1.mdf.
4. Start the database server. After refresh)
First, place the file to be restored in the data file in ms SQL. after entering the ms SQL master database server
1. We use the default method to create a database for recovery (such as mhdyf2005 ). It can be created in SQL Server.
2. Stop the database server.
3. Delete the log file mhdyf2005_log.ldf of the database you just generated, and overwrite the generated database data file mhdyf2005_data.mdf with the MDF file of the database you want to recov
First, place the file to be restored in the data file in ms SQL, and enter the ms SQL master database server.
1. We use the default method to create a database for recovery (such as mhdyf2005 ). It can be created in SQL Server.
2. Stop the database server.
3. Delete the log file mhdyf2005_log.ldf of the database you just generated, and overwrite the generated database data file mhdyf2005_data.mdf with the MDF file of the database you want to r
Task: Import pubs againYou can use sp_attach_db in this way. It is very simple to use pubs to pass the test.
Process:1. Stop MSSQLServer and run E: \ Program Files \ Microsoft SQL In the MSSQL installation directory.
Server \ MSSQL \ data \ pubs. MDF and E: \ Program Files \ Microsoft SQL Server \ MSSQL \ data \ pubs_log.ldf
Removed.2. Restart MSSQLServer. in SQL Server Enterprise Manager, you can see that the pubs icon is dimmed with a '(doubt
How SQL Server 2008 Imports MDF,LDF filesOnline find a lot of solution SQL Server import other computer copy the MDF file, most of it is not complete, the solution is not the same as the problem, the bottom is to find the most comprehensive method to solve the problem!Import the MDF, LDF file into the SQL Server 2008 database, which provides two ways:The first ty
However, if your database files are copied from other computers, the above method may not work. You may get an error message similar to the following.
Server: Message 1813, level 16, status 2, Row 1
Failed to open the new database 'test '. Create database will be terminated.
Device activation error. The physical file name 'd: \ test_log.ldf' may be incorrect.
What should we do? Don't worry. The following is an example of the restoration method.
A. We use the default method to create a database f
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.