1 Reply by SueFoster (edited by SueFoster 12-10-2008 14:46:59)

  • SueFoster
  • Member
  • Offline
  • Registered: 04-10-2007
  • Posts: 19

Re: Copying database for backup purposes

In Recorder 3.4.5 I took a copy of the database file on to a memory stick and CD so that if anything went wrong we still had the data and could simply copy the DATA folder back on to the computer.  Is this still possible within Recorder 6 or do you have to go through the backup procedure which takes longer?

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Copying database for backup purposes

It is technically possible to copy the database file (NBNData.MDF) to a backup device, but this would require you 'detach' the database, then copy it, then 're-attach' it to the server. So it's actually easier to use Recorder 6's built-in backup procedure.

You can, however, run the same backup procedure that is found in Recorder outside of Recorder. What we do here is have the backup running on a schedule (scheduled backups are a feature of the full SQL Server, but it's also possible to run a scheduled backup using a batch file or script on MSDE or SQL Server Express) which does a backup of the database to a location on the network that subsequently gets backed-up onto tape in our nightly run. You could do something similar that backs-up onto a memory stick or external drive on demand. The principles involved are just the same.

Here are a few of articles that might help:

http://www.mssqltips.com/tip.asp?tip=1174
http://www.mssqltips.com/tip.asp?tip=1083
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003#12

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Copying database for backup purposes

Hi Sue,

Once the backup location is setup (which takes time), backing up is relatively quick. You can then copy this backup file onto a stick/cd etc. But no you cannot backup using a stick/CD in the same way you did with Recorder 3.

Lynn