Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts

Tuesday, March 27, 2012

Few questions on Backups for warehouse

I am starting to load a data warehouse for a retention period of 10 years. My database backup plan is as follows -

1. Perform full back on Sunday.
2. Perform differential backup everyday from Mon - Sat.
3. Perform transaction log back-ups every hour on all days.

My recovery mode is going to be BULK-LOGGED at all times. I had a few questions / comments on the Maintenance Plan that I would be creating for the back-ups. My database name is Warehouse.

1. Differential Backups cannot be created via a Maintenance Plan. Only a full-backup gets created. Am I correct?

2. I shall be running Optimizations and Integrity checks prior to full-backup. Is this ok?

3. Remove files (both .BAK and .TRN) older than - I am thinking of having 6 days. I want only one full back-up at a time in the server. What settings can I use? I think the old back-up gets deleted when the new one is successful. What settings in the Maintainence Plan do I have to use to overwrite the previous back-up with the current one?

System Databases -

Should the settings for System Databases be the same as my Warehouse database?

The Maintenance Plan takes care of full-back up and TLOG back-ups. For Differential Backups I have to use the All Tasks from EM and specify the Differential Backup job. Correct?

All kinds of back-ups can occur in the database when it is active. Meaning, I have a job that loads data in the warehouse when a back-up is occurring simultaneously. Am I correct?

I do not intend to shrink the Transaction Log at any time, since it gets backed up every hour I do not expect it to grow to a large size. If I do have to shrink it, then I change the recover mode to Simple, shrink the log and then immediately do a full-backup and after that set the mode back to Bulk-Logged. Is the sequence of steps correct?

Please let me know your inputs.

Thanks,

Vivek1. Incorrect. Please refer to BOL.

2. Sure it's okay. It can be resource intensive so you may consider running during non-peak hours. Also, you should always run DBCC CHECKDB before a backup and if possible, after a backup completes. the sooner you find a problem, the better.

3. Delete all tran and diff backups after a successful full backup completes and has been written to another media (secondary copy) such as tape

IF YOU ARE RUNNING TRAN LOG BACKUPS, YOUR TRAN LOG GETS AUTOMATICALLY TRUNCATED. IN ANY CASE, YOU ARE RUNNING IN BULK MODEL. YOU REALLY SHOULD READ BOL.

Friday, March 23, 2012

Feedback from Tape Backups

Hi Folks,
I'm trying to find a way to get access to the STATS output from the BACKUP
command during automated backups.
When running the BACKUP command in QA it shows the output, line by line, as
the backup progresses. Is there any way I can get this information when the
BACKUP statement is run from a job? I thought the console tool might have
been the answer, but it doesn't show any progress messages.
Is the only option to use the Job/Step/Adv/Output to file option, and "tail"
the file?
TIA
J.
In this case, the client application is SQL Server Agent, more specific, the sub-component in Agent
that executes your TSQL job steps. And Agent isn't written to output this information "as it goes".
It might update the output file as information comes in (I haven't tested this), so I think that
this is probably your best bet. Another option is of course to schedule an EXE file that you wrote
and you have in your EXE file code to output the information to where ever you want it to go.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
news:eL976GjHFHA.1860@.TK2MSFTNGP15.phx.gbl...
> Hi Folks,
> I'm trying to find a way to get access to the STATS output from the BACKUP
> command during automated backups.
> When running the BACKUP command in QA it shows the output, line by line, as
> the backup progresses. Is there any way I can get this information when the
> BACKUP statement is run from a job? I thought the console tool might have
> been the answer, but it doesn't show any progress messages.
> Is the only option to use the Job/Step/Adv/Output to file option, and "tail"
> the file?
> TIA
> J.
>
>
|||Thanks Tibor
With regard to your comments on creating my own EXE, how would I go about
getting access to the messages - given that they are not returned as part of
a result set?
Cheers
J.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OU%23Lr5lHFHA.4060@.TK2MSFTNGP14.phx.gbl...
> In this case, the client application is SQL Server Agent, more specific,
the sub-component in Agent
> that executes your TSQL job steps. And Agent isn't written to output this
information "as it goes".
> It might update the output file as information comes in (I haven't tested
this), so I think that
> this is probably your best bet. Another option is of course to schedule an
EXE file that you wrote
> and you have in your EXE file code to output the information to where ever
you want it to go.[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
> news:eL976GjHFHA.1860@.TK2MSFTNGP15.phx.gbl...
BACKUP[vbcol=seagreen]
as[vbcol=seagreen]
the[vbcol=seagreen]
have[vbcol=seagreen]
"tail"
>
|||First I believe that you have to program asynchronously. Otherwise the command will be blocked until
it has finished. These are returned as messages, technically same way as PRINT and errors. I'm no
API expert, so you might want to investigate this further and possibly asking in a newsgroup
dedicated to the API you are using (ADO, ADO.NET etc).
The bigger problem is how your EXE will output to the screen. Remember that agent is a service (in
"NT") and a service has no Window context...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
news:ePdMhboHFHA.236@.TK2MSFTNGP14.phx.gbl...
> Thanks Tibor
> With regard to your comments on creating my own EXE, how would I go about
> getting access to the messages - given that they are not returned as part of
> a result set?
> Cheers
> J.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OU%23Lr5lHFHA.4060@.TK2MSFTNGP14.phx.gbl...
> the sub-component in Agent
> information "as it goes".
> this), so I think that
> EXE file that you wrote
> you want it to go.
> BACKUP
> as
> the
> have
> "tail"
>
sql

Sunday, February 19, 2012

failure on backup device

I have a created a backup device that maps to another server. When the job
runs that refences that backup device it is sucessful...for the first cupple
times that it is scheduled to run, but then it fails with the following
message
Event Type: Error
Event Source: MSSQLServer
Event Category: Kernel
Event ID: 17055
Date: 5/10/2004
Time: 7:03:57 PM
User: Domain\dbserv
Computer: SQLSRV
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\srv1\sql$\datastore\db105.BAK'. Operating system error 64(The specified
network name is no longer available.)
I have recreated the backup device and still get the same results.
Any help would be great!
Hi,
Ensure that you start the MSSQL Server and SQL Agent service using a Domain
account which got
previlages to \\srv1\sql$\datastore\ folder , share.
As well as this error might come if your network is very slow. Check the
network by issuing a ping <ipaddress> to the host machine.
If it gives request time out in between, then you have to contact your
network admin to rectify the issue.
Thanks
Hari
MCDBA
"jpfanc" <jpfanc_NOSPAM@.hotmail.com> wrote in message
news:eHj$F72NEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I have a created a backup device that maps to another server. When the
job
> runs that refences that backup device it is sucessful...for the first
cupple
> times that it is scheduled to run, but then it fails with the following
> message
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: Kernel
> Event ID: 17055
> Date: 5/10/2004
> Time: 7:03:57 PM
> User: Domain\dbserv
> Computer: SQLSRV
> Description:
> 18210 :
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\srv1\sql$\datastore\db105.BAK'. Operating system error 64(The specified
> network name is no longer available.)
> I have recreated the backup device and still get the same results.
> Any help would be great!
>

failure on backup device

I have a created a backup device that maps to another server. When the job
runs that refences that backup device it is sucessful...for the first cupple
times that it is scheduled to run, but then it fails with the following
message
Event Type: Error
Event Source: MSSQLServer
Event Category: Kernel
Event ID: 17055
Date: 5/10/2004
Time: 7:03:57 PM
User: Domain\dbserv
Computer: SQLSRV
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\srv1\sql$\datastore\db105.BAK'. Operating system error 64(The specified
network name is no longer available.)
I have recreated the backup device and still get the same results.
Any help would be great!Hi,
Ensure that you start the MSSQL Server and SQL Agent service using a Domain
account which got
previlages to \\srv1\sql$\datastore\ folder , share.
As well as this error might come if your network is very slow. Check the
network by issuing a ping <ipaddress> to the host machine.
If it gives request time out in between, then you have to contact your
network admin to rectify the issue.
Thanks
Hari
MCDBA
"jpfanc" <jpfanc_NOSPAM@.hotmail.com> wrote in message
news:eHj$F72NEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I have a created a backup device that maps to another server. When the
job
> runs that refences that backup device it is sucessful...for the first
cupple
> times that it is scheduled to run, but then it fails with the following
> message
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: Kernel
> Event ID: 17055
> Date: 5/10/2004
> Time: 7:03:57 PM
> User: Domain\dbserv
> Computer: SQLSRV
> Description:
> 18210 :
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\srv1\sql$\datastore\db105.BAK'. Operating system error 64(The specified
> network name is no longer available.)
> I have recreated the backup device and still get the same results.
> Any help would be great!
>

