Microsoft KB Archive/268020

= PRB: Error Message 15320 Generated When Trying to Expand the Log for a Database on a Shared Device =

Article ID: 268020

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q268020



SYMPTOMS
If a database has both the data segment and the log segment on the same device, you may get the following error message when that database is expanded by expanding the log segment:

Error 15320: [SQL Server] Action Denied. Fragments to be dedicated to

log usage for a database cannot be on the device containing logical

page 0 for that database. (databasename, devicename)



CAUSE
This error message occurs because the database in question has the data and the transaction log shared on the same device.

This can verified by running the following code: select * from master..sysusages The &quot;segmap&quot; column reads &quot;7,&quot; indicating that the data and log are shared on the same device.



WORKAROUND
To correctly expand the data or the transaction log for a database that has it's segments shared, you need to expand only the data portion, not the transaction log.

Additional query words: 15320 7

Keywords: kbsqlprog kbprb KB268020

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.