Here, you can also select the split or compressed. Next, choose the recovery mode as per the level of corruption. You should see the service account listed in the security settings, and can adjust the permissions accordingly.Īfter adding permissions (I added Full Control, to match the default SQL Backup folder.) and restarting the SQL Server Management Console, I was able to select and restore my backup file. Simple Steps to open BAK file - Install & Run SQL Backup Recovery Software. If you have the appropriate software installed on your device, opening the BAK file should be done without any problems by double-clicking on the file's icon. Select MSSQLSERVER, and click OK to accept the selection. How to open BAK file The software referred to as BAK Opener allows you to freely work with BAK files, including opening their contents. You will then see a list of the matching service accounts.
Type in NT SERVICE\MSSQLSERVER in the name box. This type of tool is nothing more than a program or an online application that allows you to easily view the content of the data stored in the BAK file.Change the Locations to the local server name.(The change must be made on the actual server, not through a network share.) I identified the account by comparing the permissions of the default SQL Backup folder permissions to the folder containing the backup file.Īdding the service account is not as simple as it sounds. The difference is that the account we needed to add was NT SERVICE\MSSQLSERVER. It turned out to be a permissions issue, as illustrated in some of the other answers.
0 kommentar(er)
