Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-13 : 08:09:06
|
| Vikas writes "Hi,I have .bak file.When I m trying to restore this .bak file,I got following error. MS SQL-DMO (ODBC SQLState: 42000)The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation. RESTORE DATBASE is terminating abnormally.Plz help..Thnx Vikas" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-13 : 08:14:23
|
| You need to restore from a backup file with a full backup on it first. You will need to restore the full backup WITH NORECOVERY first. You can then begin restoring the log backups until you are current. This backup is just a log backup, not a full backup.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Error in Restoring database from .bak