Re: Help - Very Odd Restore Issues
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/21/04
- Next message: zoro24: "Recovering DB from deleted files"
- Previous message: Jaxon: "Re: Performance problem"
- In reply to: Gary Abbott: "Help - Very Odd Restore Issues"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Help - Very Odd Restore Issues"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Help - Very Odd Restore Issues"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 21 Mar 2004 22:45:08 +0530
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: zoro24: "Recovering DB from deleted files"
- Previous message: Jaxon: "Re: Performance problem"
- In reply to: Gary Abbott: "Help - Very Odd Restore Issues"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Help - Very Odd Restore Issues"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Help - Very Odd Restore Issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
