Printable View
سلام دوستان
من هم هنگام restore کردن یک backup در یک دیتابیس جدید پیغام error زیر را دریافت می کنم.
Restore failed for server 'Dynamic' . (Microsoft.sqlserver.smo)
Additional information
system.data.sqlclienr.sqlError:the backup set holds a backup of a database other than the existing 'axapta' database. (Microsoft.sqlserver.smo)
سلام.نقل قول:
سلام دوستان
من هم هنگام restore کردن یک backup در یک دیتابیس جدید پیغام error زیر را دریافت می کنم.
Restore failed for server 'Dynamic' . (Microsoft.sqlserver.smo)
Additional information
system.data.sqlclienr.sqlError:the backup set holds a backup of a database other than the existing 'axapta' database. (Microsoft.sqlserver.smo)
شما احتمالاً برنامه را اجرا و در حال استفاده از دیتابیس هستید و میخواهید بکاپ را جای گزین دیتابیس اصلی کنید...
فکر نکنم این کار زمانی که از دیتا بیس استفاده میکنید ممکن باشه....
موفق باشید.
دوست عزیز
سلام
هیچ برنامه بازی ندارم و تنها sql server باز می باشد و این پیغام error را در مورد تمام بک آپ هایی که می خواهم restore کنم (حتی در یک دیتابیس جدید) دریافت می کنم.
سلام
به انتهای دستور restore عبارت WITH REPLACE را اضافه کنیدنقل قول:
من هم هنگام restore کردن یک backup در یک دیتابیس جدید پیغام error زیر را دریافت می کنم
کد:RESTORE DATABASE databasename
FROM DISK = 'D:\file.bak'
WITH REPLACE
سلام دوستان :
من از این کد برای بکاپ گیری استفاده کردم ولی تو خط آخر بهم گیر داد :41:
کد:Dim srv As New Smo.Server()
Dim bk As New Smo.Backup()
bk.Database = "Nezam_DB"
bk.LogTruncation = Smo.BackupTruncateLogType.Truncate
bk.Action = Smo.BackupActionType.Database
bk.Initialize = True
bk.Incremental = False
bk.Devices.Add(New Smo.BackupDeviceItem(txt_path.Text + "\file.bak", Smo.DeviceType.File))
bk.SqlBackup(srv)
متن خطا :
نقل قول:
Microsoft.SqlServer.Management.Smo.FailedOperation Exception was unhandled
HelpLink="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Backup+Server&LinkId=20476"
Message="Backup failed for Server 'H03IN-PC'. "
Operation="Backup"
ProductName="Microsoft SQL Server"
Source="Microsoft.SqlServer.Smo"
StackTrace:
at Microsoft.SqlServer.Management.Smo.Backup.SqlBacku p(Server srv) at Nezam_Mohandesi_Sari.FRM_BK.ButtonX2_Click(Object sender, EventArgs e) in C:\Users\h03in\Desktop\komail-2\h03in\Nezam_Mohandesi_Sari\Nezam_Mohandesi_Sari\ Forms\FRM_BK.vb:line 68 at System.Windows.Forms.Control.OnClick(EventArgs e) at DevComponents.DotNetBar.ButtonX.OnClick(EventArgs e) at DevComponents.DotNetBar.ButtonX.OnMouseUp(MouseEve ntArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevComponents.DotNetBar.PopupItemControl.WndProc(M essage& m) at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallba ck(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchM essageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager. System.Windows.Forms.UnsafeNativeMethods.IMsoCompo nentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.Run MessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.Run MessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(ApplicationCo ntext context) at Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.OnRun() at Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.DoApplicationModel() at Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.Run(String[] commandLine) at Nezam_Mohandesi_Sari.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context( Object state) at System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
InnerException: Microsoft.SqlServer.Management.Common.ConnectionFa ilureException
Message="Failed to connect to server .."
Source="Microsoft.SqlServer.ConnectionInfo"
StackTrace:
at Microsoft.SqlServer.Management.Common.ConnectionMa nager.Connect() at Microsoft.SqlServer.Management.Common.ConnectionMa nager.PoolConnect() at Microsoft.SqlServer.Management.Common.ConnectionMa nager.get_ServerVersion() at Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetServerVersion() at Microsoft.SqlServer.Management.Smo.Backup.Script(S erver targetServer) at Microsoft.SqlServer.Management.Smo.Backup.SqlBacku p(Server srv)
InnerException: System.Data.SqlClient.SqlException
Class=20
ErrorCode=-2146232060
LineNumber=0
Message="A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Number=2
Server=""
Source=".Net SqlClient Data Provider"
State=0
StackTrace:
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.Common.ConnectionMa nager.InternalConnect(WindowsIdentity impersonatedIdentity) at Microsoft.SqlServer.Management.Common.ConnectionMa nager.Connect()
InnerException:
از این کد هم استفاده کردم :
کد:Dim sql As String = "BACKUP DATABASE [Nezam_DB] TO DISK='" + txt_path.Text + "\FILE.bak' WITH FORMAT"
Dim c As New classdata
Using dbcon = New System.Data.SqlClient.SqlConnection(c.strcon)
Using dbcom = New System.Data.SqlClient.SqlCommand(sql, dbcon)
dbcon.Open()
dbcom.ExecuteNonQuery()
End Using
End Using
ولی این خطا رو میگیره :
نقل قول:
Could not locate entry in sysdatabases for database 'Nezam_DB'. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally.
نقل قول:
System.Data.SqlClient.SqlException was unhandled
Class=16
ErrorCode=-2146232060
LineNumber=1
Message="Could not locate entry in sysdatabases for database 'Nezam_DB'. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally."
Number=911
Procedure=""
Server="\\.\pipe\7B3DA5D6-4DEB-48\tsql\query"
Source=".Net SqlClient Data Provider"
State=11
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(TdsParserStateObject stateObj) 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 Nezam_Mohandesi_Sari.FRM_BK.ButtonX2_Click(Object sender, EventArgs e) in C:\Users\h03in\Desktop\komail-2\h03in\Nezam_Mohandesi_Sari\Nezam_Mohandesi_Sari\ Forms\FRM_BK.vb:line 78 at System.Windows.Forms.Control.OnClick(EventArgs e) at DevComponents.DotNetBar.ButtonX.OnClick(EventArgs e) at DevComponents.DotNetBar.ButtonX.OnMouseUp(MouseEve ntArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevComponents.DotNetBar.PopupItemControl.WndProc(M essage& m) at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallba ck(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchM essageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager. System.Windows.Forms.UnsafeNativeMethods.IMsoCompo nentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.Run MessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.Run MessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(ApplicationCo ntext context) at Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.OnRun() at Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.DoApplicationModel() at Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.Run(String[] commandLine) at Nezam_Mohandesi_Sari.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context( Object state) at System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
InnerException:
راستی ، اگر میشه در مورد restor کردنش هم یه توضیح بدید . من کدی ندیدم
در همین تاپیک هر دو کد درست backup و restore توسط دوست عزیز _H2_ گذاشته شده و نیازی هم به استفاده از smo ندارد.
در پست 7 نمونه کد backup و در پست 14 نمونه کد restore قابل مشاهده هستند.
در مورد خطاهایی هم که گرفتید احتمالا از اتچ نکردن دیتابیس می باشد. اتچش کنید!
مشکلم حل شد .
از همگی ممنونم
نقل قول:
کسی می تنه VB این کد رو بهم بگه؟؟؟