Thread started: Aug 17 2011, 11:03 AM EDT
Watch
The backup/restore procedures won't work between PC's. The SQL server error message is that the backup database set holds the backup of a different database than the current (that would be my new) AVDATA database.
So how do we move AirVision to a new PC? Maybe I will delete the current (new / empty) database and see if that will work.
Thanks,
Ben
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
|
Last Reply:
RE: moving AirVision to a new PC
By: ,
Aug 17 2011, 12:52 PM EDT
Answer is indeed to delete the new & empty AVDATA database (or just don't create it during the initial installation of the SQL server.) Then restore the backup to AVDATA and it will create a new and populated database. I haven't fully tested the new one, but it looks OK so far.
FYI, I am still using SQL Server 2005 Express, and AirVision and the SQL server share the same PC. I migrated the setup from a Windows 7 PC to a Windows XP box.
There is a DUH! moment were Rena' pointed out that I probably had never clicked on the "overwrite exisiting database" option! Maybe none of this discussion would have been necessary if I had!
Ben
out of
found this valuable.
Do you find this valuable?
|