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