>>>>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.
And yet what he suggested worked for me.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham