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 |
|
thelordhumungous
Starting Member
2 Posts |
 Posted - 2007-04-11 : 16:26:37
|
| Our main SQL Server, when trying to restore a database from a remote SQL Server, cannot read their backup file anymore. The contents appear empty,so the restoration process doesn't work. However, both our test sql servers can read the contents fine, and restore the database without any problems. Anyone have any experience with this, or any suggestions?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 16:52:26
|
| What commands are you running?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
thelordhumungous
Starting Member
2 Posts |
Posted - 2007-04-11 : 17:50:30
|
| Just using restore database from enterprise manager. I was able to restore it to my test server, then back it up again, and THEN restore it to the production server; bizarre but at least it worked. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-12 : 01:31:26
|
| You might want to run a DBCC CHECKDB to double check that the "health" of the database is goodKristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-12 : 11:18:11
|
| Can double check backup file with 'restore verifyonly' and 'restore headeronly'. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-12 : 17:12:22
|
| "Can double check backup file with 'restore verifyonly' and 'restore headeronly'."Is that useful in SQL 2000 ??? (for validation of DB-health, I mean, rather than just to get the properties of the original database!)Kristen |
|
|
|
|
|
|
Server cannot read contents of a backup file