failure on backup device

I have a created a backup device that maps to another server. When the job
runs that refences that backup device it is sucessful...for the first cupple
times that it is scheduled to run, but then it fails with the following
message
Event Type: Error
Event Source: MSSQLServer
Event Category: Kernel
Event ID: 17055
Date: 5/10/2004
Time: 7:03:57 PM
User: Domain\dbserv
Computer: SQLSRV
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\srv1\sql$\datastore\db105.BAK'. Operating system error 64(The specified
network name is no longer available.)
I have recreated the backup device and still get the same results.
Any help would be great!Hi,
Ensure that you start the MSSQL Server and SQL Agent service using a Domain
account which got
previlages to \\srv1\sql$\datastore\ folder , share.
As well as this error might come if your network is very slow. Check the
network by issuing a ping <ipaddress> to the host machine.
If it gives request time out in between, then you have to contact your
network admin to rectify the issue.
Thanks
Hari
MCDBA
"jpfanc" <jpfanc_NOSPAM@.hotmail.com> wrote in message
news:eHj$F72NEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I have a created a backup device that maps to another server. When the
job
> runs that refences that backup device it is sucessful...for the first
cupple
> times that it is scheduled to run, but then it fails with the following
> message
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: Kernel
> Event ID: 17055
> Date: 5/10/2004
> Time: 7:03:57 PM
> User: Domain\dbserv
> Computer: SQLSRV
> Description:
> 18210 :
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\srv1\sql$\datastore\db105.BAK'. Operating system error 64(The specified
> network name is no longer available.)
> I have recreated the backup device and still get the same results.
> Any help would be great!
>

Fails to restore db

