tags:

views:

34

answers:

1
Q: 

Attaching a database

I am trying to attach a database in sql 2005 but I get an error msg that the _log.ldf file was not found

How do I create the _log.ldf file?

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'localhost'. (Microsoft.SqlServer.Smo)

ADDITIONAL INFORMATION:

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

Directory lookup for the file "C:\CreateMDF\TimeTracker_log.LDF" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft SQL Server, Error: 5133)

+1  A: 

If you don't specify a log file for creation then SQL Server should create a new one.

You can click the remove button for the log if you're attaching via the management console or you can have no log file specified if you're attaching via a script.

melkisadek  2010-01-07 04:34:37
I am guessing SQL did not create one itself Do I lose functionality or performance if click on the remove button? Thanks
Csharp  2010-01-07 04:37:06
I am getting an error when I run my database scripts:A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Csharp  2010-01-07 04:43:19
If you're attaching a db to a server (as opposed to a restore from backup) then the general assumption would be that it had completed all it's previous transactions. Therefore removing the transaction log and letting SQL Server create from new should not affect functionality or performance.
melkisadek  2010-01-07 13:55:35
The other error is a connection problem. As you're using a local SQL instance I'd guess that the second solution might work from here: http://msdn.microsoft.com/en-us/library/ms175496.aspx
melkisadek  2010-01-07 13:59:20
Thanks very much !!
Csharp  2010-01-08 16:53:41

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting