dpavan
1 Copper

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

Labels (1)
Tags (2)
0 Kudos
1 Reply
8 Krypton

Re: When i try to restore a database from one server to another. i got below error.can any one pls help in this

Are you sure names for DB and log are correct?  You can verify those via nsradmin...

0 Kudos