0000791: mssql plugin can't restore to other HOST - Bareos Bug Tracker

ID	Project	Category	View Status	Date Submitted	Last Update

0000791	bareos-core	file daemon	public	2017-02-27 15:06	2024-03-20 14:58

Reporter	vgusev2007	Assigned To	arogge
Priority	urgent	Severity	major	Reproducibility	always
Status	closed	Resolution	no change required
Platform	Linux	OS	Ubuntu	OS Version	14.04 x64
Product Version	15.2.2

Summary	0000791: mssql plugin can't restore to other HOST
Description	Dear all, I have a work backup of my mssql server 2008R2 SP3. I can backup and restore a backup to the same host without a problem (Full, Inc), but if I want to restore any backup to other server I can't...
Steps To Reproduce	Create mssql full backup as usually. Restore it to another host (with the same version of mssql). Please see a restore log: 27-feb. 16:21 mssql-dev-fd JobId 4086: Fatal error: mssqlvdi-fd: IClientVirtualDeviceSet2::GetConfiguration failed 27-feb. 16:21 boss-sd JobId 4086: Error: bsock_tcp.c:422 Write error sending 22221 bytes to client:192.168.13.90:9103: ERR=Connection reset by peer 27-feb. 16:21 mssql-dev-fd JobId 4086: Fatal error: ???????????????????????????????????????? '{1129DBCE-A9A0-4A69-960B-A4B51E116D8B}'. ??????????????????? 0x80070002(????????????????????.). RESTORE DATABASE ???????????????????. 27-feb. 16:21 boss-sd JobId 4086: Fatal error: read.c:154 Error sending to File daemon. ERR=Connection reset by peer 27-feb. 16:21 boss-sd JobId 4086: Error: bsock_tcp.c:357 Socket has errors=1 on call to client:192.168.13.90:9103 27-feb. 16:21 boss-dir JobId 4086: Error: Bareos boss-dir 15.2.2 (16Nov15): Build OS: x86_64-pc-linux-gnu ubuntu Ubuntu 14.04 LTS JobId: 4086 Job: Restore-Timex-dev.2017-02-27_16.20.40_41 Restore Client: mssql-dev Start time: 27-feb.-2017 16:20:42 End time: 27-feb.-2017 16:21:42 Elapsed time: 1 min Files Expected: 1 Files Restored: 0 Bytes Restored: 0 Rate: 0.0 KB/s FD Errors: 1 FD termination status: Fatal Error SD termination status: Fatal Error Termination: * Restore Error * I can't see detail error messages because encoding... :( Please any help to me.
Tags	mssql, mssqlvdi

vgusev2007 2017-02-27 15:09 reporter ~0002585	Sorry for wrong title of the Issue. The correct topic is: mssql plugin can't restore to other HOST

vgusev2007 2017-03-02 15:33 reporter ~0002588	There is the following error: Dear all, there is the following message error when I want to restore mssql db from one server to other mssql server: bareos-fd: Cannot open backup device ххххххххххххххххххххх. Operating system error 0x80070002(The system cannot find the file specified.). It looks really as a bug mssql plugin of bareos.

arogge 2023-12-22 14:20 manager ~0005662	I assume you used where=/ on restore to get a VDI restore. Could you try to restore with setting where to some other location and see if that at least restores the files?

bruno-at-bareos 2024-03-20 14:58 manager ~0005860	no return of feedback

Date Modified	Username	Field	Change
2017-02-27 15:06	vgusev2007	New Issue
2017-02-27 15:09	vgusev2007	Note Added: 0002585
2017-03-02 15:33	vgusev2007	Note Added: 0002588
2023-12-13 13:42	bruno-at-bareos	Tag Attached: mssql
2023-12-13 13:42	bruno-at-bareos	Tag Attached: mssqlvdi
2023-12-13 13:43	bruno-at-bareos	Summary	mssql plugin can't restore to other soft => mssql plugin can't restore to other HOST
2023-12-22 14:20	arogge	Assigned To	=> arogge
2023-12-22 14:20	arogge	Status	new => feedback
2023-12-22 14:20	arogge	Note Added: 0005662
2024-03-20 14:58	bruno-at-bareos	Status	feedback => closed
2024-03-20 14:58	bruno-at-bareos	Resolution	open => no change required
2024-03-20 14:58	bruno-at-bareos	Note Added: 0005860