How to Restore a SQL Server Database when backup up as a file
In our new WholesaleBackup client release (when running in experimental mode), whether or not you select an entire VSS Component to backup, the WholesaleBackup client will activate the Component’s Writer, so for example, if you select a single SQL Server MDB and LDF file or an Exchange EDB file, the backup of that file will occur using the corresponding VSS Component if the file is specified as being served by the Component. What this means is that whereas formerly, selecting an MDB & LDF file would insure it was in a “crash consistent state” but all its data might not be written to disk (and thus the backup), now the file would be backed up via Microsoft’s “SQLServer Writer” which means it is in a known restorable synchronized state.
So, assuming you selected some Microsoft SQL Server MDF and LDF files to backup, how do you restore them? Restoring Microsoft SQL Server databases from MDF/LDF files is straightforward using Microsoft SQL Server Studio Management Express. The procedure is simply one of replacement and attachment:
Steps to restoring SQL Server from MDF and LDF backed up Files
- Restore the .MDF and _1.LDF files to a “New Location” using our software client.
- In Microsoft SQL Server Studio Management Express right-click on the database you will be restoring in left tree-view, make note of the location of its files (it maybe something like C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data), and pick Detach.
- Copy the .MDF and _1.LDF file from step 1 to the location of the files you detached in the previous step and be surethe permissions on the two resultant files are the same as the files you overwrote (else you will get an error in the next step).
- In Microsoft SQL Server Management Studio Express Right-click on Databases in left tree-view and pick Attach and then choose the .MDF file you replaced in previous step.
Please contact us to get a copy of the document entitled “Backing up VSS Writer Components, including Microsoft Exchange…” for more information.
WholesaleBackup provides a white label business solution, which allows you to offer secure offsite data backups
You can build your very own Windows backup server using our server backup platform then provision enduser online backup clients branded with your company name. Your customers will have a local and online backup system where they can store their backup data in a local vault on their own machine in addition to having another backup storage vault on your Windows backup server.
We also provide a hybrid cloud backup platform that allows you to store customer data on very cheap cloud storage from Amazon S3 and Google cloud storage. This options does not require you to have your own server. All you have to do is provision the cloud backup clients with your company brand and logo, once they are installed and the selections are made for the files and folders to backup, the data will go through a de-duplication process to avoid duplicate files, then create file blocks which are encrypted for transmission which will be sent to your cloud storage vault.
Whether you choose to build your own backup server or create your own cloud backup clients, you can run and monitor your backup business from a web browser with the Backup Management Web Console, which centralizes all of your customers status, backups, settings and billings information. Our Partners, MSPs, VARs and resellers, call this the mission control center for their backup operations.