Tuesday, August 14, 2012

Server: Msg 3013 RESTORE DATABASE is terminating abnormally.

Server: Msg 3013
RESTORE DATABASE is terminating abnormally.

Server: Msg 3159
The tail of the log for the database "DBTest" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

Solution : If you want to restore the database on to new server where you created the database was never backup before then you need to take backup of your database on new server ( mostly empty db) before restore the database from the backup file.