What are the minimum Windows permissions to install and use ApexSQL Restore?
What are the minimum SQL Server permissions to use ApexSQL Restore?
The minimum permission required to attach backup files is:
- dbcreator role membership on the target SQL instance
What’s the difference between attaching a backup using ApexSQL Restore and restoring it using SQL Server?
Backups attached using ApexSQL Restore provide the same functionalities as databases restored using SQL Server native restore; however, the restore process itself is twice as fast and requires significantly less disk space if ApexSQL Restore is used
What kind of backup can be attached?
Both native and natively compressed single file backups can be attached using the tool; this includes full, differential, and transaction log backups
Does ApexSQL Restore support FILESTREAM?
Yes. ApexSQL Restore supports FILESTREAM
Does ApexSQL Restore support encrypted backups?
Yes. You can attach full, differential, or transaction log backups taken from databases encrypted with Transparent Data Encryption
Do I have to copy the files I want to restore to the SQL Server machine?
No, you can leave them on the remote machine as ApexSQL Restore can restore remote files