Re: Help - Very Odd Restore Issues
anonymous_at_discussions.microsoft.com
Date: 03/21/04
- Next message: Greg Linwood: "Re: Equivalent to rowid in Oracle..."
- Previous message: Hari: "Re: Cant find User Default database So, I can't Register my server"
- In reply to: Hari: "Re: Help - Very Odd Restore Issues"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 21 Mar 2004 15:24:59 -0800
I get the exact same error trying to run anyone of those
commands. I am now doing a new backup to only one backup
file. I'll try that.
Gary
>-----Original Message-----
>Hi,
>
>Did you tried RESTORE FILELISTONLY command to identify
the Logical and
>physical names as well
>as try RESTORE VERIFYONLY command .
>
>Syntax of both commands:
>
>
> RESTORE FILELISTONLY FROM
disk='c:\backup\dbname.bak'
>
> RESTORE VERIFYONLY FROM disk='c:\backup\dbname.bak'
>
>
>
>
>Thanks
>Hari
>MCDBA
>
>
>
>"Gary Abbott" <anonymous@discussions.microsoft.com> wrote
in message
>news:1120901c40f5c$29dd3fb0$a101280a@phx.gbl...
>> All,
>>
>> Sql 2000 sp3, Server 2000 sp4
>>
>> I am trying to restore a db to my testing server. I can
>> successfully restore it to my development server. But
when
>> I try to restore it to my test server I get the
following
>> error:Server: Msg 3205, Level 16, State 2, Line 1
>> Too many backup devices specified for backup or restore;
>> only 64 are allowed.
>>
>> Both servers are on the same service packs for windows
and
>> sql. I use the same script, only chnging the drive
>> letters. Any ideas at all? The restore script is below:
>> restore database member from
>> disk = 'u:\member_data_1.bak',
>> disk = 'u:\member_data_2.bak',
>> disk = 'u:\member_data_3.bak'
>> with stats = 1,
>> move 'MemberData00_01' to 'f:\MemberData00_01.MDF',
>> move 'MemberData01_01' to 'g:\MemberData01_01.NDF',
>> move 'MemberData01_02' to 'h:\MemberData01_02.NDF',
>> move 'MemberData01_03' to 'i:\MemberData01_03.NDF',
>> move 'MemberData01_04' to 'j:\MemberData01_04.NDF',
>> move 'MemberData01_05' to 'f:\MemberData01_05.NDF',
>> move 'MemberData01_06' to 'g:\MemberData01_06.NDF',
>> move 'MemberData01_07' to 'h:\MemberData01_07.NDF',
>> move 'MemberData01_08' to 'i:\MemberData01_08.NDF',
>> move 'MemberIndex01_01' to 'j:\MemberIndex01_01.NDF',
>> move 'MemberIndex01_02' to 'f:\MemberIndex01_02.NDF',
>> move 'MemberIndex01_03' to 'g:\MemberIndex01_03.NDF',
>> move 'MemberIndex01_04' to 'h:\MemberIndex01_04.NDF',
>> move 'MemberData02_01' to 'i:\MemberData02_01.NDF',
>> move 'MemberData02_02' to 'j:\MemberData02_02.NDF',
>> move 'MemberData02_03' to 'f:\MemberData02_03.NDF',
>> move 'MemberData03_01' to 'g:\MemberData03_01.NDF',
>> move 'MemberData03_02' to 'h:\MemberData03_02.NDF',
>> move 'MemberData03_03' to 'i:\MemberData03_03.NDF',
>> move 'MemberData04_01' to 'j:\MemberData04_01.NDF',
>> move 'MemberData04_02' to 'f:\MemberData04_02.NDF',
>> move 'MemberData04_03' to 'g:\MemberData04_03.NDF',
>> move 'MemberIndex02_01' to 'h:\MemberIndex02_01.NDF',
>> move 'MemberIndex02_02' to 'i:\MemberIndex02_02.NDF',
>> move 'MemberIndex03_01' to 'j:\MemberIndex03_01.NDF',
>> move 'MemberIndex03_02' to 'f:\MemberIndex03_02.NDF',
>> move 'memberIndex04_01' to 'g:\MemberIndex04_01.NDF',
>> move 'MemberIndex04_02' to 'h:\MemberIndex04_02.NDF',
>> move 'MemberData05_01' to 'i:\MemberData05_01.NDF',
>> move 'MemberData05_02' to 'j:\MemberData05_02.NDF',
>> move 'Member_Log' to 'u:\Member_Log.LDF',
>> move 'member_1_Log' to 'u:\Member_Log2'
>>
>> Thanks in advance,
>> Gary Abbott
>>
>
>
>.
>
- Next message: Greg Linwood: "Re: Equivalent to rowid in Oracle..."
- Previous message: Hari: "Re: Cant find User Default database So, I can't Register my server"
- In reply to: Hari: "Re: Help - Very Odd Restore Issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
