Error attaching a mdf without LDF

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Error attaching a mdf without LDF

Author

Topic

mleon33
Starting Member

3 Posts

Posted - 2004-12-10 : 09:07:44

Hi Friends:

I am attaching a MDF file who I don't know if was deattached with the right command. Well, I must to attach this file again, but; when use the following commands I receive this errors:

Remember, I don't have the LDF file, that it must exist, but I have loose this.

Servidor: mensaje 1813, nivel 16, estado 2, línea 1
No se puede abrir la nueva base de datos 'LALO'. CREATE DATABASE cancelada.
Error de activación de dispositivo.
El nombre de archivo físico 'c:\archivos de programa\microsoft sql server\mssql\data\03Jaidos_log.ldf'
puede ser incorrecto.

whe use single_file too
please help me to resolve this problem.
Thankz

Marco Antonio Garcia Leon
Peru

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-10 : 10:33:57

hmm
Servant: message 1813, level 16, been 2, line 1 cannot be opened the new data base 'LALO'. Cancelled CREATE DATABASE. Error of activation of device. The 'c:\archivos physical file name of programa\microsoft SQL server\mssql\data\03Jaidos_log.ldf' it can be incorrect.

Are you trying with sp_attach_single_file_db?
If so and there isn't an ldf file in the directory with the correct name (it would try to use it even though it's not specified.
Sounds like you are out of luck.

You can get access to the database and copy things out using this
http://www.nigelrivett.net/RecoverCorruptDatabase.html

==========================================
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.

mleon33
Starting Member

3 Posts

Posted - 2004-12-11 : 08:23:59

Thankz NR:

But, this page refer to a database who need to be overwrite with another database, is not my case.

I have a MDB, but I don't have the LDF files.
When try with this SP's like attach_db, silge_file_db, I don't have results, only errors, because this SP's find the LDF files, that I don't have.

I'm finding some solutions like reset status, or another; please help me to found this.

Thanks to all again, and NR.

Marco Antonio Garcia Leon
Peru

mleon33
Starting Member

3 Posts

Posted - 2004-12-11 : 13:03:24

Hi NR:

Thankz a lot for u support, u have been right, and I was wrong, sorry for this. This link helps me to resolve the problem with my database. Thankz a lot again and sorry.

Marco Antonio Garcia Leon
Peru

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources