<div>
In query analyzer, change the pull-down, active DB, from SFS_GENIE, to &quot;master&quot; or something.
</div>


In query analyzer, change the pull-down, active DB, from SFS_GENIE, to "master" or something.

<div>
That didn't work. I ran a sp_who command to make sure that there are no open connections to the SFS_Genie database.<br />
<br />
I also tried<br />
dbcc shrinkfile( sfs_genie_log,1)<br />
but that gave me the same message.
</div>


That didn't work. I ran a sp_who command to make sure that there are no open connections to the SFS_Genie database.

I also tried
dbcc shrinkfile( sfs_genie_log,1)
but that gave me the same message.

<div>
do you have replication active on the database?<br />
<br />
are there uncommitted transactions?<br />
<br />
have you tried adding a new log file?
</div>


do you have replication active on the database?

are there uncommitted transactions?

have you tried adding a new log file?

<div>
awesome, that worked. Thanks Sirees.
</div>


<div>
<div class="content wysiwyg-content">
i am trying to run the following command, but am getting an error:<br />
<br />
<br />
DBCC SHRINKDATABASE (SFS_GENIE,10)<br />
<br />
<br />
Cannot shrink log file 2 (sfs_genie_log) because all logical log files are in use.<br />
<br />
How do I make the sfs_genie_log file not be in use? so that I can shrink it.<br />
<br />

</div>
</div>


i am trying to run the following command, but am getting an error:


DBCC SHRINKDATABASE (SFS_GENIE,10)


Cannot shrink log file 2 (sfs_genie_log) because all logical log files are in use.

How do I make the sfs_genie_log file not be in use? so that I can shrink it.



Cannot shrink log file 2 (sfs_genie_log) because all logical log files are in use.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.