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.You can try sp_attach_single_file_db. If that doesn't work, you should restore from your most recent
backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Me On Line" <jawadsmail@.gmail.com> wrote in message
news:1178171246.741385.324940@.h2g2000hsg.googlegroups.com...
> 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.
>|||The next question would be - Why do you mess around with your sql server
logs like that? To me it makes no sense. From your description it sounds
like your logfile was full and it wasn't allowed to grow, but why don't
you just backup (or truncate) the logfile?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Tibor Karaszi wrote:
> You can try sp_attach_single_file_db. If that doesn't work, you should
> restore from your most recent backup.
>