Attach mdf file without ldf file in Database

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not open new database 'MyLostDB'. CREATE DATABASE is aborted.
File activation failure. The physical file name "C:\xxx\MyLostDB.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. (Microsoft SQL Server, Error: 1813)

• Related Articles

• How to setup printer to print into Generic/text only file?

  Steps 1.Right click on My computer 2.Properties>>hardware>>device manager>> ports>> disable lpt1 3.start>> settings>>printers &faxes 4.right click>> add printer 5.select local>>next 6.create a new point>>next 7.enter a port name(path e.g ...

• Query to search database for Column Name in tables

  Use YourDatabase SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%MyColumn%' ORDER BY schema_name, table_name;

• List all the databases on SQL Server in the order they were created and their physical file path

  SELECT name, crdate, filename FROM master..sysdatabases ORDER BY crdate or SELECT * FROM sys.databases ORDER BY create_date