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 |
|
kenheah
Starting Member
2 Posts |
 Posted - 2002-12-04 : 06:57:45
|
| I have the only one set of backup of my ms SQL database, but when restore back the data halfway come out incorrectly form & terminate the restore fuction. Check the log file said that incomplete backup set. Please help me to recover that set of backup i have . Thanks |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-04 : 10:24:24
|
| What are you trying to restore?What is your recovery model (Full, Bulk Logged, Simple)What are the commands you are using to backup and restore your database? |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-12-04 : 10:52:19
|
| -- Moved to the administration forum --===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-04 : 15:40:17
|
| You will be unable to restore a backup that is incomplete. Did you verify the backup when you backed up the database because it should have told you that it was incomplete? |
|
|
|
kenheah
Starting Member
2 Posts |
Posted - 2002-12-04 : 20:23:47
|
quote:
What are you trying to restore?What is your recovery model (Full, Bulk Logged, Simple)What are the commands you are using to backup and restore your database?
restore my program data , the program written in VB.I don't have any reocvery model , i'm using MS SQL7.0Inside the enterprise manager of MSSQL 7.0 |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-04 : 21:09:43
|
| The lumigent tool might be able to recover the data for you I guess it would depend on your log file.http://www.lumigent.com/ |
|
|
|
|
|
|
Ms SQL data backup incomplete , how to recovery ?