Hi I want restore database from backup file so i have used the following command
restore database myTestDbName from disk ='C:\temp\mybackuo.bak'
while executing the command I got following error
"The tail of the log for the database "myTestDbName" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log. RESTORE DATABASE is terminating abnormally."
To get the back up of data base i used following command
backup database myTestDbName to disk ='c:\temp\mybackuo.bak' with init,stats=10
Please reply me as soon as possible.
Thanks
Munish