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 - 2005-01-21 : 08:49:11
|
Van writes "I have a database (This runs everything on the business!!!!!) it was running on SQL 7.0 we are upgrading to 2000 I did a backup of the database in order to move it to 2000. I also did a full backup of the server (Copied to driver on network). I found out the backup was bad. And now it looks like the copyied file is bad also. The server was brought down and back up and now the database shows suspect. I need this data. Is there anyway I could get this back .I might have a good backup of the transaction Log.HELP!!!" |
|
Kristen
Test
22859 Posts |
Posted - 2005-01-21 : 12:58:57
|
If you have an earlier, good, backup of the database and ALL subsequent transaction log backups you can recover them all in chronological order (I don't think this will work if you did any non-logged operations)Kristen |
 |
|
|
|
|