use master
sp_configure ’allow update’,1
update sysdatabases set status= -32768
重启动sql server
update sysdatabases=0 where name=’’
sp_configure ‘allow update’,0
Use Master
Go
sp_configure 'allow updates', 1
reconfigure with override
Go
update sysdatabases set status = 32768 where name = 'posbase'
ALTER DATABASE posbase SET EMERGENCY
EXEC sp_attach_single_file_db @dbname ='posbase',
@physname= 'c:/Program Files/Microsoft SQL Server/MSSQL/Data/posbase.mdf '
附加
EXEC sp_attach_db @dbname = '数据库名称', @filename1 = 'MDF路径',@filename2= 'LOG路径'
分离数据库
EXEC sp_detach_db @dbname = '数据库名称'