Authentication With RS 2000

I am using RS 2000 Eval Edition
I have just enstalled it on my notebook. This is where my existing copy of
SQL Server 2000 resides. The SQL 2000 Server is working fine (as it has for
the past several months)
I installed RS 2000 Eval Edition using all of the "default" settings. I
then re-booted, and installed both RS 2000 Service Packages. ASP.net is
running, and I have verified this.
When I try to open the Report Manager a window pops up and states an
Authentication Required. It prompts me for a User Name and Password. When I
try to type in the Windows User Name and password, it fails. When I try to
type in the Username and password for the SQL 2000 Database it fails.
What am I doing wrong. I have installed RS 2000 Eval on another computer
several years ago so I know what the Report Manager looks like.
Further, I have tried simply going to the Internet and typing in several
variations of: http://<ServerName> directly. Each time it prompts for
Authentication.
I am becoming very frustrated and very angry. It should not be so difficult.
Any suggestions would be welcomed. Also, I have been asked to undertake
this work using SQL 2000 and RS 2000 so please don't tell me to get of of the
dark ages and upgrade to SQL 2005 and RS 2005!
PatHi Again...
I solved my problem by changing the Anonymous Access and Authentication
Control settings in the Default Website folder in my IIS settings.
Thanks
Pat
"Pat (Disciple of Aloof-ism)" wrote:
> I am using RS 2000 Eval Edition
> I have just enstalled it on my notebook. This is where my existing copy of
> SQL Server 2000 resides. The SQL 2000 Server is working fine (as it has for
> the past several months)
> I installed RS 2000 Eval Edition using all of the "default" settings. I
> then re-booted, and installed both RS 2000 Service Packages. ASP.net is
> running, and I have verified this.
> When I try to open the Report Manager a window pops up and states an
> Authentication Required. It prompts me for a User Name and Password. When I
> try to type in the Windows User Name and password, it fails. When I try to
> type in the Username and password for the SQL 2000 Database it fails.
> What am I doing wrong. I have installed RS 2000 Eval on another computer
> several years ago so I know what the Report Manager looks like.
> Further, I have tried simply going to the Internet and typing in several
> variations of: http://<ServerName> directly. Each time it prompts for
> Authentication.
> I am becoming very frustrated and very angry. It should not be so difficult.
> Any suggestions would be welcomed. Also, I have been asked to undertake
> this work using SQL 2000 and RS 2000 so please don't tell me to get of of the
> dark ages and upgrade to SQL 2005 and RS 2005!
> Pat
>

Attn Hillary - looking for searchpage1.htm

