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 |
|
mjb_AEA
Starting Member
5 Posts |
 Posted - 2006-05-15 : 16:01:57
|
| Example - I have a database with Simple Recovery. Today is May 15th, is it possible to restore the database as it was on April 4th? The database is backed up nightly to one backup file.Thanks for the help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-15 : 16:07:36
|
| You can restore the database as it was exactly when the backup job ran on April 4th. If the backup occurred at 6am, then whatever it looked like at 6am is what will be restored. You can not do a point in time restore to say 8pm on April 4th. You could if you used anything other than simple recovery and regular transaction log backups.Tara Kizeraka tduggan |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-16 : 03:37:42
|
you can if you append the new backup file instead of initializing it --------------------keeping it simple... |
|
|
|
mjb_AEA
Starting Member
5 Posts |
Posted - 2006-05-16 : 09:50:22
|
| So if the backup was set to overwrite everynight, i would be out of luck correct? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-16 : 09:53:37
|
you are correct, unless you have some file or system backups which you can restore from tape  --------------------keeping it simple... |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-05-16 : 09:56:48
|
| I would say so, if the Backup script contains the 'init' keyword it would be overwriting if it was written with the 'noinit' keyword it would be appending to the current set. |
|
|
|
mjb_AEA
Starting Member
5 Posts |
Posted - 2006-05-16 : 10:03:05
|
| Thanks for all your help everyone |
|
|
|
|
|
|
Question - Restore using Simple Recovery