Server Management - Systems Insight Manager
1833187 Members
2593 Online
110051 Solutions
New Discussion

Restore BCK problem

 
Jose Antonio_5
Advisor

Restore BCK problem

Hi all,
I need your help¡¡¡¡

I have been making an HPSIM database backup with those staments (osql):
-------------------------
@command = "BACKUP LOG Insight_v50_0_92441910 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.log_bak'",
@command = "BACKUP DATABASE Insight_v50_0_92441910 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.dat_bak'"
-------------------------

More later, I had a problem and I reinstalled HPSIM. When I try to restore the backup with this stament I obtain:
-------------------------
@command = "BACKUP DATABASE Insight_v50_0_11111111 TO DISK = 'C:\compaq\osql\BACKUP\BCK_BBDD\INSIGHT.dat_bak' with norecovery"
-------------------------

-------------------------
Msg 1834, Level 16, State 1, Server CAS1RDP, Line 4
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'.
Msg 3156, Level 16, State 1, Server CAS1RDP, Line 4
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
MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Server CAS1RDP, Line 4
The file 'C:\Archivos de programa\Microsoft SQL
Server\MSSQL\Data\Insight_v50_0_92441910_log.LDF' cannot be overwritten. It is
being used by database 'Insight_v50_0_92441910'.
Msg 3156, Level 16, State 1, Server CAS1RDP, Line 4
File 'Insight_v50_0_92441910_log' cannot be restored to 'C:\Archivos de
programa\Microsoft SQL Server\MSSQL\Data\Insight_v50_0_92441910_log.LDF'. Use
WITH MOVE to identify a valid location for the file.
Msg 3013, Level 16, State 1, Server CAS1RDP, Line 4
RESTORE DATABASE is terminating abnormally.
-------------------------

What is the problem??? The base data name?? but, the name is different when we make a reinstallation¡¡¡¡¡¡¡

Thanks in advance.