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 |
|
BRENT ADKISON
Starting Member
1 Post |
 Posted - 2014-01-31 : 13:22:53
|
| I know NOTHING about SQL. I have a SQL 2005 database. I'm trying to restore a point in time. I get the error:RESTORE FAILED...AMT12-2-13.TRN... CANNOT FIND THE FILE SPECIFIED. The file exists, and in the proper location. something is wrong with it. Is there any way to rebuild the entire TRN so that a point in time recovery will work? I am really in a mess. Backups are no good. It does not get much worse than this, HELP!!!! Thanks for any help BrentBrent Adkison |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-01-31 : 14:36:56
|
| Is the full backup and any other transaction logs that you are restoring being restored correctly?Also, are you following the steps outlined here? http://technet.microsoft.com/en-us/library/ms190982(v=sql.90).aspxIt is important to note that when you restore the full backup and the transaction log backups, you do "RESTORE WITH NORECOVERY". Then, after you have restored the log files up to at least one beyond the point in time you need, then do a RESTORE WITH RECOVERY. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2014-02-01 : 03:17:00
|
| How are you restoring the database? Using the GUI tools, or SQL commands direct?The GUI makes it easy-ish if everything is in the same place as when the backup was made - including the backup files themselves.If anything has changed (e.g. backup files restored from tape to a different location) then it may be easier to use SQL commands.For flexibility, including being able to diagnose which file is giving a problem during restore, and interrogating that file to see what sequence it is in the transaction history etc., then I find SQL commands much more agile - but in fairness I've been doing it for years, so I know what I am doing.There is a step-by-step on using SQL commands to Restore a database, including to a point-in-time, here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170474 |
|
|
|
|
|
|
|
|
SQL 2005 Can't restore point in time