This software allows you to back up your SQL Server databases to many popular cloud storage services such as Dropbox, OneDrive, Amazon S3, Microsoft Azure, Box, and Google Drive.
The same concepts apply to other versions (such as Express Editions) as well.Free download SQL Backup Master 6.3.610 full version standalone offline installer for Windows PC, SQL Backup Master Overview
Or you can restore the database using T-SQL:īoth of the above pages describe the process for SQL Server 2005, 2008, and 2012. The following MSDN page has instructions for restoring a database backup within SQL Server Management Studio: The precise instructions for this step will depend upon your installed version of SQL Server. You can also find this path by initiating a database backup from within SQL Server Management Studio, browsing for the backup path, and then observing the default folder location. Or for SQL Server 2005 it would usually be:Ĭ:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup The precise path of this Backup folder will depend upon your installed version of SQL Server, but an example of SQL Server Express would be:Ĭ:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup Doing so helps to ensure that the backup file is visible to SQL Server, and that it can access it without permissions issues. Next, we recommend that you move the decompressed ".bak" file to the default backup folder of your SQL Server instance (the one to which you'll be recovering the database).
When decompression is complete, you'll be left with a database backup file with a ".bak" file extension. For this reason, we recommend that you use the decompression tool included in SQL Backup Master instead. Please note that the built-in Windows "compressed folder" feature does not support AES-256 decryption, nor does it support 64-bit zip archives. If it is encrypted with AES-256, you'll also need to make sure you have the associated password available. Next, you'll need to unzip the backup file created by SQL Backup Master. If you're unsure about how to download a file from your particular service, please see their help documentation. Typically this will involve logging into the remote storage service (such as Google Drive, Dropbox, etc.), locating the backup file, and then right-clicking (or taking some other action) to download it. In a manual recovery, you'll first need to download the database backup files from their current storage location. The remainder of this topic, we're going to assume that you're manually recovering a database backup that was created with SQL Backup Master. Although SQL Backup Master includes useful database backup recovery capabilities, there may be time when you want (or need) to recover a database backup manually.įortunately, this is generally a very straight-forward process - although some experience with SQL Server administration is certainly recommended.
0 kommentar(er)
