PRB: Error Message 15320 Generated When Trying to Expand the Log for a Database on a Shared Device (268020)
The information in this article applies to:
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 "segmap" column reads "7," 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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbprb kbSQLProg KB268020 |
|---|
|