quote:

---

Should always take a backup before doing this.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

quote:

---

I faced the same problem when i tried to attach my own created ldf file. try to attach again without giving the ldf say..
sp_attach_db @dbname='test', @filename1='c:\test_data.mdf'

Regards,
Sekar

Edited by - samsekar on 03/04/2003 05:01:09

---

quote:

---

If I dont' provide the log file name it says:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'humdono'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'F:\database\log\database_log.ldf' may be incorrect.
Device activation error. The physical file name 'F:\database\log\database_log1.ldf' may be incorrect.

---

quote:

---

You also need to delete or rename the old log file otherwise it will still use it.

---

quote:

---

quote:

---

You also need to delete or rename the old log file otherwise it will still use it.

---

Yeah I was going to mention that too, but I guess I forgot.

Tara

---

quote:

---

quote:

---

If I dont' provide the log file name it says:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'humdono'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'F:\database\log\database_log.ldf' may be incorrect.
Device activation error. The physical file name 'F:\database\log\database_log1.ldf' may be incorrect.

---

Ok I tried using the following command:
sp_attach_single_file_db @dbname='test',@physname = 'f:\database\data\test_data.mdf'


And before that I had renamed the log files
but it gave me the following error:

Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'test'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'F:\database\log\test_log.ldf' may be incorrect.
Device activation error. The physical file name 'F:\database\log\test_log1.ldf' may be incorrect.


so this does not seem to work.
Any more Ideas please??
thanks for u'r time.
Regards,
Harshal.

What is the command that you used to attach the database without a log file? You need to use sp_attach_single_file_db. Is that what you used?


Tara

---

quote:

---

We can use Create Database For Attach option but a new log file will be created and the data from the old log file will be lost. let me explain the scenario i tried here for the problem. i copied distmdl.mdf file and pasted the same as dummy.mdf and i renamed the distmdl.ldf file to x.ldf.
Then i tried these query.

CREATE DATABASE dummy
ON PRIMARY
(NAME='DummyData',
FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\dummy.mdf')
FOR ATTACH
GO

The Result is
Device activation error. The physical file name 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\distmdl.ldf' may be incorrect.
New log file 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\dummy_log.LDF' was created.

The database was created successfully with a new log file.
I belive these will help you. All the Best

Regards,
Sekar

---

quote:

---

sekar,
As a matter of fact this also didn'work it gave me the same error when I tried renaming the log files ,and after creating a dummy log file of the same name as before it give me the following error:


Server: Msg 823, Level 24, State 6, Line 1
I/O error 38(Reached the end of the file.) detected during read at offset 0000000000000000 in file 'F:\database\log\test_log.ldf'.

Connection Broken


Expect the UnExpected

---

quote:

---

Shrinking the files is not going to fix your problem, well at least in my opinion. You can not create the database and specify a file that already exists. It has to be a new file. Since that file exists, your only option is to attach it. I realize that attaching isn't working, so you are going to have to restore the database from the backup that you mentioned that you did prior to detaching it.

I would also suggest checking to see if you have any hardware problems. The fact that it is having problems creating a log might mean that you are having disk problems.

Tara

---

quote:

---

The BOL Says.
FOR ATTACH

Specifies that a database is attached from an existing set of operating system files. There .... Use the sp_attach_db system stored procedure instead of using CREATE DATABASE FOR ATTACH directly. Use CREATE DATABASE FOR ATTACH only when you must specify more than 16 <filespec> items.

Means, We can attach existing files also.
What is your opinion on this tara ??

---