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
WholesaleBackup provides a full suite of white label backup software
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.
Want to Start an Online Backup Business?
After seven years of running both Windows and [...]
Introduction to Scaling and Redundancy We’ve received a [...]
One of our partners asked me today about [...]
See What Our Partners Are Saying About Us
We were able to quickly restore our clients data without any issues using their last good backup – saving them from total data loss and stopping their business!
Your response time to any and all my request is far superior to any customer service I’ve ever received my ENTIRE CAREER.
I am very impressed with the level of customer care and communication you have put forth into making sure that our setup with you guys goes smoothly. It is rare nowadays to find vendors that take pride in their products as well as show concern for a client’s well-being.
After using another white-label cloud backup solution for years, switching to WholesaleBackup has been a lifesaver. MUCH less maintenance, cost, bandwidth, and the U.S. based support is the stellar. The software and interface is SO much simpler and easy to use. I would recommend WholesaleBackup to any MSP looking to streamline their cloud backup system.
After trying multiple name brand backup vendors, we finally Partnered with WholesaleBackup and couldn’t be happier with the functionality and cost.
