Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SHRINKING LOGFILE

Author  Topic 

marat
Yak Posting Veteran

85 Posts

Posted - 2005-05-10 : 20:16:45
I am trying to shring log file and getting an error:
Cannot shrink log file 2 (Freedom_Log) because requested size (36864KB) is larger than the start of the last logical log file.
What can I do?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-10 : 20:26:33
Your log file is already smaller than the size you're trying to shrink it to.
Go to Top of Page

marat
Yak Posting Veteran

85 Posts

Posted - 2005-05-10 : 20:46:08
Thanks,
How can I avoid error message?
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-10 : 20:48:58
Don't try to shrink the log to a size that's bigger than it already is.
Go to Top of Page

marat
Yak Posting Veteran

85 Posts

Posted - 2005-05-10 : 20:54:31
Thank you
Go to Top of Page
   

- Advertisement -