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 |
|
elayaraja_apd
Starting Member
9 Posts |
 Posted - 2010-03-30 : 01:47:42
|
| Hello,Today we got an error message whereas doing the DB restoration in one of our production server. Can anyone help and let me know what could be the cause? Error Msg:Error 512: Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,<,<=,>,>= or when the subquery is used as an expression(Error on clicking 'Restore Database')Please help me in advance.Version: SQL SERVER 2000 Ent. Edition |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-30 : 06:10:14
|
| Sounds like there is a "corruption" of somesort in the MSDB databaseThis error occurred whilst you were restoring the database?Or did it occur from some application after the restore finished? |
 |
|
|
thewebhosting
Starting Member
17 Posts |
Posted - 2010-04-09 : 02:57:37
|
| Hi,Can you please try to restore the DB from fresh backup/ As error suggests taht backup copy of your database seems to be corrupted. |
|
|
|
|
|
|
Restore Database Issue [SE]