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 |
|
tubbie
Starting Member
2 Posts |
 Posted - 2008-12-19 : 03:30:37
|
| I have a 2005 database with a full backup that was taken at 12:00pm and there have been 3 transaction logs taken since then. We had a problem between 12:00 and 1:00, and now I would like to do a full restore of the database. I would just like to restore from the full backup and do not want to apply the logs. What steps should I take and if anyone can provide some code, it would be very much appreciated. thx |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2008-12-19 : 04:19:28
|
| If you have your backup on disk you can use the following code:restore database DBNamefrom disk = 'path'with replace, recoveryIf you have it on tape you must change the second line.You use 'recovery' to bring your database online.If you want to restore additional transaction logs you must use 'norecovery' except for the last onewhere you should use 'recovery' again. |
 |
|
|
tubbie
Starting Member
2 Posts |
Posted - 2008-12-19 : 11:09:13
|
| Do I need to do a tail end backup of the transaction log before I do the restore? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Restore Just from Full Backup and No Trans Logs