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 |
|
SQLLearner2
Starting Member
14 Posts |
 Posted - 2008-08-26 : 11:21:18
|
| We have a database with a recovery model of simple. Nothing has changed since the last full backup. If we lose and have to replace a disk drive, can we just restore the data files that were contained on that drive, or do we have to do a full db restore? |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-08-26 : 11:43:02
|
| You can re-attach the database files using sp_attach_db.Check books online for more information.--SachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
SQLLearner2
Starting Member
14 Posts |
Posted - 2008-08-26 : 12:10:21
|
| so using the last full database backup and 'restore' command, we can restore just the lost datafiles (3 of 9), and then re-attach using sp_attach_db? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-26 : 14:25:29
|
| Just restore your Full backup if you have kept your backup in safe location. |
|
|
|
SQLLearner2
Starting Member
14 Posts |
Posted - 2008-08-26 : 14:47:12
|
| That's what I plan on doing. From an informational standpoint, is it even possible to restore only selected data files from a full backup when the database is in 'simple' recovery model. I wouldn't think it would be a problem in 'full' recovery model, but didn't know if it was possible in 'simple' recovery model. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-26 : 16:17:48
|
| You can't. |
|
|
|
SQLLearner2
Starting Member
14 Posts |
Posted - 2008-08-26 : 16:36:25
|
| That's what I thought. Thanks for the info. |
|
|
|
|
|
|
restore question