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 |
|
neutral4
Starting Member
2 Posts |
 Posted - 2014-05-09 : 03:26:29
|
| If I create a database in simple recovery mode in SQL Server 2005, then backup the database, then add 1000 records, then change the recovery mode to full, then add 500 more. Can I recover using the log backups? |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2014-05-12 : 13:47:46
|
| Not until you perform another full backup to initiate the log chain. You cannot even backup the transaction log until after a full backup is performed after switching the recovery model to full.In fact, the transaction log knows that those records in the transaction log cannot be used - and treats them as if you are still in simple recovery model until the next full backup of the database has been taken. |
 |
|
|
neutral4
Starting Member
2 Posts |
Posted - 2014-05-13 : 01:39:27
|
| thank u sir, thanks a lot.. |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-07-09 : 07:05:44
|
quote:
Originally posted by neutral4
If I create a database in simple recovery mode in SQL Server 2005, then backup the database, then add 1000 records, then change the recovery mode to full, then add 500 more. Can I recover using the log backups?
When you change recovery model to full and add 500 records your database is actually in Pseudo simple recovery and of course you have not taken any full backup after changing to full recovery so you cannot take log backup. After taking full backup you can take log backups and then ca achieve point i time recovery. Its very easy to reproduce if you have SQL server instance, do it you will see for yourself the error flashed.RegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
sql backup