Hi,

Few devices in my server, though they are used only for data it's showing like "mixed log and data". (The output of sp_helpdb, is also showing as mixed log and data).

But the devices are either used for data or log but not for both.
can any of you let me know the reasons for it and also how do I change this?

Please revert me as soon as possible.

Thanks,
Vineela