SQL2K, Win2K Advaced Server, Win2Kpro wkstation
I get the following message when I try to restore from a backup to any db on
my server.
In this case the backup is for the db tcaPlant_Grimes and I am trying to
restore it to tcaPlant_Hays.
I have done this successfully hundreds of times in the recent past.
Under the options tab I set ...
- Force restore over ON (b/c the db already exists)
- Restore As = full absolute pathname of the MDF
- Restore As = full absolute pathname of the LDF
I know the backup is good b/c I can create and restore using the same backup
on another server in the same network!
This has been happening for a week or so.
begin 666 clip_image002.jpg
M_]C_X `02D9)1@.`!`0$`8 !@.``#_VP!#``H'!P@.'!@.H(" @.+"@.H+#A@.0#@.T-
M#AT5%A$8(Q\E)"(?(B$F*S<O)BDT*2$B,$$Q-#D[/CX^)2Y$24,\2#<]/CO_
MVP!#`0H+"PX-#AP0$!P[*"(H.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[
M.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SO_P `1" ">`C\#`2(``A$!`Q$!_\0`
M'P```04!`0$!`0$```````````$"`P0%!@.<("0H+_\0`M1 ``@.$#`P($`P4%
M! 0```%]`0(#``01!1(A,4$&$U%A!R)Q%#*!D:$((T*QP152T? D,V)R@.@.D*
M%A<8&1HE)B<H*2HT-38W.#DZ0T1%1D=(24I35%565UA96F-D969G:&EJ<W1U
M=G=X>7J#A(6&AXB)BI*3E)66EYB9FJ*CI*6FIZBIJK*SM+6VM [BYNL+#Q,7&
MQ\C)RM+3U-76U]C9VN'BX^3EYN?HZ>KQ\O/T]?;W^/GZ_\0`'P$``P$!`0$!
M`0$!`0````````$"`P0%!@.<("0H+_\0`M1$``@.$"! 0#! <%! 0``0)W``$"
M`Q$$!2$Q!A)!40=A<1,B,H$(%$*1H;'!"2,S4O 58G+1"A8D-.$E\1<8&1HF
M)R@.I*C4V-S@.Y.D-$149'2$E*4U155E=865IC9&5F9VAI:G-T=79W>'EZ@.H.$
MA8:'B(F*DI.4E9:7F)F:HJ.DI::GJ*FJLK.TM;:WN+FZPL/$Q<;'R,G*TM/4
MU=;7V-G:XN/DY>;GZ.GJ\O/T]?;W^/GZ_]H`# ,!``(1`Q$`/P"_XX\<:KX:
MUR*PL8;-HFMHY"98=QR<YYS[5SW_``MCQ#_S[:;_`. __P!>NB\2VFC77C6Y
M_MR(-;#2H%63=M\EGD"!\^VZN<\/>%+6VU.]M->@.$\OV>X^S1AB!^[7/FGV.
M1M]<YKT*<:7(G*.IA)SYM&.'Q7\0'I;Z;_X#_P#UZ7_A:OB#_GWT[ _P'_P#K
MTFO^'88Y9]4U*YV6<%O;1C[';JKR2N@.8+MS@.<<ECUJC+X;TBV\.VNK3ZS/NO
M?/6VC2VR)'1L+D_P@.]\^M:J%%KX2&Y]S1_X6IX@._Y]]._P# ?_Z]*/BGK_\`
MS[Z=_P" _P#]>JC^#H$U"70EOI3KD-MYS1^6/(+!=QC#=<A>^,9I;_P6]GIM
MM<1F[F:XBB=;A8E-L6<X";@.=P/(Y(Q1R4.P7J=RW_P`+2U__`)]]._\``?\`
M^O2_\+2UW./(T[/IY'_UZI3>%+;S]0TVTOI9-4TV$RSH\86%]H_>!&ZY&1C/
M6NMLK'0IM0\/:,;>5K:\TL7#0F&/;*=K-N=_OALC/!QP.U3*-%+2(TYOJ8'_
M``M#7O\`GWT__P`!_P#Z]*/B?KW_`#[Z?_X#_P#UZYB%--?58DDGN(=/:0!Y
M74>8J=S@.<5UNIZ$BV\ZC1[%;>>2.*QNK&?S&B);"O+SRI'MUJ I4Z2:7*2I3?
M4C'Q.UW_`)]]/_\``?\`^O2_\+-UW_GAI_\`X#__`%ZADM]'M_%P\.-IRM:"
MX6V>?)^T;R<9#YP!N(XQTXIGBC0[?1=&TI$C3[49KJ*XF7/[W9)M!Y]J7)2N
MER[CYI]RU_PLO7/^>%A_X#__`%Z4?$K7/^>%A_WX_P#KU@.V6C7TRV]V;0M:-
M(NY]ZX*[@.#QG-='/8:9=>.+GPV--M[>$R-%;RP!E=7"Y4L23D=<C%#ITE]D2
ME-]1@.^).N?\`/"P_[\?_`%Z7_A9&M_\`/"P_[\?_`%Z;J'AVVNM*LAI42+J%
MND27J[N'#@.8EYZ+G()J^/#NB3:1IU_'"YMX;*YN+IE8J]P8V"C&>@.W<@.>E3R
MT?Y1WGW*8^(^M_\`/"P_[\?_`%Z7_A8VM=X+#_OQ_P#7K/M8+;6M)U.86D%I
M=6$(G4VX*HR9PP().3Z&G>&H8DMM6U62))GT^V#11NH*[G.T-SZ53ITK/W1<
MT^Y?'Q%UK_GA8_\`?C_Z]+_PL36O^>%C_P!^/_KU2O8+70M/TUFM(;NZOK?[
M3*TX+*%8G:% (P<=>U;-UHNFZ5H^H:C#9Q7"M%:3VJW67,:R9# X(R<@._I2<
M*2^R/FGW*@.^(>L_\\+'_`+\?_7IP^(6L_P#/&Q_[\?\`UZL:%HNG:FMIJ36D
M026.X26!R1&)44$,.>%]LU5?2H+_`$6)HXK!;Q[Z.$2:>Q:-%8 ?/R<<GBER
MTKVY0O/N/_X6!K'_`#QLO^_'_P!>E'C_`%C_`)XV7_?C_P"O5>\FT;2]<N=.
METM9K*W9XF<G]^6 (R&SC[W3CI53P];V5SJ)CO"C-L)MXI6V1S2=E9NPJO9T
M[7Y1<TKVN:@.\?:O_`,\;+_OQ_P#7IW_">ZO_`,\;+_OQ_P#7J 4:#'/>6MK?:
M?';.B2S32V;_`+J:-1]U3DX<'%4-.AM-=BO85M(K6:"W:XMWB! (7J'Y.3C&
M,=ZGDI?RCYI]RV/'FK_\\;+_`+\?_7I?^$[U;_GC9?\`?C_Z]4?%5G;6'B*>
MVM8A# JQD*O.,H"?YUK2:99I;&>UT^VOM,%OD312YNF..7QGC!ZC' %')2LG
MR[BYIWM<@._X3K5O^>-G_`-^/_KTH\<ZK_P`\;/\`[\U#J6G6`T_119QS"YO(
M020H(<[L$D YS]*M0^&H(6L[F<7 A:^2VEAF"9;/0C:>G8YYHY:-KV"\^XW_
M`(3C5?\`GC9_]^:7_A-]5_YY6?\`WYHD\/V]WJVJ?9/.2TL79710N\L6(54R
M<8XZDU5O='L[&>XBDU `K;+-`IQN=C_RS..,CVH4*+Z Y3[EL>-=4_YY6G_?
MFE'C35/^>5I_WYJCHUI!);ZA>SQB864(=86.%<DXYQS@.=:GO+>S6PTW5 /LH4
M76]);>-RJDJ<9!Y(SUQ0Z=*]N4.:=KW+'_"9ZG_SRM/^_-._X3+4_P#GE:?]
M^14EQHMG+XXDTU(_)M5 ?8A[! Q&?>FZ=I]IK]NLOV=+)DNTB/D9PR-SSGN,
M=:GEI6ORCO/:X@.\8ZE_SRM/^_(I?^$PU+_GE:?\`?D4MO96>KB^B2UCLS:2H
M$>+))4OLPV3SZYXJ1[&RN+K5=.2T2'[!$[Q3*278IP=V>#N_# %'+2_E"\^Y&
M/%^HG_EG:?\`?D4H\7:C_P`\K7_OR*@.NHTN?#=G?E%2:.9K9BH \P 9!/N.E
M90JU2IOH2YR74W?^$MU'_GE:_P#?D4[_`(2S4?\`GG:_]^16$*<*?L:?87M)
M=S<'BK4/^>=K_P!^12CQ3J'_`#SMO^_(K$%.%+V-/L'M)=S:'BB__P">=M_W
MZ%+_`,)/?_\`/.V_[]"L84X4>QI]@.]I+N;/_``DU_P#\\[;_`+]"E'B6^_YY
MVW_?H5CBE%'L:?8/:2[FQ_PDE]_SSM_^_0I?^$CO?^>=O_WZ%9 IPH]C3[![
M27<UO^$BO?\`GG;_`/?H4[_A(;S_`)YV_P#WZ%9 IXH]C3[![27<U?\`A(+S
M_GG;_P#?H4O]O7G]R#_OT*RQ2BE[*'8/:3[FH-=N_P"Y!_WZ%+_;EW_<@._[]
M"LP4X4>RAV#VD^YIC6[K^Y!_WZ%+_;5U_<@._[]"LT4X4>RAV#VD^YH_VS=?W
M(?\`OT*7^V+G^Y#_`-^A6>*<*7LH=@.]I/N7_`.U[G^Y#_P!^Q2C5KC^[#_W[
M%4!3A1[*'8/:3[E\:I<?W8?^_8I1J=Q_=A_[]BJ(IPH]E#L'M)]R[_:4_P#=
MB_[]BE&HS_W8O^_8JF*<*/90[![2?<MC4)O[L7_?L4X7\W]V+_OV*J"G"E[*
M'8/:3[EV&YFFDV#R5X)),8[?A4VZ3_GO;_\`?G_ZU5;+_7-_US;^5<=XFU*[
M\&:M_;,5R;RSU [9=.DD^8.!PT7H/45RUK0E9(Z*5Y1NV=WND_Y[V_\`WY_^
MM7'>,-4_M#PG,\1 C%R(\A N[:Q'Y9%6/!\-W<VSZ]?ZB+N?4@.&$<+YA@.0=%
M4>H[FL35?^1%E_Z_7_\`1C5FG=/0MJS6I1^*%ZUMXAFM@.BLMYIL$;D]5`?Q
M_P!\XKF=/\2W]EJ7V^5OM<HM&M%\X_=C*X &/0=*]>UWPIHVN7ZW6H6S2S+"
MB!A*R\ 9Z ^YK-_X5[X8_P"?"3_P(?\`QKKIXFE&"BT9RIR;NC@.;GQE<7S31
MWUA!<6<\42-;%V4!HQA9%8<AL<52U'7IM1TJPTYK:&".QDE>,Q9&?,;)&.P'
M:O3/^%?>&?\`GQD_[_O_`(T?\*^\,_\`/C)_W_?_`!JUBJ*V3_KYB]E-]3@.F
M\8W3R/>BS@.75I(/(?4@.Q\PC&"VW[H8K\NZHX/%$]II4UE9VJ6[W$:QR2K*Y
M"G/RH3M4Y'45Z%_PK_PU_P`^,G_?]_\`&C_A`/#7_/C)_P!_W_QI?6J/9_U\
MP]E/N<%/XLGE6ZFBL;>WU"]B$5S>QEMTB_Q84\*6XR1Z4Z+Q?>PZII.H16\*
MR:7:K:HO)$B $'/H2&/2N\_X0'PW_P`^4G_?]_\`&C_A`O#?_/E)_P!_W_QH
M^M4>S_KYA[*?<\QAOQ:ZK'?V=M'"(I Z0N3(HQV.[J*O3Z^#:W<&GZ=%IWVY
M]US)%(S-(,YV@.G[JYYP*]!_X0/PY_P`^4G_?]_\`&C_A!/#G_/D__?\`?_&F
M\72?1_U\Q>QF<EI?B&VNM2>_OUAM=76/-MJ#@.F$.!@."2,<<CC=Z\U5GU^.73
M[;3+_3X+];%I?+G6YD7>7;<QR.M=Q_P@.OAW_`)\G_P"_[_XT?\(-X=_Y\G_[
M_O\`XU/UFC>]G_7S'[*9Y>DB1WBW$<2KLD$BIG.,'(&>M;MQXJ:74;G4[;3H
M;6_N0PDG$K/PPP<*> <#J.E=I_P@._A[_`)\W_P"_S_XT?\(1X?\`^..._^_S_
M`.-4\72>Z?\`7S%[&://&U>[\T20R&!C:+:/L/WXPH!!SZXYJ];^*+ZUM=-@.
MMXXD&GI+&I(W"59#E@.P/%=M_PA/A_P#Y\W_[_-_C1_PA6@.?\^;_]_F_QI/%4
M7T8>RGW."DU<"PEL;&T2SM[@.@.S 2-(SD=/F;D#V[U:\/7MM%%J.G7DH@.AU"W
M\OSB/N.IW+GV)X)KM/\`A"M _P"..._\`O\W^-'_"%Z#_`,^C_P#?YO\`&AXJ
ME:UF'LIG#1ZQNLH+*_M([V*UR("9&0IDY/(^\/0'I5S_`(2JXGBOH]0M(KM+
MXQEP&+Y?W0NWH*Z[_A#-!_Y]'_`._S?XT?\(;H7_/H_P#W^;_&E]9I=G_7
MS#V4^YR-IXGGM+F%X[6+[/;PR0Q6^YL!7^]ENI/N:@.;6%CL)+/3[-+%)R#,Z
M2L[R`=%R>@.!YXKMO^$.T+_GT?_O\W^-'_"'Z'_SZ/_W^;_&CZS2[/^OF'LIG
M*)XE;[<=2ETZWEU J1Y[$[<D;<^7]TG%4M.U#[ \X:VBN8KB(Q21R<9!]".0
M?<5W/_"(:'_SZO\`]_6_QH_X1'1/^?5_^_K?XT?6J79_U\P]E,Y$:_<PM:"P
MBCLX;,EHH5RZECP6;/WB<]ZMQWUG)H]TEDT6G74W%RDC,PG3J/+/\)SU'?(K
MI/\`A$M$_P"?5_\`OZW^-'_")Z+_`,^K_P#?UO\`&D\32[,/93.5U+7(=6N9
M+N?2XUN9% \Q9WP"!@.';T["I'\0L9YKR"P@.M[Z>/8US&QRHP`2J]%) KI_\`
MA%-%_P"?5_\`OZW^-'_"*Z-_S[/_`-_6_P`:/K-+:S_KYA[*9R]OK\\"Z>RV
M\9FT[B"4D_<[J5Z'Z]:?_;YCM!;V=C%;`7:W>[>SDR#Z]JZ;_A%=&_Y]G_[^
MM_C2_P#"+:/_`,^S?]_6_P`:/K-+L_Z^8>RGW.9?7C)=7<C641@.ON;FW+L5=
MLY# ]5(/3%0Q:DD*W20V,"1W$/DA>24&<[@.3U/O76?\`"+Z/_P`^S?\`?UO\
M:/\`A&-(_P"?9O\`OZW^-'UFEV?]?,/93.2T_4)+!I0$6:&=-DT+_=D';IT(
M/.:FGU07!MHWM4%I; B.V5R!D]26ZDD\YKJ/^$9TG_GW;_OXW^-'_"-:3_S[
MM_W\;_&G]:I7O9A[&9S]UX@.FGUA=5A@.2WN1]\JQ97& ,$'M@.8I#K4L2*FGP)
M8*)?.(C8MN8=,D]AV%=%_P`(WI7_`#[M_P!_&_QH_P"$<TK_`)]V_P"_C4OK
M%+LP]E/N<_)K3^7*MI;1V;3N'E>)B2Q'( ST&><"GRZY)(MP\=M%#<72[9YT
M)RX[X'09[XK>_P"$=TO_`)]V_P"_C4O_``CVE_\`/!O^_AI?6*79A[*?<P;J
MZ@.CT&TTZ&02N9#<3$=$8C 4?AUK.%=?_`,(]IG_/!O\`OX:7_A'],_YX-_W\
M--8JFNXG1DSD13A76?V!IO\`SP;_`+[-']@.Z;_SP;_OLT_K=/S#V$CE13A74
M_P!A:=_SQ;_OLTO]AZ?_`,\6_P"^S1];AYA["1RXIPKIO[$T_P#YXM_WV:7^
MQ;#_`)XM_P!]FCZU#S#V$CFA2BND_L:P_P">+?\`?9I?['L?^>3?]]FCZU#S
M#V$CG!3A70_V18_\\C_WV:7^R++_`)Y'_OLTOK4/,/82.>%/%;W]DV7_`#R/
M_?9I?[*L_P#GF?\`OHT?6H>8O82,(4HK<_LNS_YYG_OHTO\`9 EI_SS/_`'T:
M/K4/,/82,04X5L_V;:?\\S_WT:7^SK7_`)YG_OHT?6H>8>PD8XIPK6_L ^U_Y
MYG_OHTOV"V_N'_OHT?6H>8>PD90IPK3^PV_]P_\`?1I?L5O_`'#_`-]&E]:@.
M'L)&8*<*T?L<']P_F:7[)!_</YT?68!["1GBG"KWV6'^Z?SI?LL/]T_G1]9A
MYA["12%.%6_LT7]T_G2_9XO[I_.CZS /82*HIPJQY$?]W]:7R8_3]:/K, ]A
M(BCN8+023W,R0Q+&V7<X`XKGX6\-)XAGUR?5X[JZ=0D(F8%;=<<A![^M=(8(
MF&&0,/0\TGV2W_YX1_\`?(KGJ3A-W-J<905CG=(?PUH=[>36.L)';W;!S:;_
M`-U$W=E],^E9&ILK^ W96#*UXQ!'0_.U=S]DM_\`GA'_`-\BN>\=1I'X98(H
M4>:G`J$XI.Q;4FU<ZJX_U@._W%_D*CJ2X_P!8/]Q?Y"HZR+"BL?Q!XDMM!C16
MC,]S*"4B!QQ_>)],\?G7#7'B[7KB0/\`V@.8,#&V!`H_7/-8U*\*;LSU<'E.*
MQD>>FK+NSU&BO-]-\;:M9RJ+N3[;!NRZN '(]FKO=+U.VU>Q2[M6RC<,IZHW
M=3[TZ=6-3X3+&Y;B,&U[5:/JMBW1116IYX445G3:Y:0SRPI%=7)@.8K.UO 76
M`CDASV..>] &C14?VB#S(X_/C$DJ[HT+@.,X]0.IIIN[595A-U )'.%0RKN8Y
MQP,Y//% $U%0_:[7SEA^U0>:_P!V/S5W-VX&<GH:?YT/G^1YT?G;=WE[QOQZ
MXZXH`?156ZU.RL[6ZN9KF/9:*6G"N"R8[$9X/M2PZC9W'F&&XC=(D#O*KJ4`
M.>I!XQCF@."S147VFW\D3??*8$B3S!M('4@.YQ56ZUJTMC;B-9KPW._RA9IY
MV=N-W0]LB@."_15>UOH+NT-U&Q2-2P?S!M,94X8-GH00<T\W5L+?[2;F$0?\`
M/7S!LZX^]G'6@."6BHY+FVA1'GN884?[KR2!5;Z$GFHM,ODU33H+Z)&1)UW* I
M()ZD=OI0!9HJA8:S;:A-(D0=55!+'(PPLT9)&]?;(/X8/<4B:YI\NFRZC'*S
MP1':VU"6)XP`.^001Z@.B@.#0HI@.G@.9F59XF95W,%<' ]3[>],^V6AA$WVN#RC
MDB3S5V\<'G..X_.@.":BHGNK:.(2O<PI&5W!VD 4CUSGIR.?<4KSPQ0^?)-&D
M6 ?,9P%YZ<GCF@."2BH+B^M;2!YIIXU5$+D;AD@.+NX'?CFJ]CK-O?2I$(+NW>
M1/,B%S"8_-48R5]<9&?J* +]%,6:%IV@.6:-ID&6C#@.LH]2.HZC\Z2.>"7?Y4
M\4GEG#['!V'T..G0]: )**H+K5B][-;I<1.D%K]IDG2161%R00<=",9^E-M]
M6-PQC^Q2QS/$9K:.1@.#<(,<C^Z>1D'IN'K0!HT5#9W<5]:K<0$E&)&&&"K D
M,I'J""#[BIJ "BBB@. HHHH **** "BBB@. HHHH **** "BBB@. HHHH ****
M"BBB@. HHHH **** "BBB@. HHHH **** "BBB@. HHHH *YOQ[_P`BRW_75*Z2
MN;\>_P#(LM_UU2FMP.HN/]8/]Q?Y"F 9('K3[C_6#_<7^0I@..&!]#2 \CU34
M#J&MSWDRLZ&8[8W;H@./W<^GTKMKKP]I7C72(;_PZL5I>0JL<MLQP,#CGW]#W
M_EP^HV+6.LW%E*^W9,1YCJ0"I.0V.N.:[M]7TGP!I$5KI)BU#4;I5DEF)RI7
MJ"<=L'@.>^3[^;"W-+VFW7_@.'W]>ZH8?ZI?GM[MMK65^;I;\;E'Q+::!X9\/_
M`-AI$MYJ<I#R39P8SZ^WLOXFL3P9J;V&NK 6Q#=+M<'H".0?KVK=\4C0_$FA
M_P#"26EPEI>J0D\#GF1L=/KCH>X'/3CEO#EO)<:Y"8P28R/Q)/3\N:J-_;KE
MV\NQSUN5Y34=6_/?7F_FTVZ6[6Z'J]%*>II*] ^(%4X8'K@.U@.:?IH=H=.OH
MKD312R>6ZPLXN@.6+!E*@.X/./F(Z>E;U4+C7=/M9GA:=V:,XE\F)Y!$?]LJ"%
MXYYQQ0!C74?[O4+:>VD;5[J5WLI3$6(!_P!41(.$V=QD8P>O> ,:6B>$M6D^P
MJ;YY;IP_E9D+>8V"IQGTQCZUU8<$#:X(89&#]X>HHW#=C<,^F>:8'*#3(X_!
MMW(M@.!>--*^X1?O<^>>0>HX]*@.73;PW#027]P-66:650EHH&XAMC&?&2G*]^
MPXXKL]PR?F&1UYZ4;P%^^-OUXHN!R\UO8WVA7EA9Z6_V];"2-PUOM(<KT9CP
MQ+#(.3TZBJJBVGUJ2[M;1O[,A2W^UHMJR!\++_ 5&_:Q0G /X]*ZN"]CN;FZ
MMU#[K1U1\]"64,,?@.14^_+8W@.GTSS0!R:6,=[XBLYTL\Z4\SO#&\15 XB(9]
MA'R@.G;U R1T]4DT^Z_X30K8L]A"N2LL=NK(N84R "-O)_45U4L\<,4LLL@."1
M*7<YZ #)-$,\=Q"DL4@.:-U#J0>Q&0: .7N;.\32TLG>6.2"[-Q?RI")%G1MQ
M+JAX(WX)3J,'@.\9C5(8;=%\R9[>>X>87DNG A7"JH2. # SSRP`X;N0:Z_..
M_3GK1O\`XMXP>^:+@.<?H"K96\<NN6DLR2)LM5EMC(4(D?<FT` A"?E/ICOBM#
M3[:Y;X?"UBADCN6LI42+&UPQW8'L>16S:WT=VUP(]P^SSF!R>[ `\>W(J<G'
M)./<T <UJ;SFPTO4]&C\]GMS:QE4RB"55PY'H'1 ?0$GM21Z5)9:Y9Z5;0.-
M.:6&\\W[WE-"N.6/]XK$,>FXUT%O;P6GF>3A%E<N5W?+D]<#MGKQWS4NX<_,
M..O/2@.#E[.V2Q\(`_P!GJ)+B5Q<,T1)13*WSLH^9@.,#Y1ZCMFLFU-G!XF2;4
MEDFM-\K0-)8%`_[J+D1(N,=>WUYKO]P^]N'US43V\4EW#=L"9H%=8VW'@.-C=
M_P"@.BBX'(9L+?Q';7-_;XL)$N'L8GMV?8I\D$^6 =H+;R 1W[=*?+9W*SI=R
M326FD>9*UNAM!.(MVW;F(@.[0</C@.XW#IGC=N]2TNVU19)))9+RWC:-A!&\IB
M5MK'>$!VYV@.C/I5JSU*WOC,T$F1#+Y6_(PYVJV5/<884`<Q8Z3'#8ZXWV::9
MQ8JL$MQ#B1@.8G/ [')Z#D<#VK1L[2]L;BPN[ZYDO8UMA#&PA"-;,X7.X+]Y3
MA1GJI'OQT!;!`)Y[#/-07MY'865Q=RY*6\32NJ\MM R<"@.#D]/M+BS>)IY+J
M\U.S2226V2S5/,<H0=TV/G4[LCD]1P.T$=M-+J*FU\VXLEMT-PL5E]G1T652
M\:C +G'][DCN>:[E7W(I!X(!`I2Q/4Y_&BX'&ZB;>YFU"XTVT:*V6PB+R+;F
M%7VW`9^"!G"@.YR.GK6]J;+-JNBK;X+&X:8;>/W(C8$_3+IQ[CTK4+ G#,#GL
M3UJE!I-E:I,L*NGFJ4+"4YC7^ZAS\@.&3@.#I0!3TJX5+R^*I(T5WJ#K"R+ E1M
MC4,3_=&Y''N?K6S3(8XK>%((%6.-% 5%Z "G%E'5@./J:0"T49&0"1D]!GDU#
M;7=O=JS02JX21HVQV93AA^8H`FHHR/6D!!Z$''7F@.!:*KK>Q-J+V(SYB0"<M
MQMVEBO7UR#5B@. HJO]NA_M%+$$F5X6F!&"H4,%/XY85."",@.@.CU!H 6BD!!&
M00<^AI<@.=2/SH **,CU'3/6DR,D9&1U&>E "T5%<74%K:S7,TJK%`A>1NNT`
M9/2GAT*A@.Z[3T.: '456?4+5)9X3)F2V"&1%4D@.-G;P.O0]*LY&[;D9],T %
M%)N7.-PSZ9I:`"BBB@.`HHHH`****`"BBB@.`HHHH`****`"BBB@.`HHHH` *YOQ
M[_R++?\`75*Z2N;\>_\`(LM_UU2FMP.HN/\`6#_<7^0J.I+C_6#_`'%_D*CI
M`8/B?PTNNQ+-#((KR%2J,W*N.NT^G/>O/;O3-0L9FAN;*977^ZNX?F.*]@.IK
MHDB[9$5QUPPR*PJ4(5'=GKX+.,3@.X\D+./9GD-MIMY=.%6%T4G!9AT_X#U-=
M_P"&?#O]E1^9.H\SJH/)!/5O8^U;R0Q1$F.)$)X)50*?54Z4*?PF6.S/$8VR
MJ/1=%L%%%%:GFBJ0&!/(S7)G4)]'TJ6S%W%::C%),W^DV[/]N8DE2AR,YX7/
M/3%=6!DX%4+77M+O+G[+:WZ22DD!0&&2.H!(P3P?RH YIK>>?5-VI7L-M?O<
MJ\,7V,O/Y>00L;AN%QD-@.<...G/-/M=,M[7PGH]Y:VBI?L]K^_P!N9?F=006/
M.,'&.F..E=EA@.,8/-&&W8P<T[@.>=7-HYTN8SWT;ZBENWVR&"S9)F8X!\V3<<
M@.'E>W3&.*Z+78=/M7M]-\BUMK?YI5>X@.,T;OG&T1@.C?(>N3SSQDFNCPV=N#D
M=J &P2 <=Z+@.<MX(:9].NWG,AD80EFD!!)\A?6JUKID%IX3T6\M+54U!FM09
M]O[WYF (+'G&#C!XQQTKLB#P2#STH(8'!!R:+@.<-9:<;F-XKBZAN-0-G,MW:
MQV165Y#&1B5RQW#=@.KQ@.G&,<4OV6U^Q6"Z'%`ANH5L+\0*%W, 0IVOZ' ER?U
MZ5V274<EY/9@.MYMNJ-(", !P2N/7H:1KVV%XEF;F/[2ZEEAW?.0,9./3D47
MY.TBO'M?M>IAFA2=+:\/_3"-&# @.=5$IR3W&>JTXVEI>ZW8QVT*OHCW!,2("
M(F<0R;\#^X?DR/NDY]Z[$ D\`FC#$XY)HN!RUC&+35;V>YC/]GQ:@.ZQ!1A;>
M3:@.#L.XQP#_#^.:M^*(YG-GOGAAL%9_M33P^;'G V;U!'&<]>,XSVK> 8G@.$
MD4 -DX!R/TI <?HFEVKZE/)(1>K%9*]O(T)2-<RS$;$)( `P%/8=.M.LK"VM
M/#>BR/ %LI(HWU-F!)<>5\ID[E0Q&0> .O%=<0<9.<>M5+O48[.:.$Q7$\T@.
M+".WCWL%! +'T ) S[TP.:CL[:]U^RCC@.$FBL\K6T>"(B1$-^!_<+8X^Z><"
MNIAN(9)IK>+(:V*JXVD`94$`>O&.E3D-GG//ZT$$<&D!@.6>I6FBRWMOJ<OV:
M9[J219I5(6X5CE=K?Q;5(4CMC'3%58=-L;V/7[VXL5DE\^1HC/%\T>(4(V@._
M=.?3N/:NCGNDM9;:*0NK74ACCP."P4MSZ<*:=<31VENUQ<.(HHQEG;H! _DTP
M.(@.@.GN9(6U/44ANI# UMNM&DN&CPA'EONXS\V[ SR<YJ>[%C_85['=QY\0?9
M9_/*J3+G8W)(ZQXQC^'ICM7:E7!*D,".HJ"UNX[R.1X"Q6&9X6R,8 93@._K1<
M#.T8&"62"\!-^ZAVF/29!P"OH%SC;V)[YR:NI17-O?RV%J=L6MG[^1^Z<#]Z
M0#US&,]NG')KH<'&<'%0/91M?1WKAC*D9C0$_* 2"2!Z\8SZ<4@..:NHK2 7U
MO/%C5 S+I0P3((P,0B,]@."/F_'=4%QJ$-GX8UG3KN4C49&NC]G52TC;B2& '
M8@.YSZ<UV9W+P<CVJM;:E;74GE0RGS-\J!"""3&P5\>P)'YTP,KPM8V\-E+=^
M0!<RW-P&E89;;YK8`)Z+QG X[U5_LNSN(/$5W<6:37"7,YB>1-Q3$2D%,].>
MX[_2NH(.,D''K5>^OK;3;<7%[,((MP4,P/)/0#'-`''0P3SW,+:CJ,<5Y(\+
MVP:T,EPT7RD>6^[@.'D-@.<9;.:>+73=/ANY;6VM[?5K&_EN<)&!*EOYIR1QR#
M&QP/<8[5U$>M6$T4,D%QYJ7$X@.0JI^^02 0<$< ]:O88`<'':BX'$6EEKH2>
MV(/VJSMGGA"L/EFE5>0>Y)^T<=LCVI=92PEL)%T!-L'E[;_RE*G[Z; W?S,Y
MY^]UR:[*XFCM+=Y[EQ%%&-SNW11ZU(VY3AL@.CUHN!R]_IRP>(7AM+7_08[%#
M<6T(P9E\U\@.'N>Y'5O7L=359)+G1!+8,SQNT;,8<AFAW#?M[Y V9Z<^E7TGBE
MEEACD#20D"11U0D9&?J.:6":.Z5G@.<2A79&*\X93AA^!&* .,G737UE&\/V\
M8M?LO^F/9Q;0\7G)O (`R=O8<\U:E$+S,^C*/[#_`'?VT6RXC;YCOV@.?[.-V
MW\:ZTDGKFEPQ.<'KC-%P.56YT6RU6QOK-H[?346='F12L =A'@.+VYVGIW![U
M71;;6-94M&\MI-K)/S*RK(HM.ONIQ]"*ZJRO8K^SBO+=F,4R[D+#!QTZ?A5>
M]UBWLKE8)$N)'(4N88BXB#'"ER.@.)!Y]C0!SVG6SP#3)K5&6ZFEOHRY)R0HD
M$:DGH@.*K@.=!BLR:SW:>WF7R27BQJMW#!:-'*6,D>...?<22#G:?RQ7?6MPE[9
MQ7<&XQ31K(I(P=I&1G\*2XNX[9K=92V;B98(P!G+D$CZ=#1<# F?$6C6L3RV>
MGZ=&HN=.N]\<,0_>NH39G'5@.2<9YR356_FT.6W%MIR:?%%'$70FU,JS2D8*Q
MQ@.@.&08&6ZC(`ZFNRMYH[JWCGMW$L,HW(Z]&'J*E^<DCDGO0!YW=0:>EC/<:A
M!%]NN[&Q:WEECS++( -Y4XSNZ9[UL +A4"C_`(2?[0"[8_>8\SDD]/+\O_@./
M3O6VVOZ7'...8M?HMPK[&0AN&]"<8!Y'?O5JVNH[SSA#N/D3-"X*XPZ]?YT <
MI::9:VWA/2[Z"T5;TRVV9]O[T!I5##<>0-I(QTQQTKJ[>YBNXS+"24#NG*D<
MJQ4]?<&I@.K'D`FHUFC>>2!7#2Q*K.@.ZJK9P3]=I_*D ^B@.D`$D@.`<DGM5*#6
M=-N;S['!>QR3Y("KG!QZ'&#^!H NT4TNJS)"21(ZEE7!Y QG^8I^T^A]: $H
MI<$C(!P*""!D@.X- "45'-/#;H'FD6-6=4!;NS'"C\20*DP2<#K0`44N#G&#G
MTJ&YN8[22WCFW*US+Y4?R]6VEN?3A30!+12@.$] 3]* I/0$_A0`E%-ED2")Y
M97"1QJ7=CT4`9)/X50L];M;VZ6U6*ZAF8,RK/"4W* IR/48=<4 :-%*01U!'
MUJ!KRU2[CM&N(Q<2@.E(=PWD`9)QZ8H FKF_'O_(LM_UU2NDKF_'O_(LM_P!=
M4IK<#J+C_6#_`'%_D*CJ2X_U@._W%_D*CI %%%% !1110`4444 .3_6+]17+Z
M!97VHZ':6]S/;#3O.9U6-6\X[96(&XG Y[@.9QQW-=-0``, `#T% '(Z?`D7A
MC3;IFDV7CJ-1G:1B?)^?C/\`"N=HX[$]N:<[Q)<&WM)1_P`(X9$$\B2$QJ2K
M[E#YSLW>5G!Q\QY'..KVKMV[1MQC&.*0(@.38$4)C&T*,?E3N! R=^MNS6UO8W
M5F-%Q(6-W(YMS*",*'5AQC)'.,Y[\4R(06TEE-=ZBNH2JL2J%9XYERQ :$'[
MR],C!.,\UUYCC,?EF-"G]S:-OY4I1"RL44LOW25&5^GI1<#C&=[6.[CTRY6Y
MOG3<UU"SEMGF*',Z9RKA22" .^!D4MM&D+%/M]E)I,LJ"[6Q9_*C7:_+.S'&
MYM@.;!X YP#FNR5%5F9456;EB``3]?6D$<:H46-%0]5"@.`_A1<# \.IIT>M:P
MNE>7]F"V^#&Q92VU\D$YS]1Q3]1N]/M_%^E"2XM8K@.Q3J^YU5SE4V@.]^>WZ5
MNJBH,(BJ/11BFM%$S;FBC9O[Q0$_G2 PM>%@.VO:9'JERL-JUO<%EDG\I)&!C
MP&Y&?7'M5&:XBDM_L$DD(L6N&:SEO)66!H55>"00S_,6VC/09Y YZ6;3X+B_
M@.O)1O>"-XU5@."I#E22<]_E'ZU.T<;*%:-&5>@.*@.@.?2F!QNB2VE]9P_\`"23(
MULL8^R"9V1'P[A\<@.EAA0 ?FQVK/M!<W.E0K<WUG:Q):K]A>\\S>#SEX]K#<
MX;'!R> ,5W%]IQO&C9+R:V*9!$04A@.?9@.<'_`&A@.^]3PVEO;P1010HL4(Q&N
M,[?IGO[T7 Y^Q^S0^(ANN5N[F:1QYB.PG3@.DK*AX\OC"G Z+US3/$%H7U\75
MI;^9?Q:7(\!&20ZRI@.@.9QD FNGV*'+[%WD8+8&3^-+@.9S@.9]>] '%ZT;.*R=
M= N6:"1,WKQ3%BOSIL9B3\KDD^A]173W-LVG:1=0Z3%B9(Y&@.0G=NDP<9SUR
M:MB.-00L: ,<D!0,GWIU(#C+B;0K._TJ\LR;B[5Y)+@.Q,TDQQ!(6W#LV>Q /
MY&L^[B2XAU*SC>UN8I-.,[):2O+F02IAG<DAG )R5P.3D=*]!$:*Q98T#$Y)
M"@.$GUH6..,82-$'HJ@.4[@.<9KL^DI:W,6DS621V4+R1,\[NK2$9!A56RS# RW
M(' (IEDUB=-OKE+M7UT7$S6R>?F42$_*`@./1B>>,')[5VHAA&,0QC;TP@.X^E
M`BB#[Q%&'_O!!G\Z+@.<=J5ZKZM#=13PP7'VV*W96=VNE&X*^U 0=J(><9'.<@.
M_,!30YM[.:#3+F.65O+-Q=PN[(T1;#M*N<I+ZXP<%L 8KM/+3>7\M-QZMM&3
M^-*J(N[:BKN.6PH&?KZT7 Q?#40ACNQ'>6<\)D79'9;C#%\O(#,3DGJ<'BJF
MLZ9HZ:]8S7L$$4#0W):21RB&0LC#)R!DDL?GTKI5147:BJBCLHP*'1)% VNB
MN.N&`(I <S87.G6MHM_<RRMK*P,UW%"Y,Q8+\RE.P';@.#A<$\9Q#)-'K5I;V
M%S8,7E@.E'DR22Q^;YF,R-GYFP3DKCKT%>@.A$#EPBAB,%@.!D_C2+%&@.`6-% Z
M84#%.X'-ZK!-9W5CJVH.LUS]LC5EM8VV[$CD( 4G+,>>OL!Q6#=2AK^"&WO(
M52\V/,;.X=Y,_0/,DSM+@.,WW<=3D<BO1,#@.XZ<CVIJQ1J,+$BC.>% YHN!
MR'B/2K2VCO+"SMBL,VF23-"C,V]TEC"MC/4`M^==-IL>FQVA726A:VWG!AD\
MQ<]^<GVJW@.9S@.9Z9Q5"YT:VN9?,\Z\@.XQLMKIX4_[Y4@.9]Z ,^&UO;CQ%K)M
M=4>S420!E6W23<?*'.6Z5A^;$=/DLKJ>W:2"XNY3)>%D24^:X&Q$(+/P>!TS
MT.X5VMI:QV<`AC>5P#G=-(9'/U8\FI#'&2"8T)4Y!*C@.^HHN!REI/J*:;:Q1
MN\LFN6L3),YSY4I11*QSU&SYL#&-I[FK$,=E8^(HD6X^T2>H\2M]H@.`7 5
ME)^:+ ^]CODDUNO91R7\-VQ8F"-DCCXVJ6QE@./7&1]":GV)OW[%WXQNP,X],
MT 01&TLC;Z?$$AW(QAA4?PKC=CZ;A^=<IX@.L[9=?O+P1[;A5L<2! B#\TKJ>_
M< "NN-K"UXMVRYF1#&I)X4$Y.!V)XR>^!Z5(54]5!^HI`<!9I=3V5M]IO[*S
M>."W%BTPD\Y8_+3YHE4X8D[@.>"?7M7>W%K;W95+B%9$5]RAOX3R,C\"?SI2B
M$J2BDI]T[1\OT]*=0!PVC6^DV^GZ;;RF&&W:%AJ2F8KME!'EK+SE!]_@.X&0/
M:K6KSZ<]I':VT\!AMX6EB:\ED*/DD 1!2&D88.",@. CKN!KK3%$=V8D._P"]
M\H^;Z^M!CC.W,:'9]W*CY?IZ4[@.<CX<35=4TJ\C-U;?9;J4?:&D1FF8M#%N(
MYVY.>X]ZB+6JK<Z;(T")'?7#@.WTKB)@."%"X4AI'XZ Y&<\YKM H4850![#%(
M8T;&Z-#@.Y&5!P?7ZT7 XWPO90:Y8W-UJGF7DJK#M\R1L*?(0D@.`C!/\`04_0
M8=/FU2WO]1,9O+FPLY(99I"K2RX;<5Y^8_=R![>M=@.%5>B@.?08J.>VBN(3$ Z
MX!& R':R?[I'*GZ47 JZ[%<3:%>QVV...X`ZD9!8?BN1^-8&MZVO]EM;Z6]
M@.UFUNZK:J&6YM0(G.XKGY-I&.@.QFMZWT6WMITF2[U%V0Y"RWTCJ?J"<&KWEQ
M[V?RTW-]YMHR?J>](#C]9MDTZR*6SRIYNC7<LCF5BSOB+YR<]?>C4[2.R&LF
M"6=38VL%Q!F9CMF8MND]V.T<_I78E5/50>,<CM054YRH.>N1UIW Y+44NIM=
MNC<WUE:2Q72BS\T2><L65P8U4X;=\P/!/K5O1/LD.LO%'.+J:59&:>*1MQPW
M2=#]UN>#@.9YXKHBBLP8HI9?NL1DCZ&HI[6*XADC.^/S?O/"QC<_\"'- &?XF
MD2'2HI976.-+VV+.YP%'G+R3VJ'4]0LKT6JQWL$VFF8K?/#,"JKM.P,RGY5+
M``_K5RWT6VMYA*+B^FQ_!/=R2H?JK$@.U=6&)%*K%&JM]X! `?KZT@..7WQ_:?
MLYE_XIKS=OF>8?+SLSMWYSLW^^/>K7AZWTV2]U062(]M;W<;V^&+*C>2`64D
M^[<C@.YK9N[07-KY"2O;X(*M$!QC_`&2,$>Q&*2QL8[&)E5FDDD.Z65P`TAQC
M)QP,#@.`<`=*8&7J?V*35VBUN1([!8%:V\R3RT:3+;SD$98#;@. >YQGFJ.B6 U
MG4[K^VDEN#'%!LCE=E&TM)M8@.$?,4"\]>3FNJ9$D&'17`.<,`>:7`R3CD]3Z
MT@..;0_;?AS.;DF;-E/DL>3MW[?RVC\JP#'/8ZG+#I ,3)!\H!9O+5H[8R,!G
M/0L>.?3FO0MHQMVC'ICB@.*H.0H!]0.:=P,+PS"D,MWY%[8SP$1[8K$NT<;...
MD[F)^8\9&>,#CFC5KO3[?Q1HWG7%K%/F8,7=5?!CPN<\X)Z5NHB1C:B*@.SG"
M@. 4UHHG;<\4;-ZL@.)I )#<0W'F>2X?RI&B?'\+KU'X5S_CW_`)%EO^NJ5T@.`
M'0`9YKF_'O\`R++?]=4IK<#J+C_6#_<7^0J.I+C_`%@._W%_D*CI %%%%`!11
M10`4444`%%%%`!1110`4444`%%%%`!1110`4444`%%%%`!111 0`4444`%%%%
M`!112,RHI9V"JHR23@.`4`+153^U]+_Z"EE_X$I_C1_:^E_\`04LO_ E/\: +
M=%5/[7TO_H*67_@.2G^-']KZ7_P!!2R_\"4_QH MT54_M?2_^@.I9?^!*?XT?V
MOI?_`$%++_P)3_&@."W153^U]+_Z"EE_X$I_C1_:^E_\`04LO_ E/\: +=%5/
M[7TO_H*67_@.2G^-']KZ7_P!!2R_\"4_QH MT54_M?2_^@.I9?^!*?XT#5=,8X
M&IV1)["Y3_&@."W1110`4444`%%%%`!1110`4444`%%%%`!111 0`4444`%%%%
M`!1110`4444`%%%%`!1110`4444`%<WX]_Y%EO\`KJE=)7-^/?\`D66_ZZI3
M6X'47'^L'^XO\A4=27'^L'^XO\A4=( HHHH`****`"BBB@.`HHHH`****`"BB
MB@.`HHHH`****`"BBB@.`HHHH`****`"BBB@.`HHHH`*S?$?/AC50?^?.7_`- -
M:59OB/\`Y%G5/^O.7_T`T 230C[<UO;6.G)''&C$R6H).3T&!CH#W/)'3N@.M
M+C S;:1GO_H@.]O\`Z_Z5.!_Q.+DXZPQ<XZ\MWQ_4_0=[%.X%#[)<8_X]M(S_
M`->@._P`^E!M+CG%MI'?&;0>^/_9?U]JOT47 HFTN.=MMI/?&;0>^/_9?U]J#
M:3YXMM)Q_P!>@._SZ?K3]6O3IVD7=ZJ;V@.B9PN>IK-N[:ZT6S74CJ5S=3PO&;
MI7/[NX4L`0J=(^O!7T[T`7Q:3Y&;;2?_1![?_7_`$H%I<<;K;2>V <6@.]L_^
MS?I[UD>'[ZXU>T@.M7N)H_LPWSR/E9+@.[SC:3_ ,8+#KC'KGI: * M+CC-MI'
M;.+0>V?_`&;]/>C[)<8_X]M(S_UZ"K]%%P*!M+C!Q;:1GMFT'O\`_6_6N8\>
M_+X=O+=[>R4CRVS#;JIP6;&3U_A'ISG\.VKB_B&?^)1>+GHD) QG_`&G[9_H/
MJ>PF#.THHHI %%%%`!1110`4444`%%%%`!1110`4444`%%%%`!1110`4444`
M%%%%`!1110`4444`%%%%`!7-^/?^19;_`*ZI725S?CW_`)%EO^NJ4UN!U%Q_
MK!_N+_(5'4EQ_K!_N+_(5'2 ****`"BBB@.`HHHH`****`"BBB@.`HHHH`****
M`"BBB@.`HHHH`****`"BBB@.`HHHH`****`"LWQ'_R+.J?]><O_H!K2JKJEHVH
M:3>62.J-<0/$K,,A2RD9/YT`!9(]8N6=E3,$0RV!G[W?']3]!WG\Z'_GM'_W
MV*Y6?1/&%S*TLVJZ,[-P<VK'CD8Y'3D_F:C/A[Q:>NIZ-_X"'_#W/YTP.N\Z
M'_GM'_WV*/.A/_+:/_OL?Y[C\ZY'_A'O%N<_VGHW_@.(?\*!X>\6C&-3T88Z8
MM#QT]O8?D/2BP'6M)!(A1I8F5A@.C>.0?_P!?ZUFV^CZ?;R6^+R66"T97M;>2
MX!CA(Z$=SC_ZUB#P[XL&,:EHPQTQ:'CI[>P_(>E'_".^+,8 _M+1O\`P$/^
M'M0!OQ:;8065K;1W&W[&2891*N]<DDC/H>01Z?3-7S/#S^^C'_ Q_GL?RKD?
M^$=\6'KJ6C?^`A_P]S^=!\/>+#G.IZ,<]<VAYZ^WN?S/K0!UWG0CK-'_`-]C
M_/8_E1YT/_/:/_OL5R)\/>+3G.IZ,<]<VAYZ^WN?S/K1_P`(]XMSG^T]&_\`
M`0_X46 Z[SH?^>T?_?8KC?B#*DFCWH217 2$X5LXRS^_]!]3VD'A[Q:,8U/1
MN/\`IT/M[>P_(5!?>$O%&HV#V,^JZ4('()6.!EY'`/ ]!B@.#N****0!1110`
M4444`%%%% !1110`4444`%%%% !1110`4444`%%%% !1110`4444`%%%% !1
M110`5S?CW_D66_ZZI725S?CW_D66_P"NJ4UN!U%Q_K!_N+_(5 '7(3?$JS:4E
M=/GP``,N,G Q3/\`A9%I_P! ^;_OL4687.RHKC?^%D6G_0/F_P"^Q1_PLBT_
MZ!\W_?8HLPN=E17&_P#"R+3_`*!\W_?8H_X61:?]`^;_`+[%%F%SLJ*XW_A9
M%I_T#YO^^Q1_PLBT_P"@...._WV*+,+G945QO_``LBT_Z!\W_?8H_X61:?] ^;
M_OL4687.RHKC?^%D6G_0/F_[[%'_``LBT_Z!\W_?8HLPN=E17&_\+(M/^@....
M_P!]BC_A9%I_T#YO^^Q19A<[*BN-_P"%D6G_`$#YO^^Q1_PLBT_Z!\W_`'V*
M+,+G945QO_"R+3_H'S?]]BC_`(61:?\`0/F_[[%%F%SLJ*XW_A9%I_T#YO\`
MOL4?\+(M/^@...._WV*+,+G945QO\`PLBT_P"@...._WV*/^%D6G_0/F_P"^Q19A
M<[*BN-_X61:?] ^;_OL4?\+(M/\`H'S?]]BBS"YV5%<;_P`+(M/^@...._WV*/
M^%D6G_0/F_[[%%F%SLJ*XW_A9%I_T#YO^^Q1_P`+(M/^@...._WV*+,+G945QO
M_"R+3_H'S?\`?8H_X61:?] ^;_OL4687.RHKC?\`A9%I_P! ^;_OL4?\+(M/
M^@...._P!]BBS"YV5%<;_PLBT_Z!\W_?8H_P"%D6G_`$#YO^^Q19A<[*BN-_X6
M1:?]`^;_`+[%'_"R+3_H'S?]]BBS"YV5%<;_`,+(M/\`H'S?]]BC_A9%I_T#
MYO\`OL4687.RHKC?^%D6G_0/F_[[%'_"R+3_`*!\W_?8HLPN=E17&_\`"R+3
M_H'S?]]BC_A9%I_T#YO^^Q19A<[*BN-_X61:?] ^;_OL4?\`"R+3_H'S?]]B
MBS"YV5%<;_PLBT_Z!\W_`'V*/^%D6G_0/F_[[%%F%SLJ*XW_`(61:?\`0/F_
M[[%'_"R+3_H'S?\`?8HLPN=E17&_\+(M/^@...._WV*/\`A9%I_P! ^;_OL468
M7.RHKC?^%D6G_0/F_P"^Q1_PLBT_Z!\W_?8HLPN=E17&_P#"R+3_`*!\W_?8
MH_X61:?]`^;_`+[%%F%SLJ*XW_A9%I_T#YO^^Q1_PLBT_P"@...._WV*+,+G94
M5QO_``LBT_Z!\W_?8H_X61:?] ^;_OL4687.RHKC?^%D6G_0/F_[[%'_``LB
MT_Z!\W_?8HLPN=E17&_\+(M/^@...._P!]BC_A9%I_T#YO^^Q19A<[*BN-_P"%
MD6G_`$#YO^^Q1_PLBT_Z!\W_`'V*+,+G945QO_"R+3_H'S?]]BC_`(61:?\`
M0/F_[[%%F%SLJ*XW_A9%I_T#YO\`OL4?\+(M/^@...._WV*+,+G945QO\`PLBT
M_P"@...._WV*/^%D6G_0/F_P"^Q19A<[*N;\>_\BRW_75*H_\`"R+3_H'S?]]B
8LOQ%XQM];TIK..TDB8NK!F8$<4)!<__9
`
end
Perhaps you could try the workaround suggested in
http://support.microsoft.com/default...;en-us;827452, although you
are not using Win2003.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Sydney Lotterby" <sydney@.infosearch.com> wrote in message
news:OPWp2wlpEHA.3300@.TK2MSFTNGP12.phx.gbl...
> SQL2K, Win2K Advaced Server, Win2Kpro wkstation
> --
> I get the following message when I try to restore from a backup to any db
on
> my server.
> In this case the backup is for the db tcaPlant_Grimes and I am trying to
> restore it to tcaPlant_Hays.
> I have done this successfully hundreds of times in the recent past.
> Under the options tab I set ...
> - Force restore over ON (b/c the db already exists)
> - Restore As = full absolute pathname of the MDF
> - Restore As = full absolute pathname of the LDF
> I know the backup is good b/c I can create and restore using the same
backup
> on another server in the same network!
> This has been happening for a week or so.
>
>
>