A file, page, or piecemeal restore is online by default. During an online file restore, any file being restored and its filegroup are offline. If any of these files is online when an online restore starts, the first restore statement takes the filegroup of the file offline.. GeoPITS brings you the comprehensive details of Online page and file restore's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | ||||
| Version v2017 | Yes | ||||
| Version v2016 | Yes | ||||
| Version v2014 | Yes | ||||
| Version v2012 |
A file, page, or piecemeal restore is online by default. During an online file restore, any file being restored and its filegroup are offline. If any of these files is online when an online restore starts, the first restore statement takes the filegroup of the file offline.
You can find more details about this version here
Back to all features