I've been getting the following error message:
"Server: Msg 9002, Level 17, State 2, Line 1
The log file for database 'msdb' is full. Back up the
transaction log for the database to free up some log
space."
eventhough i've backed up the log file & shrunk the
database with
"backup log msdb with no_log
dbcc shrinkdatabase (msdb)".

The same thing happened to "tempdb" too.
What can I do to resolve the transaction log problem?

How do I change the default location of the mentioned
databases to a bigger hardisk?

Thanks a million!!

To move the log, read KB article 224071. In general, you detach and attach, but it is different for
tempdb.

Why do you shrink the database. Doing regular log backups will empty the log. No need to shrink the
file as well...

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


"Wendy W" <wendy_wrp (AT) wrpworld (DOT) com> wrote

Sometimes it helps to increase the growth increment of those databases as
well (especially Tempdb)

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Wendy W" <wendy_wrp (AT) wrpworld (DOT) com> wrote

Wendy

I agree with Tibor.

I am a little puzzled what the thinking is that after
getting a message telling you a database is full, one of
your actions is to try to shrink the database?????????

Regards

John