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.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-06-23 : 01:25:06
|
| hii have shrink log file of database use dbcc commandMessageExecuted as user: sa. Cannot shrink log file 2 (abc.ldf) because all logical log files are in use. [SQLSTATE 01000] (Message 9008) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528). The step succeeded. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-23 : 01:53:07
|
| http://surf11.com/entry/173/cannot-shrink-log-file-because-all-logichttp://www.karaszi.com/SQLServer/info_dont_shrink.asp |
 |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-23 : 14:44:33
|
| Check is there any transactions are opened or not. If any transaction is open you can not shrink the log file. Either you need to kill the process or else you need to wait till the process get completed.To Kill process,sp_kill <spid>Check for the SPIDsp_who2 ActiveManojMCP, MCTS |
|
|
|
|
|
|
Shrink Log file database in sql2005