deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='RockstarSwathiMuthyam' timestamp='1360212961' post='1303239374'] mama i never saw ur help asking thread. sql servers thread undhi...daantloki nen pedaga raanu endhukante i dont belong there.. eesari query gurinchi emaina veyyi...definitely i will be in yo [/quote] oorike annanu mama Any Help is GOD
littlemoon Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='littlemoon' timestamp='1360183361' post='1303236583'] yup for now I am copying .bak files manually to destination server and script rastuna inka something lik this step 1 take DB offline 2. restore data pointing on to the .bak file path 3. bring DB online 4. checking the permissions of all the users if anything is changed with this sp EXEC sp_change_users_login ‘ ’ 5. Altering the user permissions if anything is changed.. will update the query once i am done working on it.. [/quote] naku inko doubt ... nenu restore cheshtundi kotha DB server loki... so e DB's destination server lo create ayi levu... so new DB create chesi .bak file ni restore cheydame kada ? (kind of stupid q) but ma office lo evo cheppi confuse chesthunaru... [size=4] [/size]
littlemoon Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='RockstarSwathiMuthyam' timestamp='1360212903' post='1303239366'] emchesthaam sometimes hav to do it...its a help thread [/quote] [size=4] help thread aina manaki feasible avthene cheyali... [/size]
150bryant Posted February 7, 2013 Report Posted February 7, 2013 [quote name='littlemoon' timestamp='1360248176' post='1303240860'] [size=4] help thread aina manaki feasible avthene cheyali... [/size] [/quote] lesson learnt
deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='littlemoon' timestamp='1360248066' post='1303240846'] naku inko doubt ... nenu restore cheshtundi kotha DB server loki... so e DB's destination server lo create ayi levu... so new DB create chesi .bak file ni restore cheydame kada ? (kind of stupid q) but ma office lo evo cheppi confuse chesthunaru... [/quote] question ey confusing ga undi
littlemoon Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='Kaarthikeya' timestamp='1360248852' post='1303240920'] question ey confusing ga undi [/quote] source server - old destination server - new .. dinki migrate cheshtunamu annii DB's ni.. n indulo inka new DB's create cheyaledhu.. so induloki DB load cheyali ante 1st manam akada DB's ni create cheyali ani antunna , am i right? a tarvtha old server .bak files ni destination lo copy chesi restore chesthamu.. ila ne kada chesedhi?
deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='littlemoon' timestamp='1360249741' post='1303241006'] source server - old destination server - new .. dinki migrate cheshtunamu annii DB's ni.. n indulo inka new DB's create cheyaledhu.. so induloki DB load cheyali ante 1st manam akada DB's ni create cheyali ani antunna , am i right? a tarvtha old server .bak files ni destination lo copy chesi restore chesthamu.. ila ne kada chesedhi? [/quote] asalu DB migrate chesetappude DB create chesi bak file ni upload chestundi kadaa? I may be wrong but
gundugadu Posted February 7, 2013 Report Posted February 7, 2013 [quote name='littlemoon' timestamp='1360177927' post='1303236111'] will chk the link thank u ... kani detach enduku ? prod DB's ivi can't take them offline... n na degara backup files unayi.. asalu ardham kani point naku how to write a query to auto copy the .bak file from 1 server to another.. linked server emaina cheyala? [/quote] baaa u have to use batch file programming to copy files from one server to another server. [color=#000000][font=arial][size=1] D:[/size][/font][/color][color=#000000][font=arial][size=1] cd \pathto the .bak file in D drive\[/size][/font][/color][color=#000000][font=arial][size=1] xcopy \\servername\whr u want to copy the files /Y[/size][/font][/color]
deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='gundugadu' timestamp='1360250826' post='1303241123'] baaa u have to use batch file programming to copy files from one server to another server. [color=#000000][font=arial][size=1]D:[/size][/font][/color] [color=#000000][font=arial][size=1]cd \pathto the .bak file in D drive\[/size][/font][/color] [color=#000000][font=arial][size=1]xcopy \\servername\whr u want to copy the files /Y[/size][/font][/color] [/quote] Server upgrade chestunnarata...daaniki kuda ide vaadaala?
gundugadu Posted February 7, 2013 Report Posted February 7, 2013 [quote name='Kaarthikeya' timestamp='1360251090' post='1303241162'] Server upgrade chestunnarata...daaniki kuda ide vaadaala? [/quote] baaa up grade ki deeniki reation yemundi aaa script backup files ni automatica ga copy cheyadaniki from one server to another server
littlemoon Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='gundugadu' timestamp='1360250826' post='1303241123'] baaa u have to use batch file programming to copy files from one server to another server. [color=#000000][font=arial][size=1]D:[/size][/font][/color] [color=#000000][font=arial][size=1]cd \pathto the .bak file in D drive\[/size][/font][/color] [color=#000000][font=arial][size=1]xcopy \\servername\whr u want to copy the files /Y[/size][/font][/color] [/quote] file ni copy chesesanu... q is kotha DB create chesi anulo data load cheydam.. best method enti ani?
deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='gundugadu' timestamp='1360251250' post='1303241182'] baaa up grade ki deeniki reation yemundi aaa script backup files ni automatica ga copy cheyadaniki from one server to another server [/quote] server to server copy ki kaadu...vaallu 2005 nundi 2008 ki upgrading anta...so ela cheyali ani asking
gundugadu Posted February 7, 2013 Report Posted February 7, 2013 [quote name='Kaarthikeya' timestamp='1360251766' post='1303241243'] server to server copy ki kaadu...vaallu 2005 nundi 2008 ki upgrading anta...so ela cheyali ani asking [/quote] maaa company lo last yr end ki same database varaku 2005 to 2008 r2 ki migrate chesaru DBA's took care of al the restrores and all correct procedure theliyadu bayyaaaaaaa baaga urgent ante will chk with DBA's if they can provide that info. maaa dba gallu yemina question adigithe memekkado nerchukuntamo ani savalaksha questions vestharu yedavalu yenduku neeku ani
littlemoon Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='Kaarthikeya' timestamp='1360251766' post='1303241243'] server to server copy ki kaadu...vaallu 2005 nundi 2008 ki upgrading anta...so ela cheyali ani asking [/quote] server to server just .bak file ni copy chesthe em problem undadhu... all my worry is permissions and data loading proper ga avali [quote name='gundugadu' timestamp='1360252096' post='1303241287'] maaa company lo last yr end ki same database varaku 2005 to 2008 r2 ki migrate chesaru DBA's took care of al the restrores and all correct procedure theliyadu bayyaaaaaaa baaga urgent ante will chk with DBA's if they can provide that info. maaa dba gallu yemina question adigithe memekkado nerchukuntamo ani savalaksha questions vestharu yedavalu yenduku neeku ani [/quote] that's ok no worries... [size=4] [/size]
deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='gundugadu' timestamp='1360252096' post='1303241287'] maaa company lo last yr end ki same database varaku 2005 to 2008 r2 ki migrate chesaru DBA's took care of al the restrores and all correct procedure theliyadu bayyaaaaaaa baaga urgent ante will chk with DBA's if they can provide that info. maaa dba gallu yemina question adigithe memekkado nerchukuntamo ani savalaksha questions vestharu yedavalu yenduku neeku ani [/quote] desi gaaalla? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] [quote name='littlemoon' timestamp='1360252344' post='1303241320'] server to server just .bak file ni copy chesthe em problem undadhu... all my worry is permissions and data loading proper ga avali that's ok no worries... [/quote] permissions ninna iccham annaru kadaa? aina okasari test lo try cheste telistundi ga?
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts