Re: Restore Sql6.5 dump to different server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 12/06/04 

Date: Sun, 5 Dec 2004 22:15:31 -0800

Can you create a new device with sp_addumpdevice?

As I said, I haven't used 6.5 in a long time, and I don't have any of the
old docs available. 

-- 
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Brian PIerce" <BrianPIerce@discussions.microsoft.com> wrote in message 
news:032AE545-5F0E-41DB-9049-388D8F2E8865@microsoft.com...
> The load command wants the backup device however the device i have has 
> never
> done any backing up, how would i get the dump file in there?
>
> "Kalen Delaney" wrote:
>
>> Brian
>>
>> It's also been a LOOONG time since I restored a 6.5 database.
>> Try running the LOAD command from ISQL/w. If that doesn't work you should 
>> at
>> least get an error message, and that could give us a reason as to why you
>> are having trouble.
>>
>> -- 
>> HTH
>> ----------------
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>>
>> "Brian PIerce" <BrianPIerce@discussions.microsoft.com> wrote in message
>> news:C2245F4F-96CA-41B7-A874-75798DDDC23D@microsoft.com...
>> >I have tried everything but i cna not get the :Restore Now" button to
>> >showup
>> > after selecting the file i want to restore from. I have the
>> > SP_HELP_REVDATABASE output.  I was not able to get a copy of the master 
>> > db
>> > please help 12/05/04 10 AM
>>
>>
>>

Relevant Pages

  • Re: Restore Sql6.5 dump to different server
    ... The load command wants the backup device however the device i have has never ... how would i get the dump file in there? ... >> after selecting the file i want to restore from. ...
    (microsoft.public.sqlserver.setup)
  • Re: dump restore pain and suffering
    ... /mnt is a ufs formated usb drive. ... I've even done a restore -rNf /mnt/test.root.dump just to make ... sure it doesn't complain out the dump file. ... from old hard drives to a RAID1 setup on a 3ware controller and everything ...
    (freebsd-questions)
  • Re: dump restore pain and suffering
    ... /mnt is a ufs formated usb drive. ... I've even done a restore -rNf /mnt/test.root.dump just to make ... sure it doesn't complain out the dump file. ... but is anyone really using dump/restore and having success ...
    (freebsd-questions)
  • Re: dump restore pain and suffering
    ... I've even done a restore -rNf /mnt/test.root.dump just to make ... sure it doesn't complain out the dump file. ... but is anyone really using dump/restore and having success ... i used it to migrate from old hard drives to a RAID1 setup on a 3ware controller and everything went well. ...
    (freebsd-questions)
  • Re: Replace System01.dbf
    ... restore this dump file and find out how to reenter the data by hand. ... This kind of sucks. ...
    (comp.databases.oracle.server)