Post reply

Backup_restore failure

  • 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

    NULL NULL 1 NULL 0 1 2 DMN_NUFF1\svc_sharedsql

    IXNUFSSC1 IMS_NGH 611

    2007-09-16 15:28:04.000 1809118720 125963000000228900048 125963000000236800001 125963000000228900048

    125942000000106100172 2008-09-24 06:00:01.000

    2008-09-24 06:08:45.000 52 0 1033 196609 80 4608 9

    0 3050 IXNUFSSC1 1536 1C23E2C7-6533-4FBD-9B6A-22A575BF2F65 C71B1528-FB01-47B6-85DF-4BF6E42EA322

    SQL_Latin1_General_CP1_CI_AS 74F15E09-4215-4CF1-9296-E0F8818C22DE

    0 0 0 0 0 0 0 0 0 1

    C71B1528-FB01-47B6-85DF-4BF6E42EA322 NULL SIMPLE

    NULL NULL Database 90F5086D-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.

  • September 26, 2008 at 2:26 pm

    #877961

    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

  • September 26, 2008 at 2:55 pm

    #877976

    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.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • September 27, 2008 at 7:37 am

    #878078

    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.

  • September 27, 2008 at 5:52 pm

    #878106

    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

  • September 29, 2008 at 3:57 am

    #878305

    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.

  • September 29, 2008 at 6:28 am

    #878350

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

    Cath

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

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