How to restore backup made with Database Backup feature?

[AbleMods]

I'm not finding any instructions in the Merchant Guide on how to restore a backup made with the Database Backup feature. Am I missing something?

I did on a test site today, the file was 615mb. That isn't loading into SQL Studio Manager all that well.....has to be another way.

[Katie]

I don't know how practical it is to have this feature. For a small store, I'm sure it's no problem, but for most stores, the size of the sql file is probably going to be a problem. I'll ask around and see what the process is to restore the file using SQL server management.

Thanks
Katie

[AbleMods]

I don't know how practical it is to have this feature.

To be honest, I had never used this feature before until this week. I was surprised it comes in as a .SQL file. I was expecting an actual SQL backup (.bak) file. But then after I thought about it for a sec, I realized that it's not practical to generate a SQL backup file from within the app.

I agree with you Katie. I can name maybe 2-3 clients of mine that could use this feature because their store is so small. Every other client would generate a SQL file that is just too large to deal with.

It's a great idea, I hate to see it being under-utilized. Bummer....

[jmestep]

I did try it once, but I don't remember how large the site was. The file generated OK, but my SQL Server wouldn't run it because of the size. There might have been a work-around for that, but I just stopped at that point.

[Katie]

This document has a lot of information concerning .sql files:

http://stackoverflow.com/questions/2002 ... sql-server