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 |
|
rajdaksha
Aged Yak Warrior
595 Posts |
 Posted - 2009-09-03 : 11:24:51
|
| HiI got below error while i restore the database...please help out...Restore failed for Server 'B3F13258D1'. (Microsoft.SqlServer.Express.Smo)------------------------------ADDITIONAL INFORMATION:System.Data.SqlClient.SqlError: Could not continue scan with NOLOCK due to data movement. (Microsoft.SqlServer.Express.Smo)-------------------------R... |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-03 : 16:35:44
|
Are you trying to upgrade a database (2000-2005, 2000-2008, 2005-2008)?Can you run this on the DB that the backup was taken from?DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS --Gail ShawSQL Server MVP |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-09-04 : 02:22:46
|
| HiYa we are trying to upgrade a database (2000-2005)-------------------------R... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-04 : 03:16:53
|
| What does CheckDB return when run on the source database?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
RESTORE