【sqlserver】【问题解决】Operating system error code 21

– Cannot bulk load because the file “d:\1.csv” could not be opened. Operating system error code 21(设备未就绪。).
use master

declare @databasename varchar(255)

set @databasename=’spiderdb’

exec sp_dboption @databasename, N’single’, N’true’–将目标数据库置为单用户状态

dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)

dbcc checkdb(@databasename,REPAIR_REBUILD)

exec sp_dboption @databasename, N’single’, N’false’–将目标数据库置为多用户状态