https://community.hpe.com/t5/server-management-systems/restore-bck-problem/m-p/3881342#M23364 Hi all,<BR />I need your help¡¡¡¡<BR /><BR />I have been making an HPSIM database backup with those staments (osql):<BR />-------------------------<BR />@command = "BACKUP LOG Insight_v50_0_92441910 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.log_bak'",<BR />@command = "BACKUP DATABASE Insight_v50_0_92441910 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.dat_bak'"<BR />-------------------------<BR /><BR />More later, I had a problem and I reinstalled HPSIM. When I try to restore the backup with this stament I obtain:<BR />-------------------------<BR />@command = "BACKUP DATABASE Insight_v50_0_11111111 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.dat_bak' with norecovery"<BR />-------------------------<BR /><BR />-------------------------<BR />Msg 1834, Level 16, State 1, Server CAS1RDP, Line 4<BR />The file 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910.mdf' cannot be overwritten. It is being used by database 'Insight_v50_0_92441910'.<BR />Msg 3156, Level 16, State 1, Server CAS1RDP, Line 4<BR />File 'Insight_v50_0_92441910' cannot be restored to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910.mdf'. Use WITH<BR />MOVE to identify a valid location for the file.<BR />Msg 1834, Level 16, State 1, Server CAS1RDP, Line 4<BR />The file 'C:\Archivos de programa\Microsoft SQL<BR />Server\MSSQL\Data\Insight_v50_0_92441910_log.LDF' cannot be overwritten. It is<BR />being used by database 'Insight_v50_0_92441910'.<BR />Msg 3156, Level 16, State 1, Server CAS1RDP, Line 4<BR />File 'Insight_v50_0_92441910_log' cannot be restored to 'C:\Archivos de<BR />programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910_log.LDF'. Use<BR />WITH MOVE to identify a valid location for the file.<BR />Msg 3013, Level 16, State 1, Server CAS1RDP, Line 4<BR />RESTORE DATABASE is terminating abnormally.<BR />-------------------------<BR /><BR />What is the problem??? The base data name?? but, the name is different when we make a reinstallation¡¡¡¡¡¡¡<BR /><BR />Thanks in advance. Tue, 17 Oct 2006 04:48:27 GMT Jose Antonio_5 2006-10-17T04:48:27Z https://community.hpe.com/t5/server-management-systems/restore-bck-problem/m-p/3881342#M23364 Hi all,<BR />I need your help¡¡¡¡<BR /><BR />I have been making an HPSIM database backup with those staments (osql):<BR />-------------------------<BR />@command = "BACKUP LOG Insight_v50_0_92441910 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.log_bak'",<BR />@command = "BACKUP DATABASE Insight_v50_0_92441910 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.dat_bak'"<BR />-------------------------<BR /><BR />More later, I had a problem and I reinstalled HPSIM. When I try to restore the backup with this stament I obtain:<BR />-------------------------<BR />@command = "BACKUP DATABASE Insight_v50_0_11111111 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.dat_bak' with norecovery"<BR />-------------------------<BR /><BR />-------------------------<BR />Msg 1834, Level 16, State 1, Server CAS1RDP, Line 4<BR />The file 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910.mdf' cannot be overwritten. It is being used by database 'Insight_v50_0_92441910'.<BR />Msg 3156, Level 16, State 1, Server CAS1RDP, Line 4<BR />File 'Insight_v50_0_92441910' cannot be restored to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910.mdf'. Use WITH<BR />MOVE to identify a valid location for the file.<BR />Msg 1834, Level 16, State 1, Server CAS1RDP, Line 4<BR />The file 'C:\Archivos de programa\Microsoft SQL<BR />Server\MSSQL\Data\Insight_v50_0_92441910_log.LDF' cannot be overwritten. It is<BR />being used by database 'Insight_v50_0_92441910'.<BR />Msg 3156, Level 16, State 1, Server CAS1RDP, Line 4<BR />File 'Insight_v50_0_92441910_log' cannot be restored to 'C:\Archivos de<BR />programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910_log.LDF'. Use<BR />WITH MOVE to identify a valid location for the file.<BR />Msg 3013, Level 16, State 1, Server CAS1RDP, Line 4<BR />RESTORE DATABASE is terminating abnormally.<BR />-------------------------<BR /><BR />What is the problem??? The base data name?? but, the name is different when we make a reinstallation¡¡¡¡¡¡¡<BR /><BR />Thanks in advance. Tue, 17 Oct 2006 04:48:27 GMT https://community.hpe.com/t5/server-management-systems/restore-bck-problem/m-p/3881342#M23364 Jose Antonio_5 2006-10-17T04:48:27Z