>>>Hi,
>>>
>>>I made a backup a database (about 5 minutes ago). Then made some changes. Now I want to restored from the backup. In SSMS I go to the Database, right mouse click, select Tasks -> Restore. I get the following error:
>>>
>>>System.Data.SqlClient.SqlError: The tail of the log for the database "MyDbName" has not been backup up.
>>>Use BACKUP LOG WITH NORECOVERY to backup the log if it contains the work you do not want to lose.
>>>Use the WITH REPLACE or WITHSTOPAT clause of the RESTORE statement to just overwrite the contents
>>>of the log.
>>>
>>>1. What do I need to do next time to make sure that the "tail of the log" is backed up (although I don't know what it is)
>>>2. Is BACKUP LOG WITH NORECOVERY the command I need to execute in the Query window to make a backup?
>>>3. What should I do to restore?
>>>
>>>TIA.
>>
>>In "Options" node check "Overwrite the existing database (WITH REPLACE)"
>
>Thank you very much. I am glad I made the make and had a chance to practice restoring. By the way, I usually do backup from the Tasks -> Backup. Why this method does not backup the "tail of the log for the database" (as the error said)? Do I need a different backup procedure?
Dmitry,
I don't think Boris gave you a correct answer. You only need to use this option (with replace) when you want to bring a database from other site, for example, or create a new database based on another one.
In usual scenario you do not want to use this option.
If it's not broken, fix it until it is.
My Blog