Unsolved
This post is more than 5 years old
1 Message
0
986
When i try to restore a database from one server to another. i got below error.can any one pls help in this
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Users\pada01>nsrsqlrc -s yyy -c xxx
-d MSSQL$OIAS: -$ MSSQL$WEB: -C" 'wslogdb70 '='E:\Program Files\Microsoft
SQL Server\MSSQL12.OIAS\MSSQL\DATA\wslogdb70.mdf','wslogdb70_log'='E:\Program Fi
les\Microsoft SQL Server\MSSQL12.OIAS\MSSQL\DATA\wslogdb70_log.ldf'" "MSSQL$WEB
:wslogdb70"
43708:(pid 5436):Start time: Tue Sep 13 13:08:03 2016
43621:(pid 5436):Computer Name: SRVWSQLMGMT01 User Name: pada01
NSR_CLIENT: xxx;
NSR_SERVER: yyy;
37725:(pid 5436):Recovering database 'wslogdb70' into '' ...
142468:(pid 5436):[5160]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for
saveset MSSQL$WEB:/wslogdb70.
37945:(pid 5436):Missing relocation for logical file wslogdb70.
37946:(pid 5436):No logical file named wslogdb70 in original database
29401:(pid 5436):Database file relocation list error. Actual file list is:
37947:(pid 5436): wslogdb70 = E:\MSSQL11.WEB\MSSQL\DATA\wslogdb70.mdf
37947:(pid 5436): wslogdb70_log = E:\MSSQL11.Web\MSSQL\DATA\wslogdb70
_log.ldf
142468:(pid 5436):[5160]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for
saveset MSSQL$WEB:/wslogdb70.
37945:(pid 5436):Missing relocation for logical file wslogdb70.
37946:(pid 5436):No logical file named wslogdb70 in original database
29401:(pid 5436):Database file relocation list error. Actual file list is:
37947:(pid 5436): wslogdb70 = E:\MSSQL11.WEB\MSSQL\DATA\wslogdb70.mdf
37947:(pid 5436): wslogdb70_log = E:\MSSQL11.WEB\MSSQL\DATA\wslogdb70
_log.ldf
Restore operation finished with error(s). Refer to the module backup log file fo
r details.
unknown XBSA error 1169 (0x491)
nsr/db_apps/bsmsql/rcovmain.cpp(442): Entering cleanUp().
nsr/db_apps/bsmsql/rcovmain.cpp(500): Exiting cleanUp().
43709:(pid 5436):Stop time: Tue Sep 13 13:09:54 2016
ble1
2 Intern
2 Intern
•
14.3K Posts
0
September 19th, 2016 02:00
Are you sure names for DB and log are correct? You can verify those via nsradmin...