>Hi,
>
>When I backup a SQL server database, I use the following command in the SSMS:
>
>backup database mydatabase to disk = N'j:\dell2020\sqlserverbackup\mydatabase.bak' with init
>
>
>Is a one-line restore command to restore from the .bak file and override the existing database?
>
>TIA
I tried to recover the DB using the following command:
restore database mydatabase from disk = 'j:\dell2020\sqlserverbackup\mydatabase.bak'
But I get error in the SSMS
The tail of the log for the database 'mydatabase' has not been backed up.
What do I need to change in the backup command or the restore command?
"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