Posted by Erland Sommarskog on 05/03/07 08:48

Meonline (jawadsmail@gmail.com) writes:
> I am using SQL server 2000 and i was working on Strore procedure and
> manupulating tables.Sql Server shows me messages that ur log size is
> Increased and as a result it does not allow me to do any
> manupulations.so I de attached the database and rename it and increase
> its log file. Now ,I try to re attached the database,but Server show me
> messages ,Its not valid log file.
>
> Then i rename it to its origional name,but the problem remains the
> same.
> Its not a valid log file.
> then i move it to some other place and try to attacah but its not
> again.
>
> after that i move this log and mdf files to other Ms SQL server.But
> problem is not solved.

Looks you got yourself into things you should not have touched. I don't
see what the point would with renaming the database files, if you ran
out of disk space? The normal procedure would be to add more disk, or
add a new log file on a second partition. Or simply investigate whether
it was reasonable that your procedure resulted in such an increase in
log space consumption.

Anwyay, if you detached the databse cleanly, you should be able to
reattach it with sp_attach_single_file_db.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]