Solved How can I do restoration of the database without the log fil

Microsoft Sql server 2008 standard editi...
June 17, 2015 at 06:49:21
Specs: Windows 7, Pentium 4 2GHz / 4 gigs
I have large database of 1.5 TB. As it turned out the log file was on another drive. The base was deactivated in the normal mode and at the time of cancellation does not contain mistakes. I try to attach base - management studio takes off. The base was in the simple mode - so in the log anything useful wasn't. Tell me whether you can pull the data in such a case, and what is operations procedure?..

See More: How can I do restoration of the database without the log fil

Report •

June 18, 2015 at 08:20:36
✔ Best Answer
Try this:
CREATE DATABASE YourDatabaseName ON (FILENAME = N'FilePath.mdf')
If that doesn't work, let's see what errors in the log server.
P. S. The Fact that the database is in Simple mode does not mean that the transaction log is unnecessary ballast. The transaction log is a critical part of the database, regardless of recovery model.
If gives out: File activation failure. The physical file name "M:\Order_Log_log.ldf" may be incorrect.
The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'YourDatabaseName'. CREATE DATABASE is aborted.
Then, the only hands you can try to pull data into a new database, if they are valuable.
See more recommendations here. Maybe you find the solution to your problem.

Report •
Related Solutions

Ask Question