Hot answers tagged

27

No, this is not possible.SQL Server 2017 backups cannot be restored by any earlier version of SQL Server ref Also, regarding detatching and reattaching per the docs: After being attached to SQL Server 2017, the database is available immediately and is automatically upgraded. This prevents the database from being used with an older version of the ...


4

You could run a RESTORE HEADERONLY on the backup file to read the contents and get the ServerName column. For example: CREATE DATABASE BLABLA GO backup database BLABLA to disk = 'c:\temp\BLABLA.BAK' RESTORE HEADERONLY FROM DISK = 'c:\temp\BLABLA.BAK' Result: With the servername column being the one you want for the backup(s) residing in the backup file....


1

Check the following solution: Solution 1 Check security permission for user Go to the location of the backup folder where you have stored the.BAK file Right click on the backup file and select Properties Go to Security Tab Now check the Deny permission for Authenticated users Click on Edit and remove the Deny Click OK Solution 2 Manually delete the ...


Only top voted, non community-wiki answers of a minimum length are eligible