MSSQL-The log tail of the database XXXX has not been backed up. If the log contains work that you do not want to lose, use BACKUP log with NORECOVERY to back up the log. Please use the WITH REPLA of the RESTORE statement

The reason for this error is that there is a database in your database server with the same name!

RESTORE DATABASE [student] from DISK = N ' g:\ backup files ' with file = 1, move n ' student ' to n ' G:\student.mdf ', move n ' Studen T_log ' to N ' g:\\student.ldf ', nounload,replace, STATS = ten, PASSWORD = ' 123456 '

So add REPLACE or STOPAT after with to restore! But the database with the same name may be overwritten!

MSSQL-The log tail of the database XXXX has not been backed up. If the log contains work that you do not want to lose, use BACKUP log with NORECOVERY to back up the log. Please use the WITH REPLA of the RESTORE statement