MSSQL: Can't restore with Time of Point
I have created a full mssql backup file and now i want to restore it to a certain point of time. But i can't.
I select the device backup and the list of "Restore items" shows. Then i specify the "Point of time", but then the items in the "Restore items" list gets blank and i can't select a database to restore.
The backup contains the log file. When i restore the backup w开发者_JAVA技巧ithout the "Point of time" option the file is also restored.
Is there something i need to enable when i make the backup? Or what is doing wrong here?
Point-In-Time restores need a backup that contains the DB log. If you take a simple backup only, there is no information what rows are changed over time. For backups that can restore to any point in time, set the database to the Full Recovery Model, this includes the log in backups. See MSDN for details.
精彩评论