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 AbbottHi,
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
>|||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...
when
following
and
>
>.
>
No comments:
Post a Comment