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 |
|
ozalkl
Starting Member
2 Posts |
 Posted - 2010-02-09 : 15:00:38
|
hi, im kind of new to this forum, matter of fact this is my 1st post, i recently upgraded from sql 2005 to sql 2008, i managed to get most of my db running but i face one problem with importing one of the database, here is what i did:when i try to import the BAK file which generated from 2005 into 2008, it shows the following error:restore failed for server"servername\MSSQL2008". (Microsoft.SqlServer.SmoExtended)Additonal Information:System.Data.SqlClient.SqlError:The tail of the log for the database "databaseX" 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. (Microsoft.SqlServer.Smo)can anyone help me with how to restore the database? im really new to SQL  |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
ozalkl
Starting Member
2 Posts |
Posted - 2010-02-09 : 16:18:04
|
| i found a solution, thanks :) |
 |
|
|
|
|
|
import BAK file from SQL 2005 into SQL 2008 fail