مشکل بازیابی اطلاعات

[M_Tavakoli_70]

من تا فردا بیشتر وقت ندارم
با دستورات معمولی ( کوئری های sql ) و دستورات smo عملیات بازیابی را انجام می دم.
ولی هر دو خطا میده کسی راه دیگه ای به نظرش نمی رسه خودم خیلی تلاش کردم خطاهاش را بر طرف کنم ولی نشد.

Microsoft.SqlServer.Management.Smo.FailedOperation Exception was caught
HelpLink=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.Exceptio nTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
Message=Restore failed for Server 'SAYTACO1-PC'.
Source=Microsoft.SqlServer.SmoExtended
Operation=Restore
StackTrace:
at Microsoft.SqlServer.Management.Smo.Restore.SqlRest ore(Server srv)
at office.cls_backup.restore(String _file, String& _error) in D:\PROJECT\X\C#‎\office\office\cls_main.cs:line 179
InnerException: Microsoft.SqlServer.Management.Common.ExecutionFai lureException
Message=An exception occurred while executing a Transact-SQL statement or batch.
Source=Microsoft.SqlServer.ConnectionInfo
StackTrace:
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBa se.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRest ore(Server srv)
InnerException: System.Data.SqlClient.SqlException
Message=RESTORE cannot process database 'office' because it is in use by this session. It is recommended that the master database be used when performing this operation.
RESTORE DATABASE is terminating abnormally.
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
Class=16
LineNumber=1
Number=3102
Procedure=""
Server=.
State=1
StackTrace:
at Microsoft.SqlServer.Management.Common.ConnectionMa nager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
InnerException:

و خطای کوئری
System.Data.SqlClient.SqlException was caught
Message=Cannot open database "office" requested by the login. The login failed.
Login failed for user 'sa'.
A severe error occurred on the current command. The results, if any, should be discarded.
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
Class=11
LineNumber=1
Number=4060
Procedure=""
Server=.
State=1
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at office.cls_backup.restore(String _file, String& _error) in D:\PROJECT\X\C#\office\office\cls_main.cs:line 130
InnerException: