We have a vertical market app on Sql 2008 Express on a XP workstation. We do normal, local (ie SB&FTP is on the pc in which the database and database engine is housed), full backups every night (just the application database, not the system databases). The resulting zip files get transferred to an offsite backup location.
In the event of a catastrophic failure of the pc (storm surge, theft, or fire), we replace the PC with a new PC. Assuming we install the same version of Sql 2008 Express are there any issues we could run into in restoring that database from the old pc's SQL backups which we might encounter? In other words, is the SQL Zip file backup SQLBackupandFTP creates transportable to a replacement PC?
Eric
