Log File Problem

Hi EveryBody...
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.
Plz help in this regard.Meonline (jawadsmail@.gmail.com) writes:

Quote:

Originally Posted by

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql