关于sql server 数据库备份还原问题请教！很急，万分感谢！

Set StringTranslator = New ADODB.Recordset
    With StringTranslator
         .CursorLocation = adUseClient
         .CursorType = adOpenStatic
         Set .ActiveConnection = cn

        .Open ("restore database test from DISK='d:\backup\aaa2'")
    End With执行到open时出错！不关掉程序，到sql server里手动还原也是提示数据库在使用中！请问如何解决！