Showing posts with label grown. Show all posts
Showing posts with label grown. Show all posts

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