Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Toronto, Canada
    Posts
    30

    Unanswered: HELP : Restore of Server7 DB from Netbackup (.BAK FILE)

    I posted this problem last week and still couldn't get this to work.
    I have a backed up copy of a production db that i want to test. The production server is using server 7 white i have 2000 at my desktop. How can i get this to work ? I am beginning to 'lose' it.
    Any help would be greatly appreciated. I would like to complete this test today.
    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    What is the error message you are getting?

  3. #3
    Join Date
    Sep 2003
    Location
    Toronto, Canada
    Posts
    30

    error message from server7 backup (bak)

    error message from server7 backup (bak)

    Server: Msg 3201, Level 16, State 2, Line 1
    Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TEST'. Device error or device off-line. See the SQL Server error log for more details.
    Server: Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.

  4. #4
    Join Date
    May 2004
    Posts
    44
    I met this kind of error before. The reason is the permission at that forlder. So I guess you may check your permission on server box, drive, forlder...

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Man you've been asking that quite a bit...stick to 1 thread...

    http://www.dbforums.com/search.php?searchid=111088

    Why don't you post the code....

    The only one I know who has telepathic powersa is a blind dude...and since he can't see the screen in the first place, that's a good thing....

    Now where the hell did he go?


    Try this and let us know what you get

    Code:
    RESTORE FILELISTONLY
       FROM DISK = '"D:\Tax\BackUp\TaxReconDB.dmp"'
    Just change my dump file to yours...my guess is the spaces in the path are your problem...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Mar 2004
    Location
    NJ
    Posts
    14
    Are you asking how to restore a SQL 7 database on SQL 2000?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •