1 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Recorder backup problem

I have tried to back up the database using the Database Tools - Backup Database function and have received the following message - does anyone know what it means, and if I can back up the database another way?


Exception occurred in application Recorder 6 at 19/04/2010 16:19:26.
Version : 6.13.2.176

Exception path:
EOleException : The backup data in 'NBNData_Backup' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable

Last event\actions:
  actBackup invoked
  actBackup invoked
  actBackup invoked

Operating System : Windows XP  5.01.2600  Service Pack 3
Physical Memory available : 1,046,512 KB

DLLs loaded:
  advapi32.dll (5.1.2600.5755)
  comctl32.dll (5.82.2900.5512)
  comdlg32.dll (6.0.2900.5512)
  gdi32.dll (5.1.2600.5698)
  gdiplus.dll (5.2.6001.22319)
  HHCtrl.ocx (5.2.3790.4110)
  kernel32.dll (5.1.2600.5781)
  mpr.dll (5.1.2600.5512)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1132.0)
  ole32.dll (5.1.2600.5512)
  oleaut32.dll (5.1.2600.5512)
  shell32.dll (6.0.2900.5622)
  user32.dll (5.1.2600.5512)
  version.dll (5.1.2600.5512)
  winmm.dll (5.1.2600.5512)
  winspool.drv (5.1.2600.5512)

2 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 262

Re: Recorder backup problem

Hi Fran,

If I remember rightly you are still on MSDE and waiting to move onto SQL Server? When we were in that situation we were able to use SQL Server Management Studio Express to make backups so that might be worth a try if it is already installed on your network. It is a free download from the Microsoft website.

However, it sounds as if your backup volume could be corrupt, in which case you will need to sort that out first. I can't remember how to do that in MSDE, can someone else advise?

Janet

Janet Simkin
British Lichen Society

Janet Simkin's Website

3 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Recorder backup problem

I agree, it sounds like your existing backup file is broken. If you know where it is, then you could try renaming the backup file and trying again, so Recorder creates one from fresh.

John van Breda
Biodiverse IT

johnvanbreda's Website

4 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Recorder backup problem

Hi John

I've renamed the file and tried again but get this message - I don't think this is good news!

Exception occurred in application Recorder 6 at 20/04/2010 16:23:46.
Version : 6.13.2.176

Exception path:
EOleException : Write on 'NBNData_Backup' failed, status = 112. See the SQL Server error log for more details

Last event\actions:
  actBackup invoked

Operating System : Windows XP  5.01.2600  Service Pack 3
Physical Memory available : 1,046,512 KB

5 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Recorder backup problem

Did the original backup file re-appear after trying that? If not I wonder if it is a permissions problem in which case you could try moving the backup directory in Recorder. Otherwise I'm not sure what could be wrong, and maybe Janet's suggestion of trying SQL Server Management Studio Express to make backups is the best bet.

John van Breda
Biodiverse IT

johnvanbreda's Website

6 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Recorder backup problem

No the original backup file didn't reappear.  I'll try moving the backup directory.

I installed SSMSE on my client machine but was unable to login to the server.  I have admin rights to the server and have tried those.  I am going to seek help from our IT department, but before I do this, is there a way of bypassing this login page or finding out the username used to login to the server? (which would give me an idea of the password.)  We don't login to the actual server machine very often, hence my uncertainty.  Thanks.

7 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Recorder backup problem

Moving the backup directory didn't work either!

I have now logged onto the actual server machine but a series of messages have popped up relating to insufficient space on the hard drive.  On checking the C: properties we have only 560KB left!  Could this be the cause of the backup problems?  Our database is at 1.79GB, which is why we are taking the backup, as we need to upgrade to SQL Server to allow us to expand.

8 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Recorder backup problem

We have cleared some space on the server and have successfully backed up Recorder.  Thanks for the advice.