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 - 2003-12-08 : 08:30:33
|
| Petros writes "hi,i am in trouble.i have a lot of backups, but if i want them to restore i receive an errorm_nvars > 0the restore process stops at 99percent and i can not use the database, because is it grey ( the color ) ans says. it looks like an error in the database..have you any idea ?i need just one table from the backup...hope you can help mepetros" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-08 : 08:32:07
|
| You didn't say whether you were using Enterprise Manager to perform the restore, but I have a feeling that the error is with EM. Try restoring the database in Query Analyzer using the RESTORE command (see Books Online) Hopefully it will work correctly, and you'll find that it's easier and faster to do it this way than EM, once you get the hang of it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-08 : 12:20:45
|
| Do you get an error at 99%? If so what is it? Could be a corrupt backup. Do you have any other full backups for this database?Tara |
|
|
|
|
|
|
error with a backup