|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
Hi,
When creating a database backup with SqlBackupAndFTP the output is a zip file.
How do I use this zip file with One-Click SQL Restore? It only lets me select .bak files, and I don't know how to create such file...
Hope you can help...
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Unzip the file, inside is a BAK file. Then use One-Click SQL Restore. We could have made One-Click SQL Restore to work directly on a zip file, but thought it is unnecessary for a tiny simple lightweight freeware program.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
I use the latest version of SqlBackupAndFTP downloaded from this site. However, when creating a backup my output is a zip file containing two files with a .sql file extension. There is no .bak file.
What am I doing wrong?
BTW - love the idea and simplicity of your software, only wish I could make it work... :-)
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
You can only get BAK files when SQLBackupAndFTP is installed locally on the same computer as MS SQL Server. In your case you do backups of a remote computer, so you only get script files. You can open and run the script in SQL Server Management studio. Read more about remote backup here.
|
|
|
|
|
