Backup_restore failure

Question

Backup_restore failure

dba_pkashyap

Hall of Fame

Points: 3336
More actions
September 25, 2008 at 2:53 am

#193204

This is the first week we have started getting a backup from a live site, which we restore at our dev server and support them.
When I tried to restore the backup using SSMS, the backup set doesnt appear under the backups to restore,then i tried this
restore headeronly from disk='D:\scantrack\BackupDBs\Recent Customer DB Downloads\IMS_NGH_240908\IMS_NGH_240908.BAK'
and found that the backupname is NULL
NULLNULL1NULL012DMN_NUFF1\svc_sharedsql
IXNUFSSC1IMS_NGH611
2007-09-16 15:28:04.0001809118720125963000000228900048125963000000236800001125963000000228900048
1259420000001061001722008-09-24 06:00:01.000
2008-09-24 06:08:45.00052010331966098046089
03050IXNUFSSC115361C23E2C7-6533-4FBD-9B6A-22A575BF2F65C71B1528-FB01-47B6-85DF-4BF6E42EA322
SQL_Latin1_General_CP1_CI_AS74F15E09-4215-4CF1-9296-E0F8818C22DE
0000000001
C71B1528-FB01-47B6-85DF-4BF6E42EA322NULLSIMPLE
NULLNULLDatabase90F5086D-AEAF-4603-A8F9-A699C6BA9FE8
My question is does the restore doesnt work if the name of the Backup is NULL, and is there any way I can make it to work.
Thanks for all the help.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ray Herring SSCertifiable Points: 5533 More actions · Answer 1

I am not sure I understand all of the issues you face, but I can assure you that you can restore a foreign back up on a local server. I sometimes do this 5 or 10 times a day.

If you are using the SSMS GUI to do the restore then, after you pick from the menu you get the restore dialog.

Select the radio button.

That should be all you need. click and watch it run.

Good Luck

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

The backup name shouldn't matter, it's the data in there. You need the logical names to "move" the files, but you should just restore this file as a database name AFAIK.

matt stockham SSCrazy Eights Points: 9942 More actions · Answer 3

I'm not entirely clear on your problem, it sounds like you add the file that you want to restore from but it doesn't display any valid backups in the list. If this is the case, then you can still restore it using SQL (assuming it is a valid backup).

I experience the same problem at times, no idea why it happens.

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

What's the name of your backup file ??

I was helping someone the other day, and when he created the backup file, he forgot to put .BAK as the extension. When he was restoring, he forgot he hadn't used .BAK in the name. He renamed it and all was well

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 5

Thanks for all the replies, I do regularly 5-10 restores a day or sometimes even more, but never seen this, I used to solve all the other issues I face while restoring.

I spoke about this to the clients who sent me this message and they said that the file was corrupt!

The next day I got another backup and it even said the backup name as NULL but restored it without any issues.

A quick question, can I do a point in time recovery to a new database with a Full backup(no logs), its in dev environment.

Thanks for all the help.

Pavan.

Cath Trimble SSCarpal Tunnel Points: 4201 More actions · Answer 6

No, you need the TLog backups to do a point in time restore.

Cath