The maximum number of configured devices has already been reached

Following error recieved when tried to create raw device in the server.

disk init
name=’data43′,
physname=’/data/devices/sb_device_data43′,
size=’40000M’

Msg 5162, Level16, State1: Server 'SKN_UAT1',Line1: The maximum number 42 of configured devices has already been reached. Please reconfigure 'number of devices' to a larger value and retry disk initialization.

Solution:The maximum number of configured devices has already been reached

Increase the The maximum number of configured devices to larger value than 42 by using sp_configure procedure.

Run the following commands

use master go sp_configure 'number of devices',50 go

Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: