Sunday, February 19, 2012

Error starting the SQL service after renaming one of the log files..

Is there anyone out there who can help me ? Please ? ?
The log file for one of the MSSQL 2000 databases ha grown really big.
(15 GB)
After setting a limit on the size to grow, the log file date did not
modifie.
After a few weaks I stopped the SQL service, and renamed the log file.
When I was trying to start the SQL again, it would not start. Even
not when I gave the log file back its old name.
Is there any way to restart / restore the SQL service / database
without a backup ? ?
Regards,
ØivindWhen you try to start the service, what message do you get?
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind|||If the error messages are correct... simply
Restore database model with recovery
Restore database axdb with recovery
the error messages say you have started a recovery that was not completed..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind

No comments:

Post a Comment