knowledge base

Categories	Search

Knowledge Base > FAQs > Troubleshooting > Other

Troubleshooting Problems with Backup and Restore Data

Last Updated

June 15th, 2011

Would you like to...

Print this page

Email this page

Post a comment

Export to PDF

If you are getting an error message when you try to backup or restore your inFlow data please try the following solutions sequentially.

Try with your desktop
If you're backing up, please try the saving the backup file to the desktop folder. If you're restoring, please try copying the backup to the desktop and then restoring.

Check that you're on the latest version
If you are having problems with the backup, please ensure that you are on version 2.0.0.9 or higher of inFlow, since we fixed a number of issues related to backups then. If not, you can upgrade to the latest version by downloading and running the Quick Installer from our website again.

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 or Windows 7, 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.

Install SQL Server SMO Objects
If you still have problems, close inFlow, then download and install the following file onto your computer:
For 32-bit Windows:
http://www.archonsystems.com/Download/SQLServer2005_XMO_x32.msi

For 64-bit Windows (if you're not sure, you probably want the 32-bit one above)
http://www.archonsystems.com/Download/SQLServer2005_XMO_x64.msi

Then load inFlow again and try once more.

Manual Backup Procedure
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:

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.

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, bring up the Start Menu --> type "cmd" --> right click on cmd.exe --> select Run as administrator.

2) Copy the following line
sqlcmd -S .\INFLOWSQL
then right click the command prompt, select paste, and press enter.

3) 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 type in "GO"
then press enter.

Note: 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.

knowledge base

Product

Support

Community

Company