ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
USE maste
RESTORE DATABASE dbname FROM DISK = 'c:\xx.bak' with replace
ALTER DATABASE dbname SET MULTI_USER
USE maste
RESTORE DATABASE dbname FROM DISK = 'c:\xx.bak' with replace
ALTER DATABASE dbname SET MULTI_USER
运行ddl语句,将你要恢复的库设置为single user模式。然后在master库下进行对你的库的恢复操作。
运行这段时,在c#代码里应该是指向一个连到master的连接。