开发者

MSSQL: Can't restore with Time of Point

开发者 https://www.devze.com 2023-02-20 16:27 出处:网络
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 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?

MSSQL: Can't restore with Time of Point


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消