Mar 07, 2019 08:09 AM|PatriceSc|LINK
You are using the SSMS user interface? You could run SQL scripts in SSMS. I adapted a sample taken from https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-2017#examples
-- Full database backup
BACKUP DATABASE AdventureWorks2012
TO DISK='C:\BACKUP\AdventureWorksBackups.bak' WITH COPY_ONLY ; -- Ensure you won't interfere with scheduled backups
-- See what is in the backup (locail file names and physical location)
FROM DISK='C:\BACKUP\AdventureWorksBackups.bak' ;
-- Restoring and moving db files on some other location
RESTORE DATABASE TestDB
FROM DISK='C:\BACKUP\AdventureWorksBackups.bak' -- Enough if files are that the same place than on the source server else you need :
WITH MOVE 'AdventureWorks2012_Data' TO 'C:\MySQLServer\testdb.mdf',
MOVE 'AdventureWorks2012_Log' TO 'C:\MySQLServer\testdb.ldf';
If you need further please tell us which problem you have (could be also a version issue or whatever)
Edit "because of user conflict as far as I see" : always just quote the exact error message you have (or the best English translation you can) to avoid any interpretation on your side then on our side and ending up in having still to guess which error
message you have.
For now my guess is that SQL Server is not authorized to access to the location of the backup file ????