Conversion file not formed correctly

• 
  If you run the RESTORE SQBHEADERONLY ... command on the SQL Backup file, what is the reported database size? E.g. via Query Analyzer
  
  master..sqlbackupc '-sql "RESTORE SQBHEADERONLY FROM DISK = [...] "
  
  Is the reported size approximately equal to the actual database size? Also, are the LSN values displayed, instead of just 0? If the data is not confidential, could you pls send us the SQL Backup file?

  petey July 19, 2005 21:35

  - 0 +
• 
  I will have to run it tomorrow morning when I get to the office. I will post the results. Unfortunately I cannot send the file for two reasons, the compressed file is 1.4 GB and it is confidential.

  rkoros July 20, 2005 03:50

  - 0 +
• 
  OK, here are the results. The BackupName is marked as *** INCOMPLETE ***, Position is 1 and the rest is NULL.

  rkoros July 20, 2005 10:35

  - 0 +
• 
  Here is some additional information. I tried running the convert again and for the new version 3.2.0 there is a progress echo, it got to 40% then stopped and reported that the MTF file created. Strangely enough it would appear that the percentage reported as being converted is about the percentage that is restored prior to failing.

  rkoros July 20, 2005 10:51

  - 0 +
• 
  Looks like you ran BACKUP HEADERONLY. Could you pls run BACKUP SQBHEADERONLY on the SQL Backup generated backup file?
  
  Looks like the backup file is incomplete. Could you pls check for logs (usually C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log) for any error during the backup?

  petey July 20, 2005 11:32

  - 0 +
• 
  No problem. First, no errors reported, all backups were successful. Second, RESTORE SQBHEADERONLY is not a recognized command and I am running it on the server that has SQL Backup installed on it. Of course that is through the Query Analyzer not via the command prompt. Here is what you're looking for:
  
  Backup group ID: 49733565
  File Number: 1 of 1
  
  Backup Size: 8.320 GB
  Backup start: today @ 0840
  Backup end: today @ 0844
  
  Server Name:
  Instance: (local)
  Database name: herbert
  
  First LSN: 466375000007993100001
  Last LSN: 466375000007993300001
  Checkpoint LSN: 466375000007993100003
  Differential base LSN: 466375000007988400002

  rkoros July 20, 2005 11:47

  - 0 +
• 
  When you ran the conversion, were you creating the MTF file on an NTFS drive?

  petey July 20, 2005 12:15

  - 0 +
• 
  Nope, FAT32.

  rkoros July 20, 2005 12:41

  - 0 +
• 
  FAT32 files are limited to 4 Gig in size.

  petey July 20, 2005 18:28

  - 0 +
• 
  Ok, so let me get this straight, you're saying that I cannot create the converted file because I the system I am using is FAT32 instead of NTFS? Of course you are. So, you wouldn't happen to know of an easy, painless way to convert from FAT32 to NTFS. If memory serves, you can convert from NTFS to FAT32, but not the other way around. Please tell me I am wrong.

  rkoros July 21, 2005 03:04

  - 0 +
• 
  In the <windows>\system32 folder, there is a console app named convert.exe. Use this to convert the FAT32 volume to NTFS.
  
  I am not familiar with all the options, nor aware of any caveats that may apply, so cannot advise you further. It usually works, but I will not be responsible if anything goes wrong.

  petey July 21, 2005 03:16

  - 0 +
• 
  Relax, I am not looking for someone else to blame if it goes sideways. I can do the research on the correct syntax.
  
  I appreciate the help.

  rkoros July 21, 2005 03:31

  - 0 +
• 
  You're welcome. By my estimate, it's past midnight over there, a time when thoughts are scrambled and 'oops' decisions are made, hence the caveat.

  petey July 21, 2005 03:58

  - 0 +
• 
  Fair enough. It was actually after 1 AM when I was on, apparently I selected the wrong time zone change and I am just to lazy to change it. You are quite right about 'oops' decisions being made late into the night.
  
  BTW it worked correctly this time. It is amazing what happens when all the pieces are in place.
  8)

  rkoros July 21, 2005 11:50

  - 0 +

Add comment

Please sign in to leave a comment.