>>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?
"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