FIRST TRY:
If you are getting an error message when you try to backup or restore your inFlow data please try the following solutions sequentially.
Try doing the backup/restore from the server computer
If you are in multi-user mode, please try it from the server computer. Sometimes, particularly for large databases, the backup will fail when going across a network.
Try running inFlow as an administrator
If you’re on Windows Vista, Windows 7 or Windows 8, please try closing inFlow and starting it by right clicking the icon and selecting Run as administrator, then try running the backup again. If you’re on Windows XP, please ensure that you’re logged in as an administrator. If that works, you should not need to continue running inFlow as an administrator each time.
Check your SQL Server version on both computers
If you get an error during restoring that says “Error: Failed to restore data. Check that the file is admissible.” This happens when the two computers have different version of SQL Server installed. Please check both computer’s list of installed programs:
Windows XP or Server 2003: click Start > Control Panel > Uninstall (or Add/Remove Programs).
Vista, Windows 7 or Server 2008 R2: click Start > Control Panel > Uninstall (or Programs and Features).
Windows 8: Windows Key > type Control Panel > Uninstall (or Programs and Features).
Look at this list for anything that says, “Microsoft SQL Server”, you will either have SQL Server 2005 or 2008 R2 installed. If the computer you’re transferring TO has Microsoft SQL Server 2005 installed, please uninstall inFlow and reinstall using the steps in OPTION 1 here.
If you are getting this error but both your computers are on the same version of SQL Server, please have a look here, as that may indicate a problem with the backup file.
MANUAL PROCEDURES (If you’re still unable to backup/restore)
If none of the above steps worked, then please email us the contents of the log file in the Start Menu -> inFlow Inventory -> “Program Log” so we can look into the problem. In the meantime, you can also manually do a backup as follows:
Manual Backup Procedure
1) Open a command prompt as an administrator.
– on Windows XP, click Start –> Run –> type “cmd”
– on Windows Vista or Win 7 bring up the Start Menu –> type “cmd” –> right click on cmd.exe –> select Run as administrator.
– on Windows 8, hit the Windows Key + R, hit A, and then say Yes to the User Account Control prompting your for permission.
2) Copy the following line
sqlcmd -S .\INFLOWSQL
then right click the command prompt, select paste, and press enter.
3) At the 1> prompt, copy the following line
BACKUP DATABASE inFlow TO DISK = 'C:\inFlowBackup.ifi' WITH FORMAT
then right click the command prompt, select paste, and press enter.
then press enter. It should change to a 2> prompt.
then type or copy the following line
GO
then press enter. It should change back to a 1> prompt and the backup should be made. Exit the window.
Manual Restore Procedure
1) Open a command prompt as an administrator.
– on Windows XP, click Start –> Run –> type “cmd”
– on Windows Vista or Win 7 bring up the Start Menu –> type “cmd” –> right click on cmd.exe –> select Run as administrator.
– on Windows 8, hit the Windows Key + R, hit A, and then say Yes to the User Account Control prompting your for permission.
2) Copy the following line:
sqlcmd -S .\INFLOWSQL
then right click the command prompt, select paste, and press enter.
3) At the 1> prompt, copy the following line
RESTORE DATABASE [inFlow] FROM DISK = N'C:\inFlow_Backup.ifi' WITH FILE = 1
then right click the command prompt, select paste, and press enter.
then press enter. It should change to a 2> prompt.
then type or copy the following line:
GO
then press enter. It should change back to a 1> prompt and the backup should be made. Exit the window.
Note that C:\inFlow_Backup.ifi is where your backup is. If it is at a different location or with a different file name, change it accordingly.
