I created a backup (.bak) file and transfer it to another computer when I'm trying to make backup I get an error:
BACKUP LOG cannot be performed because there is no current database backup.
How can I resolve this issue?
-
Did you backup the log as well as the db?Kit Z. Fox– Kit Z. Fox2015-12-14 15:30:16 +00:00Commented Dec 14, 2015 at 15:30
-
unclear what you are asking. you are taking a log backup? what about taking a database backup first? how does the transfer of the bak files comes into play? what's the content of the bak file? how you create that bak file? which sql commands you use? PLEASE do put the details in the post and not in the comments.Paolo– Paolo2015-12-14 15:33:10 +00:00Commented Dec 14, 2015 at 15:33
Add a comment
|
2 Answers
This error is raised when you have never taken full backup of your database and try to attempt to take backup of the log only. You need to take a full backup. If you can't find the correct options in SSMS, you can use the following script
BACKUP DATABASE [MyDB] TO DISK = N'C:\MyDB.bak'
GO
BACKUP LOG [MyDB] TO DISK = N'C:\MyDB.bak'
GO
5 Comments
Yuriy
I'm already tried to do this and got this errors: Msg 911, Level 16, State 11, Line 1 Database 'livacast' does not exist. Make sure that the name is entered correctly. Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. Msg 911, Level 16, State 10, Line 1 Database 'livacast' does not exist. Make sure that the name is entered correctly. Msg 3013, Level 16, State 1, Line 1 BACKUP LOG is terminating abnormally.
Alex
That message suggest the database
livacast does not existsYuriy
I know)) But it exists and my ".bak" file in c folder too
Alex
Can you add the contents of this query to your question:
select * from sys.databases where name = 'livacast'Yuriy
When I'm trying to create it again I' getting an error that it's already exists
Take full backup first and then take log back up. The error is stating that you never took a full backup before taking a log backup.
BACKUP DATABASE [DBName]
TO DISK = N'C:\DBName.bak'
GO
BACKUP LOG [DBName]
TO DISK = N'C:\DBName.bak'
GO