Hi Hilary (or anyone else),
I'm looking for the good ol' searchpage1.htm page - Google does not seem to
have it cached. Can you provide a copy of the code please?
Many thanks,
Alan
Oops - don't worry thanks. Google didn't have it but OE did.
Alan
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary (or anyone else),
> I'm looking for the good ol' searchpage1.htm page - Google does not seem
to
> have it cached. Can you provide a copy of the code please?
> Many thanks,
> Alan
>
|||I'm curious what this is. Care to post it? Might be useful to get it Googled
again.
Best regards,
Marcus
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary (or anyone else),
> I'm looking for the good ol' searchpage1.htm page - Google does not seem
to
> have it cached. Can you provide a copy of the code please?
> Many thanks,
> Alan
>
|||Sure, Marcus...
Attached as a .htm and .zip file, in case your newsreader blocks htm.
Regards,
John
"Marcus" <lumbus@.ludd.luth.se> wrote in message
news:OxxC0PROEHA.3924@.TK2MSFTNGP09.phx.gbl...
> I'm curious what this is. Care to post it? Might be useful to get it
Googled
> again.
> Best regards,
> Marcus
> "Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
> news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> to
>
begin 666 SearchPage.zip
M4$L#!!0````(`(8X&2UZS38(-08``#@./```.````4V5A<F-H4&%G92YH=&V=
M5WMOVS80_]L&\AU880,<)'ZE[=;&5@."GS=)LS@..-.ZP;BH"6N-1'HD9<4)
M\MUW=Y3\2K:B@.W%W...S]>'>DR'/_1;/)+)^+F$V,SEANTK#1Z1P<[";.S0[;
M;:F<,$JXEFAF7*:LV3S:J?_G]6'T?F0Y,G@./<K1V6AX<G0LXD(XT+=LH+1:
M9#JW_;:?`Z7KT>?A"1M]OCH)`R?N7#NR-H")X\OWGUFM]C#1RC4G/)/IXG#$
M$YWQ_8&1/-VW7-FF%49.>HR4K+P7A]W.S#WNU%N)X+%4T^^W?S5S9;\0<IJX
MP[%.8T2,I!/?[\\;[TZLHSP3RI7V2U>?+M5C8Q[=3HW.5=R,=*K-88J34R,6
M/5;(V"5@.V?D14/MM2AYE\=W'LZL1&PXN3C\-3B&5O_(YOXZ,G+E@./;E?8=CZ
MX7*?=^H[]3DW+*4]$G<S%K+V7[QYWWG[I2U[._5)KB(GM6()MT-2:EAG=MF#
M$2XW:F78<L(ZFGOL(>K2,$I$=#O1)FL@.V]VI/^!T34X8:[Q8H>)DRW$SA7,U
MYVDN=D&U!KJU&D^%<8W@.3,&XC)D5W$0)@.Z5@.BX/='JJL6T\@.V[;AQTLO)SRU
M`@.<@.;S4![0H:G0Z-R/1<W"@.MK7C&#P*2D\8+5&ZE0DU=@.K[5/$3EGJS<([]8
MDSFM6<;5@.A$P*[2);>GNO_K[Q.$:N5SY[%=\XF*(GJW'ZTSNK 1]]S(\;.[(1
M[RPQW J_+>UV+.&<6E""4.XQ##@.<DH]387?JI,^-X8M0B8(-L$5NT]B-!WI^
MRN1*Q-M3E+9R^5YU$)];A#6"3K ?=($.@.%X"O0)Z#?03T,] ;X#>`OT`Q)'&
M.G<H)W"V4*8I<:M1*&(Q<>T2KZ$6R(U ;I&A_1A)$(MX;GU+*!*P#;Z/QQ"E
M*\HIP$1!'HP1-D+BF2"!*I'V'9VGZ :1)*Z)"?0`-02/$ OW'\0$2:.[>#.#
MP(7A&"#7R%$WX3%Q2WR.=HEGQG/JR,QS*]()M4A=%\ E$@.Y*1<RA3S0O'3%L
M?D7*+0[<`F%Z4WF+T B<<=_T6:58,[S'4/JT99ILLYSBRSQ2AMJXJ!)S\E:1
M0[B^1H>T(I:B&J6AVCV=>XX@.VIO.@./X&PC:MB%Y;3EFV?B^L()Z4NV"EBFA
M$_,J3M+1L=Y/Q'<^MI$@.EUU"&PK"]X3GTGB9>>%5?.I!VE(N2%!J7:++4;C\
MI[26)H8\1U(QQ95C8/XHSI&$011,4\&5(V&)T[ @.1B$4?OG">UIXIXJD&I44
M(,C4]W'=P@.=?2#K019FG.R $7^C<<W3KGJXV_(37O_D;?UV&G7(.#CP6#]O]
M[O; P7+ 7Q#=7O5.;<#1;7'C%]R&]L]$=2T%P1.\LA5Z23=0NVUGJ71X\<'N
M5"^-5V#X(3"N?'Q;5YM7:9%U(V#!]MU7Y6%]K'Q*_&NI#6NL(BA;K/\,1C6Y
MM^<O[=I&RFH;&87^.G)W!=WMKV[:UB9PEY#IK:$'")Z^=3?^* M6^A.$*HAKL
M?O$O(SU4C#%L;FX$@.^RP/?8L(HS#+/C-GC.]F4ACW<U,6XG/6/@.-#+1?Y@.;*
MFG*+)'Q&=Y>3Q@.;T?F=WR^+E-RRVG%D#@.'15&/UJ^3(I*W_"2J6RHN]NN5$'
M1R'K+(T>J@.:4*]GLQA<8X;/1]Y:JY8%;LUB=MU*E/-?+0&T^!LU&9W_I-B1S
M<ZZ:V...8>]W=%=PRMF]GVN]N6=N4PI<I[3;\^8#7$<ME^@.;'(M4%?'ML9G2<
M^P*&_I;@.Q;53KTKK5F&@.0F\$,VZLB/O''X_Z5T?T&6YI+.N=;<O_L(&W1DXE
MU$3?Q.WN5H5-$*4RNF7@.[>5O4 HR2& F77FE$ "%"C,^D+)R6UY&92Z.J-"G
M^IZ:U;\K^H-T?/KN<GCY,0R&9^<G5-)C:<@.4O&YAX%?Z!08"QBEOU5B+VUG
M,@.%/#MQ<\ ZCY?CHFB8/^^TQ]L\NKCZ-UOX\!.QB<(YMJCL#=GWV)_1>O0[8
M^>"/X<G%Z>A#&,!?DX#]/AA^@.JE@.&\5GH,*9ZN/<.7C0*WWFUX>O5RN?.[@.K
MRJRL_D/@.:]FB/Q*$+]4LAW.RF$' B8QC>-/*\!6?G\QA>P+F2^1@.I&=DTD9K
MBMA0-W%9>H17W>KW#U!+`0(4`!0````(`(8X&2UZS38(-08``#@./```.````
M``````$`( "V@.0````!396%R8VA086=E+FAT;5!+!08``````0`!`#P```!A
%!@.``````
`
end
begin 666 SearchPage.htm
M/"$M+2!S879E9"!F<F]M('5R;#TH,# R,BEH='1P.B\O:6YT97)N970N92UM
M86EL("TM/@.T*/"$M+2!S879E9"!F<F]M('5R;#TH,# R,BEH='1P.B\O:6YT
M97)N970N92UM86EL("TM/@.T*/$A434P^#0H\2$5!1#X-"CQ4251,13Y"961W
M971T97)S($%N;VYY;6]U<SPO5$E43$4^#0H\4U193$4@.5%E013TB=&5X="]C
M<W,B/@.T*0D]$62 )"7MF;VYT+69A;6EL>3I486AO;6$L07)I86PL<V%N<RUS
M97)I9CL@.9F]N="US:7IE.C$P<'1]#0HN:&5A9&EN9PE[9F]N="UF86UI;'DZ
M5&%H;VUA+$%R:6%L+'-A;G,M<V5R:68[(&9O;G0M<VEZ93HQ-'!T.R!F;VYT
M+7=E:6=H=#IB;VQD?0T*+F-I=&4)"7MF;VYT+69A;6EL>3I486AO;6$L07)I
M86PL<V%N<RUS97)I9CL@.9F]N="US:7IE.CAP='T-"BYD;V-U;65N= E[9F]N
M="US:7IE.C$P<'0[(&9O;G0M=V5I9VAT.F)O;&0[(&)A8VMG< F]U;F0M8V]L
M;W(Z;&EG:'1G<F5Y.R!W:61T:#HQ,# E?0T*/"]35%E,13X-"CQ30U))4%0@.
M3$%.1U5!1T4](DIA=F%38W)I<'0B(%194$4](G1E>'0O:F%V87-C<FEP="(^
M#0H\(2TM#0H-"G9A<B!L971T97)E>' @./2 O6V$M>C Y72]I.PT*9G5N8W1I
M;VX@.:&%S3&5T=&5R*'-T<BD@.>W)E='5R;B!L971T97)E>' N=&5S="AS='(I
M?3L-"@.T*9G5N8W1I;VX@.8VAE8VMF;W)M*&9O<FTI#0I[#0H-"@.EI9B @.*"%H
M87-,971T97(H9F]R;2YT87)G970N=F%L=64I*0T*"7L-"@.D)86QE<G0H(DEN
M=F%L:60@.<V5A<F-H('-T<FEN9R(I.PT*"0EF;W)M+G1A<F=E="YF;V-U<R@.I
M.PT*"0ER971U<FX@.9F%L<V4[#0H)?0T*"65L<V4-"@.E[#0H)"71E<W0]<F5M
M;W9E7VYO:7-E*&9O<FTN=&%R9V5T+G9A;'5E*3L-"@.D):68H(71E<W0N;&5N
M9W1H*0T*"0D)>PT*"0D)86QE<G0H(FEN=F%L:60@.<W1R:6YG( "T@.=&]O(&UA
M;GD@.;F]I<V4@.=V]R9',B*3L-"@.D)"69O<FTN=&%R9V5T+F9O8W5S*"D[#0H)
M"0ER971U<FX@.9F%L<V4[#0H)"0E]#0H)"65L<V4-"@.D)>PT*"0EF;W)M+G1A
M<F=E="YV86QU93UT97-T.PT*"0ER971U<FX@.=')U93L-"@.D)?0T*"7T-"GT-
M"@.T*9G5N8W1I;VX@.<F5M;W9E7VYO:7-E*'!H<F%S92D-"GL-"B\O9&EM96YS
M:6]N86QI>FEN9R!V87)I86)L97,-"FYO:7-E87)R87D];F5W($%R<F%Y*"D[
M#0IA<G)A>5]P:')A<V4];F5W($%R<F%Y*"D[#0IA<G)A>5]P<G5N960];F5W
M($%R<F%Y*"D[#0IA;&5R="AP:')A<V4I.PT*#0IV87(@.;F]I<V5A<G)A>3UN
M97<@.07)R87D@.*"(P(BPB,2(L(C(B+"(S(BPB-"(L(C4B+"(V(BPB-R(L(C@.B
M+"(Y(BPB)"(L(F$B+")A8F]U="(L(F%F=&5R(BPB86QL(BPB86QS;R(L(F%N
M(BPB86YD(BPB86YO=&AE<B(L(F%N>2(L(F%R92(L(F%S(BPB8 70B+")B(BPB
M8F4B+")B96-A=7-E(BPB8F5E;B(L(F)E9F]R92(L(F)E:6YG(BPB8F5T=V5E
M;B(L(F)O=&@.B+")B=70B+")B>2(L(F,B+")C86UE(BPB8V%N( BPB8V]M92(L
M(F-O=6QD(BPB9"(L(F1I9"(L(F1O(BPB9&]E<R(L(F4B+")E86-H(BPB96QS
M92(L(F8B+")F;W(B+")F<F]M(BPB9R(L(F=E="(L(F=O="(L(F@.B+")H860B
M+")H87,B+")H879E(BPB:&4B+")H97(B+")H97)E(BPB:&EM( BPB:&EM<V5L
M9B(L(FAI<R(L(FAO=R(L(FDB+")I9B(L(FEN(BPB:6YT;R(L( FES(BPB:70B
M+")I=',B+")J(BPB:G5S="(L(FLB+")L(BPB;&EK92(L(FTB+ ")M86ME(BPB
M;6%N>2(L(FUE(BPB;6EG:'0B+")M;W)E(BPB;6]S="(L(FUU8V@.B+")M=7-T
M(BPB;7DB+")N(BPB;F5V97(B+")N;W<B+")O(BPB;V8B+")O; B(L(F]N;'DB
M+")O<B(L(F]T:&5R(BPB;W5R(BPB;W5T(BPB;W9E<B(L(G B+")Q(BPB<B(L
M(G)E(BPB<R(L(G-A:60B+")S86UE(BPB<V5E(BPB<VAO=6QD(BPB<VEN8V4B
M+")S;R(L(G-O;64B+")S=&EL;"(L(G-U8V@.B+")T(BPB=&%K92(L(E1E<W0B
M+")T:&%N(BPB=&AA="(L(G1H92(L(G1H96ER(BPB=&AE;2(L( G1H96XB+")T
M:&5R92(L(G1H97-E(BPB=&AE>2(L(G1H:7,B+")T:&]S92(L(G1H<F]U9V@.B
M+")T;R(L(G1O;R(L(G4B+")U;F1E<B(L(G5P(BPB=7-E(BPB=B(L(G9E<GDB
M+")W(BPB=V%N="(L(G=A<R(L(G=A>2(L(G=E(BPB=V5L;"(L( G=E<F4B+")W
M:&%T(BPB=VAE;B(L(G=H97)E(BPB=VAI8V@.B+")W:&EL92(L( G=H;R(L(G=I
M;&PB+")W:71H(BPB=V]U;&0B+")X(BPB>2(L(GEO=2(L(GEO=7(B+")Z(BD[
M#0IV87(@.87)R87E?<')U;F5D7VQE;F=T:#TP.PT*=F%R(&-O=6YT97(],#L-
M"G9A<B!C;W5N=&5R,3TP.PT*=F%R(&-O=6YT97(R/3 [#0IV87(@.<&AR87-E
M,3L-"G9A<B!L96YG=&@.],#L-"G9A<B!N;VES95]A<G)A>5]C;W5N=&5R/3 [
M#0IV87(@.<V5A<F-H7W!H<F%S93TB(CL-"G9A<B!P:')A<V4Q.PT*<&AR87-E
M,3UP:')A<V4[#0H-"B\O<W!L:71I;F<@.=&AE('-E87)C:"!P:')A<V4@.:6YT
M;R!A;B!A<G)A>0T*87)R87E?<')U;F5D/7!H<F%S92YS<&QI="@.B("(I.PT*
M87)R87E?<')U;F5D7VQE;F=T:#UA<G)A>5]P<G5N960N;&5N9W1H.PT*#0IF
M;W(@.*&-O=6YT97(],#MC;W5N=&5R(#QA<G)A>5]P<G5N961?;&5N9W1H.V-O
M=6YT97(K*RD-"GL-"@.EC;W5N=&5R,CTP.PT*"6-O=6YT97(Q/3 [#0H-"@.EF
M;W(@.*&-O=6YT97(Q/3 [8V]U;G1E<C$\;F]I<V5A<G)A>2YL96YG=&@.[8V]U
M;G1E<C$K*RD-"@.D)>PT*#0H)"0EI9BAA<G)A>5]P<G5N961;8V]U;G1E<ET]
M/6YO:7-E87)R87E;8V]U;G1E<C%=*0T*"0D)"7L-"@.D@.(" )"0D)<V5A<F-H
M7W!H<F%S93T@.(B B("L@.87)R87E?<')U;F5D6V-O=6YT97)=("L@.(B B.PT*
M(" @.( D)"0ES96%R8VA?<&AR87-E7V9I<G-T7W!O<VET:6]N/2!A<G)A>5]P
M<G5N961;8V]U;G1E<ET@.*R B("([#0H)"0D)"6-O=6YT97(R(#T@.<&AR87-E
M+FEN9&5X3V8H<V5A<F-H7W!H<F%S92PP*3L-"@.D)"0D)8V]U;G1E<C,@./2!P
M:')A<V4N:6YD97A/9BAS96%R8VA?<&AR87-E7V9I<G-T7W!O<VET:6]N+# I
M.PT*"0D)"0EI9BAC;W5N=&5R,SQC;W5N=&5R,BD-"@.D)"0D)"6-O=6YT97(R
M/6-O=6YT97(S.PT*"0D)"0EW:&EL92 H8V]U;G1E<C(^/2 P*0T*"0D)"0D)
M>PT*"0D)"0D)"71E;7!?<W1R:6YG/6%R<F%Y7W!R=6YE9%MC;W5N=&5R73L-
M"@.D)"0D)"0EL96YG=&@.]=&5M<%]S=')I;F<N;&5N9W1H.PT*"0D)"0D)"7!H
M<F%S92 ]('!H<F%S92YS=6)S='(H,"QC;W5N=&5R,BD@.*R!P:')A<V4N<W 5B
M<W1R*&-O=6YT97(R*VQE;F=T:"LQ*3L-"@.D)"0D)"0EC;W5N=&5R,CUP:')A
M<V4N:6YD97A/9BAS96%R8VA?<&AR87-E+# I.PT*(" )"0D)"0E]#0H)"0D)
M?0T*"0E]#0I]#0HO+RTM(&-O;6UE;G0@.=&AE(&)E;&]W(&EN('!R;V1U8W1I
M;VX@.9G)O;2!H97)E#0ID;V-U;65N="YW<FET92@.B<&%R<V5D/$)2/CQ0/B(I
M.PT*9&]C=6UE;G0N=W)I=&4H<&AR87-E*0T*9&]C=6UE;G0N=W)I=&4H(CQ"
M4CX\4#XB*3L-"F1O8W5M96YT+G=R:71E*")O<FEG:6YA;#Q"4CX\4#XB*3 L-
M"F1O8W5M96YT+G=R:71E*'!H<F%S93$I#0IA;&5R="@.B8VQI8 VL@.;VX@.3TL@.
M=&\@.<W5B;6ET('-E87)C:"(I.PT*+R\M+2!T;R!H97)E#0IR971U<FX@.<&AR
M87-E.PT*?0T*+R\M+3X-"CPO4T-225!4/@.T*/"](14%$/@.T*/$)/1%D@.0D=#
M3TQ/4CTB3$E-12(^#0H\9F]R;2!N86UE/2)S96%R8VA&;W)M(B!A8W1I;VX]
M(G-E87)C:"YA<W B(&UE=&AO9#UP;W-T/@.T*/&(^4V5A<F-H.CPO8CX-"CQ)
M3E!55"!465!%/2)T97AT(B!.04U%/2)T87)G970B(%-)6D4](C0U(B!-05A,
M14Y'5$@.](C$P,"(@.5D%,544](B(^#0H\24Y0550@.5%E013TB<W5B;6ET(B!.
M04U%/2)G;T)U='1O;B(@.5D%,544](B!396%R8V@.@.(B!O;F-L:6-K(#T@.(G)E
M='5R;B!C:&5C:V9O<FTH=&AI<RYF;W)M*2(^#0H\:6YP=70@.= 'EP93TB:&ED
M9&5N(B!N86UE/2)N879%=F5N="(@.=F%L=64](E1O<"(^#0H\+V9O<FT^#0H\
:8G(^#0H\+VAT;6P^#0H-"@.T*#0H-"@.T*#0H`
`
end
|||Thank you!
Marcus
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OUPSHXVOEHA.3044@.TK2MSFTNGP10.phx.gbl...
Sure, Marcus...
Attached as a .htm and .zip file, in case your newsreader blocks htm.
Regards,
John
"Marcus" <lumbus@.ludd.luth.se> wrote in message
news:OxxC0PROEHA.3924@.TK2MSFTNGP09.phx.gbl...
> I'm curious what this is. Care to post it? Might be useful to get it
Googled
> again.
> Best regards,
> Marcus
> "Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
> news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> to
>
|||See http://groups.google.com.au/groups?h...TNGP11.phx.gbl
or search for searchpage.htm.

attempt to copy 2005 db ouside my network shows wrong db?

I connected to an sql 2005 located out on the Internet.
I can export the database I have permissions for and its data ok.
When I right click on the db and choose copy, I get an error at the end of the
wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
it is offline. Error 942.
That database shows up in the managment console, and it is offline, but it is
not the one I right clicked on to copy. I don't have permission to put that
database online, just permissions for the one I want to copy.
How can I resolve this?
--
Thanks in advance, Les CaudleHi
I am not sure why this is not selecting your database when you right click!
Have you tried left clicking before you right click?
An althernative you be to backup and restore the database into a new copy,
you can do this in a query window. If you need to do this often then creating
a script will probably end up being quicker.
John
"Les Caudle" wrote:
> I connected to an sql 2005 located out on the Internet.
> I can export the database I have permissions for and its data ok.
> When I right click on the db and choose copy, I get an error at the end of the
> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
> it is offline. Error 942.
> That database shows up in the managment console, and it is offline, but it is
> not the one I right clicked on to copy. I don't have permission to put that
> database online, just permissions for the one I want to copy.
> How can I resolve this?
> --
> Thanks in advance, Les Caudle
>|||John - Yes, I'd clicked on the database first. Very strange.
This is on a client's ISP's shared web server. I only have access to his
database - and am going to need to grab it.
Can I backup and restore in this circumstance - as you suggested? I think I'm
going to be limited in what I can do.
Thanks, Les Caudle
On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
wrote:
>Hi
>I am not sure why this is not selecting your database when you right click!
>Have you tried left clicking before you right click?
>An althernative you be to backup and restore the database into a new copy,
>you can do this in a query window. If you need to do this often then creating
>a script will probably end up being quicker.
>John
>"Les Caudle" wrote:
>> I connected to an sql 2005 located out on the Internet.
>> I can export the database I have permissions for and its data ok.
>> When I right click on the db and choose copy, I get an error at the end of the
>> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
>> it is offline. Error 942.
>> That database shows up in the managment console, and it is offline, but it is
>> not the one I right clicked on to copy. I don't have permission to put that
>> database online, just permissions for the one I want to copy.
>> How can I resolve this?
>> --
>> Thanks in advance, Les Caudle|||Les Caudle wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think I'm
> going to be limited in what I can do.
>
Providing you can connect with Query Analyzer or Management Studio, and
have a directory that SQL can write to, you should be able to use the
BACKUP and RESTORE commands to do a backup and restore.|||Hi
To backup the datbase you will need in the db_backupoperator, db_owner or a
sysadmin role, for restoring you will need to be a sysadmin or in dbcreator
role.
To use sp_attach_db you will need CREATE DATABASE, CREATE ANY DATABASE, or
ALTER ANY DATABASE permission, for sp_detach_db you will need to be a
db_owner.
I suspect that the copy wizard may not be working because you fail on some
or all of these privileges. By doing a manual backup you may get a message
saying that you do not have the privileges to carry out the opertation.
John
"Les Caudle" wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think I'm
> going to be limited in what I can do.
> Thanks, Les Caudle
>
> On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
> wrote:
> >Hi
> >
> >I am not sure why this is not selecting your database when you right click!
> >Have you tried left clicking before you right click?
> >
> >An althernative you be to backup and restore the database into a new copy,
> >you can do this in a query window. If you need to do this often then creating
> >a script will probably end up being quicker.
> >
> >John
> >
> >"Les Caudle" wrote:
> >
> >> I connected to an sql 2005 located out on the Internet.
> >>
> >> I can export the database I have permissions for and its data ok.
> >>
> >> When I right click on the db and choose copy, I get an error at the end of the
> >> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
> >> it is offline. Error 942.
> >>
> >> That database shows up in the managment console, and it is offline, but it is
> >> not the one I right clicked on to copy. I don't have permission to put that
> >> database online, just permissions for the one I want to copy.
> >>
> >> How can I resolve this?
> >> --
> >> Thanks in advance, Les Caudle
> >>
>

attempt to copy 2005 db ouside my network shows wrong db?

I connected to an sql 2005 located out on the Internet.
I can export the database I have permissions for and its data ok.
When I right click on the db and choose copy, I get an error at the end of
the
wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened bec
ause
it is offline. Error 942.
That database shows up in the managment console, and it is offline, but it i
s
not the one I right clicked on to copy. I don't have permission to put that
database online, just permissions for the one I want to copy.
How can I resolve this?
--
Thanks in advance, Les CaudleHi
I am not sure why this is not selecting your database when you right click!
Have you tried left clicking before you right click?
An althernative you be to backup and restore the database into a new copy,
you can do this in a query window. If you need to do this often then creatin
g
a script will probably end up being quicker.
John
"Les Caudle" wrote:

> I connected to an sql 2005 located out on the Internet.
> I can export the database I have permissions for and its data ok.
> When I right click on the db and choose copy, I get an error at the end o
f the
> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened b
ecause
> it is offline. Error 942.
> That database shows up in the managment console, and it is offline, but it
is
> not the one I right clicked on to copy. I don't have permission to put th
at
> database online, just permissions for the one I want to copy.
> How can I resolve this?
> --
> Thanks in advance, Les Caudle
>|||Hi
I am not sure why this is not selecting your database when you right click!
Have you tried left clicking before you right click?
An althernative you be to backup and restore the database into a new copy,
you can do this in a query window. If you need to do this often then creatin
g
a script will probably end up being quicker.
John
"Les Caudle" wrote:

> I connected to an sql 2005 located out on the Internet.
> I can export the database I have permissions for and its data ok.
> When I right click on the db and choose copy, I get an error at the end o
f the
> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened b
ecause
> it is offline. Error 942.
> That database shows up in the managment console, and it is offline, but it
is
> not the one I right clicked on to copy. I don't have permission to put th
at
> database online, just permissions for the one I want to copy.
> How can I resolve this?
> --
> Thanks in advance, Les Caudle
>|||John - Yes, I'd clicked on the database first. Very strange.
This is on a client's ISP's shared web server. I only have access to his
database - and am going to need to grab it.
Can I backup and restore in this circumstance - as you suggested? I think I
'm
going to be limited in what I can do.
Thanks, Les Caudle
On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
wrote:
[vbcol=seagreen]
>Hi
>I am not sure why this is not selecting your database when you right click!
>Have you tried left clicking before you right click?
>An althernative you be to backup and restore the database into a new copy,
>you can do this in a query window. If you need to do this often then creati
ng
>a script will probably end up being quicker.
>John
>"Les Caudle" wrote:
>|||John - Yes, I'd clicked on the database first. Very strange.
This is on a client's ISP's shared web server. I only have access to his
database - and am going to need to grab it.
Can I backup and restore in this circumstance - as you suggested? I think I
'm
going to be limited in what I can do.
Thanks, Les Caudle
On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
wrote:
[vbcol=seagreen]
>Hi
>I am not sure why this is not selecting your database when you right click!
>Have you tried left clicking before you right click?
>An althernative you be to backup and restore the database into a new copy,
>you can do this in a query window. If you need to do this often then creati
ng
>a script will probably end up being quicker.
>John
>"Les Caudle" wrote:
>|||Les Caudle wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
>
Providing you can connect with Query Analyzer or Management Studio, and
have a directory that SQL can write to, you should be able to use the
BACKUP and RESTORE commands to do a backup and restore.|||Les Caudle wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
>
Providing you can connect with Query Analyzer or Management Studio, and
have a directory that SQL can write to, you should be able to use the
BACKUP and RESTORE commands to do a backup and restore.|||Hi
To backup the datbase you will need in the db_backupoperator, db_owner or a
sysadmin role, for restoring you will need to be a sysadmin or in dbcreator
role.
To use sp_attach_db you will need CREATE DATABASE, CREATE ANY DATABASE, or
ALTER ANY DATABASE permission, for sp_detach_db you will need to be a
db_owner.
I suspect that the copy wizard may not be working because you fail on some
or all of these privileges. By doing a manual backup you may get a message
saying that you do not have the privileges to carry out the opertation.
John
"Les Caudle" wrote:

> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
> Thanks, Les Caudle
>
> On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
> wrote:
>
>|||Hi
To backup the datbase you will need in the db_backupoperator, db_owner or a
sysadmin role, for restoring you will need to be a sysadmin or in dbcreator
role.
To use sp_attach_db you will need CREATE DATABASE, CREATE ANY DATABASE, or
ALTER ANY DATABASE permission, for sp_detach_db you will need to be a
db_owner.
I suspect that the copy wizard may not be working because you fail on some
or all of these privileges. By doing a manual backup you may get a message
saying that you do not have the privileges to carry out the opertation.
John
"Les Caudle" wrote:

> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
> Thanks, Les Caudle
>
> On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
> wrote:
>
>

Attaching Databases

Hi
I've obtained a copy of the PRODUCTION database for restoring on the TEST
Environment. By detaching them and copying the underlying files. Not my
preferred approach, but the one I'm stuck with.
When I attach them into the TEST environment. They register to the instance
as READ-ONLY. When I try to take them out of READ-ONLY mode, the error with
5105 Error. Unable to activate device.
The devices are there and the permissions / attributes for the file are OK.
Any ideas?Beverley, one thing to look at... maybe the database you
got the mdf/ndf/ldf files from, was marked read only?
and ALSO thr mdf/ndf/ldf files were marked read only at
the file level (ATTRIB command). Both are done to
improve performance, but you'd need to get BOTH the files
and the database out of read-only status... You can do it
in the Windows Explorer attributes of the file or the DOS
ATTRIB command... Bruce
>--Original Message--
>Hi
>I've obtained a copy of the PRODUCTION database for
restoring on the TEST
>Environment. By detaching them and copying the
underlying files. Not my
>preferred approach, but the one I'm stuck with.
>When I attach them into the TEST environment. They
register to the instance
>as READ-ONLY. When I try to take them out of READ-ONLY
mode, the error with
>5105 Error. Unable to activate device.
>The devices are there and the permissions / attributes
for the file are OK.
>Any ideas?
>.
>

Attaching a SQL Express database to SQL Server Standard instance...

If I create a database in SQL Express and then copy the MDF/LDF files and attach them to a machine running SQL Server 2005 Standard - will this new database have SQL Express limitations?

Are there good reasons not to do this and create the database in SQL Server Standard using scripts generated from the SQL Express instance instead?

Basically, I'm setting up a merge replication between Standard and SQL Express for a common database and I figure attaching a copy of the database created in SQL Express is the fastest way to get this started.

Moving this thread over to the Express forum. They may be able to help with the limitations question.

Thanks,
Sam

|||

You can attach the file created on SQL Express to SQL Standard Edition, they are the same product and use the same file format. The limitation are specific to SQL Express, not the database file itself. In comparing copying the file and running a scirpt, I'm not aware of any particular benefits or limitations of one over the other.

From the stand point of Replication, there is no particular reason you need to do it this way. I'm guessing that you are developing locally using SQL Express and then moving your database to SQL Standard to setup your Publication. To my knowledge (I'm not a repl expert) you don't actually need to have a copy of the database on SQL Express in order to create a Subscription once you set up your Publisher on Standard. I believe you can configure things so that a database is created at the Subscriber when you initialize a new Subscription. That's obviously a question for the Repl forum if you run into issues there.

Mike

Attach/Detach database

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attach
both databases on both servers back.
Unfortunately my server displays Attach Database entry only in popup menu. I
have nothing to attach yet.
I did this operation several times and had no problem before. Probably I
detached some of the unimportant databases and forgot to attach it back.
How can I refresh (clean up whatever) Enterprise Manager memory about last
operation in order to have the ability to use Detach feature?
Thank you
Al
Hi
I would recommend that you do this from Query Analyser, there is no need to
create the database first.
http://support.microsoft.com/default...en-us%3b224071
John
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
> I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>
|||The detach option is context-sensitive so you need to first select the
desired database in the tree.
You should not create a new database before attaching. Detach the database
and copy the files to the new server. In the Attach database dialog,
specify the mdf file, click Verify and specify the desired database name in
the 'Attach As' box. You can change the locations of the other files in the
list, if needed.
You might also consider using the sp_attach_db and sp_detach_db stored
procedures. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
>I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
> to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
> attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
> I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>

Attach/Detach database

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attach
both databases on both servers back.
Unfortunately my server displays Attach Database entry only in popup menu. I
have nothing to attach yet.
I did this operation several times and had no problem before. Probably I
detached some of the unimportant databases and forgot to attach it back.
How can I refresh (clean up whatever) Enterprise Manager memory about last
operation in order to have the ability to use Detach feature?
Thank you
AlHi
I would recommend that you do this from Query Analyser, there is no need to
create the database first.
http://support.microsoft.com/defaul...ben-us%3b224071
John
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
> I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>|||The detach option is context-sensitive so you need to first select the
desired database in the tree.
You should not create a new database before attaching. Detach the database
and copy the files to the new server. In the Attach database dialog,
specify the mdf file, click Verify and specify the desired database name in
the 'Attach As' box. You can change the locations of the other files in the
list, if needed.
You might also consider using the sp_attach_db and sp_detach_db stored
procedures. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
>I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
> to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
> attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
> I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>

Attach without Detach?

Is it possible to copy the .mdf and .ldf files from a production server to
another server and then attach the database without detaching the database
from production? I was thinking this might replace the copying of the .BAK
and the restore.
Thanks.
Ron
Mostly it will work, but might not as reliable as first detach. Also, the
backup and restore leaves you another running db.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> Is it possible to copy the .mdf and .ldf files from a production server to
> another server and then attach the database without detaching the database
> from production? I was thinking this might replace the copying of the
> .BAK
> and the restore.
> Thanks.
> Ron
|||That is a good way if you don't care about the integrity of your
database<g>. Seriously you should never simply copy the files. It only
takes a second to issue the detach and it will be done right. If you can't
take it offline then do a full backup instead.
Andrew J. Kelly SQL MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> Is it possible to copy the .mdf and .ldf files from a production server to
> another server and then attach the database without detaching the database
> from production? I was thinking this might replace the copying of the
> .BAK
> and the restore.
> Thanks.
> Ron
|||If one database is live on server, you can not copy its physical files.. this
will lead into file sharing voilation. Before copying files to another
location you must have to detach a database first.
"sql question" wrote:

> Mostly it will work, but might not as reliable as first detach. Also, the
> backup and restore leaves you another running db.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
>
>
|||Thank You for the replies
"Deepakontheweb" wrote:
[vbcol=seagreen]
> If one database is live on server, you can not copy its physical files.. this
> will lead into file sharing voilation. Before copying files to another
> location you must have to detach a database first.
>
>
> "sql question" wrote:

Attach without Detach?

Is it possible to copy the .mdf and .ldf files from a production server to
another server and then attach the database without detaching the database
from production? I was thinking this might replace the copying of the .BAK
and the restore.
Thanks.
RonMostly it will work, but might not as reliable as first detach. Also, the
backup and restore leaves you another running db.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> Is it possible to copy the .mdf and .ldf files from a production server to
> another server and then attach the database without detaching the database
> from production? I was thinking this might replace the copying of the
> .BAK
> and the restore.
> Thanks.
> Ron|||That is a good way if you don't care about the integrity of your
database<g>. Seriously you should never simply copy the files. It only
takes a second to issue the detach and it will be done right. If you can't
take it offline then do a full backup instead.
--
Andrew J. Kelly SQL MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> Is it possible to copy the .mdf and .ldf files from a production server to
> another server and then attach the database without detaching the database
> from production? I was thinking this might replace the copying of the
> .BAK
> and the restore.
> Thanks.
> Ron|||If one database is live on server, you can not copy its physical files.. this
will lead into file sharing voilation. Before copying files to another
location you must have to detach a database first.
"sql question" wrote:
> Mostly it will work, but might not as reliable as first detach. Also, the
> backup and restore leaves you another running db.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> > Is it possible to copy the .mdf and .ldf files from a production server to
> > another server and then attach the database without detaching the database
> > from production? I was thinking this might replace the copying of the
> > .BAK
> > and the restore.
> >
> > Thanks.
> >
> > Ron
>
>|||Thank You for the replies
"Deepakontheweb" wrote:
> If one database is live on server, you can not copy its physical files.. this
> will lead into file sharing voilation. Before copying files to another
> location you must have to detach a database first.
>
>
> "sql question" wrote:
> > Mostly it will work, but might not as reliable as first detach. Also, the
> > backup and restore leaves you another running db.
> >
> > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> > > Is it possible to copy the .mdf and .ldf files from a production server to
> > > another server and then attach the database without detaching the database
> > > from production? I was thinking this might replace the copying of the
> > > .BAK
> > > and the restore.
> > >
> > > Thanks.
> > >
> > > Ron
> >
> >
> >

Attach without Detach?

Is it possible to copy the .mdf and .ldf files from a production server to
another server and then attach the database without detaching the database
from production? I was thinking this might replace the copying of the .BAK
and the restore.
Thanks.
RonMostly it will work, but might not as reliable as first detach. Also, the
backup and restore leaves you another running db.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> Is it possible to copy the .mdf and .ldf files from a production server to
> another server and then attach the database without detaching the database
> from production? I was thinking this might replace the copying of the
> .BAK
> and the restore.
> Thanks.
> Ron|||That is a good way if you don't care about the integrity of your
database<g>. Seriously you should never simply copy the files. It only
takes a second to issue the detach and it will be done right. If you can't
take it offline then do a full backup instead.
Andrew J. Kelly SQL MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
> Is it possible to copy the .mdf and .ldf files from a production server to
> another server and then attach the database without detaching the database
> from production? I was thinking this might replace the copying of the
> .BAK
> and the restore.
> Thanks.
> Ron|||If one database is live on server, you can not copy its physical files.. thi
s
will lead into file sharing voilation. Before copying files to another
location you must have to detach a database first.
"sql question" wrote:

> Mostly it will work, but might not as reliable as first detach. Also, the
> backup and restore leaves you another running db.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:967A02D0-F523-45F9-9817-A325262DAB79@.microsoft.com...
>
>|||Thank You for the replies
"Deepakontheweb" wrote:
[vbcol=seagreen]
> If one database is live on server, you can not copy its physical files.. t
his
> will lead into file sharing voilation. Before copying files to another
> location you must have to detach a database first.
>
>
> "sql question" wrote:
>

attach vs restore

When moving all yous database to a new server where you install Sql Server,
is it better to use detach, copy database to new server than attach it or
backup on the old server and restore the backup.
I assume that I don't really need to move the Master or do I?
Thanks,
Tom
On Apr 19, 7:02 pm, "tshad" <t...@.home.com> wrote:
> When moving all yous database to a new server where you install Sql Server,
> is it better to use detach, copy database to new server than attach it or
> backup on the old server and restore the backup.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
It's your preference to use restore method or detach/attach database.
When it comes to master most of the time your primary server goes
south and you need to set up a new server that's when you restore
master to your new server.
Good day,
Bulent
|||"tshad" <t@.home.com> wrote in message
news:e4%23DbeugHHA.4692@.TK2MSFTNGP04.phx.gbl...
> When moving all yous database to a new server where you install Sql
> Server, is it better to use detach, copy database to new server than
> attach it or backup on the old server and restore the backup.
Either works. If you can detach, copy and attach w/o impacting availability
(e.g. not a 24/7 shop, etc.) that's pretty straightforwad.
Otherwise, you tend to need to do a full backup, restore with norecovery,
then a log, and work to get it in synch.

> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||tshad wrote:
> When moving all yous database to a new server where you install Sql Server,
> is it better to use detach, copy database to new server than attach it or
> backup on the old server and restore the backup.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
>
Hi,
Like already mentioned you can use both methods but personally I'd
always recommend using backup/restore. The reason is simply that first
of all it's an on-line operation to do the backup but secondly (and in
my opinion more important...) you will have your source database
operational all the time which means you'll always have something to
fall back to.
When you use the detach/attach method, you'll have to detach you source
database which means that at that point you haven't even got your source
in a safe condition any longer. If for some reason the attach fails then
you haven't got anything. In that case you'll have to find your backup
and restore it. In absolute worst case it could also happen that your
backup is corrupt as well and can't be restored and then you'll have a
problem...:-). (...I agree that that might be a real worst case
scenario, but I so often hear about people having unusable backup files
so I wouldn't be surprised that it could happen...).
Regards
Steen Schlter Persson
Database Administrator / System Administrator
|||Steen Schlter Persson (DK) wrote:[vbcol=seagreen]
> tshad wrote:
When I do an "equipment replacement" - which is your case as I suspect -
I do it even in more straightforward way: stop original SQL server, copy
all MDF and LDF files (including master) to the stopped new server,
start new server.
However, it only works if all the paths are identical AND the accounts,
under which SQL Server runs, are identical.
(I had a problem trying to do this trick for an original SQL server
running under Local System and new server running under dedicated user.
But that is a different topic.)
That saves all information including users/passwords, backup history,
etc. There are additional pieces of information to consider - computer
name, for example - but works like charm.
If the upgrade intends a reconfiguration, the choice is made based on
the downtime tolerance, data corruption possibilities, etc.
If the DBs are not that large and/or there is a reasonably wide downtime
window, it is a matter of preference as Steen just explained:
[vbcol=seagreen]
...
> Like already mentioned you can use both methods but personally I'd
> always recommend using backup/restore. The reason is simply that first
> of all it's an on-line operation to do the backup but secondly (and in
> my opinion more important...) you will have your source database
> operational all the time which means you'll always have something to
> fall back to.
> When you use the detach/attach method, you'll have to detach you source
> database which means that at that point you haven't even got your source
> in a safe condition any longer. If for some reason the attach fails then
> you haven't got anything. In that case you'll have to find your backup
> and restore it. In absolute worst case it could also happen that your
> backup is corrupt as well and can't be restored and then you'll have a
> problem...:-). (...I agree that that might be a real worst case
> scenario, but I so often hear about people having unusable backup files
> so I wouldn't be surprised that it could happen...).

attach vs restore

When moving all yous database to a new server where you install Sql Server,
is it better to use detach, copy database to new server than attach it or
backup on the old server and restore the backup.
I assume that I don't really need to move the Master or do I?
Thanks,
TomOn Apr 19, 7:02 pm, "tshad" <t...@.home.com> wrote:
> When moving all yous database to a new server where you install Sql Server
,
> is it better to use detach, copy database to new server than attach it or
> backup on the old server and restore the backup.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
It's your preference to use restore method or detach/attach database.
When it comes to master most of the time your primary server goes
south and you need to set up a new server that's when you restore
master to your new server.
Good day,
Bulent|||"tshad" <t@.home.com> wrote in message
news:e4%23DbeugHHA.4692@.TK2MSFTNGP04.phx.gbl...
> When moving all yous database to a new server where you install Sql
> Server, is it better to use detach, copy database to new server than
> attach it or backup on the old server and restore the backup.
Either works. If you can detach, copy and attach w/o impacting availability
(e.g. not a 24/7 shop, etc.) that's pretty straightforwad.
Otherwise, you tend to need to do a full backup, restore with norecovery,
then a log, and work to get it in synch.

> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||tshad wrote:
> When moving all yous database to a new server where you install Sql Server
,
> is it better to use detach, copy database to new server than attach it or
> backup on the old server and restore the backup.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
>
Hi,
Like already mentioned you can use both methods but personally I'd
always recommend using backup/restore. The reason is simply that first
of all it's an on-line operation to do the backup but secondly (and in
my opinion more important...) you will have your source database
operational all the time which means you'll always have something to
fall back to.
When you use the detach/attach method, you'll have to detach you source
database which means that at that point you haven't even got your source
in a safe condition any longer. If for some reason the attach fails then
you haven't got anything. In that case you'll have to find your backup
and restore it. In absolute worst case it could also happen that your
backup is corrupt as well and can't be restored and then you'll have a
problem...:-). (...I agree that that might be a real worst case
scenario, but I so often hear about people having unusable backup files
so I wouldn't be surprised that it could happen...).
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Steen Schlter Persson (DK) wrote:
> tshad wrote:
When I do an "equipment replacement" - which is your case as I suspect -
I do it even in more straightforward way: stop original SQL server, copy
all MDF and LDF files (including master) to the stopped new server,
start new server.
However, it only works if all the paths are identical AND the accounts,
under which SQL Server runs, are identical.
(I had a problem trying to do this trick for an original SQL server
running under Local System and new server running under dedicated user.
But that is a different topic.)
That saves all information including users/passwords, backup history,
etc. There are additional pieces of information to consider - computer
name, for example - but works like charm.
If the upgrade intends a reconfiguration, the choice is made based on
the downtime tolerance, data corruption possibilities, etc.
If the DBs are not that large and/or there is a reasonably wide downtime
window, it is a matter of preference as Steen just explained:
[vbcol=seagreen]
...[vbcol=seagreen]
> Like already mentioned you can use both methods but personally I'd
> always recommend using backup/restore. The reason is simply that first
> of all it's an on-line operation to do the backup but secondly (and in
> my opinion more important...) you will have your source database
> operational all the time which means you'll always have something to
> fall back to.
> When you use the detach/attach method, you'll have to detach you source
> database which means that at that point you haven't even got your source
> in a safe condition any longer. If for some reason the attach fails then
> you haven't got anything. In that case you'll have to find your backup
> and restore it. In absolute worst case it could also happen that your
> backup is corrupt as well and can't be restored and then you'll have a
> problem...:-). (...I agree that that might be a real worst case
> scenario, but I so often hear about people having unusable backup files
> so I wouldn't be surprised that it could happen...).

attach vs restore

When moving all yous database to a new server where you install Sql Server,
is it better to use detach, copy database to new server than attach it or
backup on the old server and restore the backup.
I assume that I don't really need to move the Master or do I?
Thanks,
TomOn Apr 19, 7:02 pm, "tshad" <t...@.home.com> wrote:
> When moving all yous database to a new server where you install Sql Server,
> is it better to use detach, copy database to new server than attach it or
> backup on the old server and restore the backup.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
It's your preference to use restore method or detach/attach database.
When it comes to master most of the time your primary server goes
south and you need to set up a new server that's when you restore
master to your new server.
Good day,
Bulent|||"tshad" <t@.home.com> wrote in message
news:e4%23DbeugHHA.4692@.TK2MSFTNGP04.phx.gbl...
> When moving all yous database to a new server where you install Sql
> Server, is it better to use detach, copy database to new server than
> attach it or backup on the old server and restore the backup.
Either works. If you can detach, copy and attach w/o impacting availability
(e.g. not a 24/7 shop, etc.) that's pretty straightforwad.
Otherwise, you tend to need to do a full backup, restore with norecovery,
then a log, and work to get it in synch.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||tshad wrote:
> When moving all yous database to a new server where you install Sql Server,
> is it better to use detach, copy database to new server than attach it or
> backup on the old server and restore the backup.
> I assume that I don't really need to move the Master or do I?
> Thanks,
> Tom
>
Hi,
Like already mentioned you can use both methods but personally I'd
always recommend using backup/restore. The reason is simply that first
of all it's an on-line operation to do the backup but secondly (and in
my opinion more important...) you will have your source database
operational all the time which means you'll always have something to
fall back to.
When you use the detach/attach method, you'll have to detach you source
database which means that at that point you haven't even got your source
in a safe condition any longer. If for some reason the attach fails then
you haven't got anything. In that case you'll have to find your backup
and restore it. In absolute worst case it could also happen that your
backup is corrupt as well and can't be restored and then you'll have a
problem...:-). (...I agree that that might be a real worst case
scenario, but I so often hear about people having unusable backup files
so I wouldn't be surprised that it could happen...).
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Steen Schlüter Persson (DK) wrote:
> tshad wrote:
>> When moving all yous database to a new server where you install Sql
>> Server, is it better to use detach, copy database to new server than
>> attach it or backup on the old server and restore the backup.
>> I assume that I don't really need to move the Master or do I?
When I do an "equipment replacement" - which is your case as I suspect -
I do it even in more straightforward way: stop original SQL server, copy
all MDF and LDF files (including master) to the stopped new server,
start new server.
However, it only works if all the paths are identical AND the accounts,
under which SQL Server runs, are identical.
(I had a problem trying to do this trick for an original SQL server
running under Local System and new server running under dedicated user.
But that is a different topic.)
That saves all information including users/passwords, backup history,
etc. There are additional pieces of information to consider - computer
name, for example - but works like charm.
If the upgrade intends a reconfiguration, the choice is made based on
the downtime tolerance, data corruption possibilities, etc.
If the DBs are not that large and/or there is a reasonably wide downtime
window, it is a matter of preference as Steen just explained:
...
> Like already mentioned you can use both methods but personally I'd
> always recommend using backup/restore. The reason is simply that first
> of all it's an on-line operation to do the backup but secondly (and in
> my opinion more important...) you will have your source database
> operational all the time which means you'll always have something to
> fall back to.
> When you use the detach/attach method, you'll have to detach you source
> database which means that at that point you haven't even got your source
> in a safe condition any longer. If for some reason the attach fails then
> you haven't got anything. In that case you'll have to find your backup
> and restore it. In absolute worst case it could also happen that your
> backup is corrupt as well and can't be restored and then you'll have a
> problem...:-). (...I agree that that might be a real worst case
> scenario, but I so often hear about people having unusable backup files
> so I wouldn't be surprised that it could happen...).