150bryant Posted February 6, 2013 Report Posted February 6, 2013 littlemoon emaina solution vachindaa? reply here
deals2buy Posted February 6, 2013 Report Posted February 6, 2013 [quote name='RockstarSwathiMuthyam' timestamp='1360182080' post='1303236458'] littlemoon emaina solution vachindaa? reply here [/quote] Bhayya nuvvu kuda SQL Server aa?
150bryant Posted February 6, 2013 Report Posted February 6, 2013 [quote name='Kaarthikeya' timestamp='1360182228' post='1303236473'] Bhayya nuvvu kuda SQL Server aa? [/quote] google searcher . not sql server
littlemoon Posted February 6, 2013 Author Report Posted February 6, 2013 [quote name='Kaarthikeya' timestamp='1360181928' post='1303236444'] Yes, mdf file ni backup chesi SSIS package dwara migrate cheyyochu... Also, data migrate cheyyadam veru.... roles manage cheyyadam veru...adi ela chestaro antha idea ledu I haven't worked on this so couldn't give you any code [/quote] SSIS ledhu ma dantlo [quote name='karna11' timestamp='1360181775' post='1303236421'] cheyyochuuu query evening isthaa, job schedule dwara cheyochuu [/quote] sure that would be helpful [size=4] [/size]
chelsea Posted February 6, 2013 Report Posted February 6, 2013 [url="http://support.microsoft.com/kb/246133"]http://support.microsoft.com/kb/246133[/url] may be helpfull for u
littlemoon Posted February 6, 2013 Author Report Posted February 6, 2013 [quote name='RockstarSwathiMuthyam' timestamp='1360182080' post='1303236458'] littlemoon emaina solution vachindaa? reply here [/quote] 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..
littlemoon Posted February 6, 2013 Author Report Posted February 6, 2013 SIDs ante idea undha lame lang lo kastha can any1 explain ? backup /restore apudu emaina change avthaya ivi?
chelsea Posted February 6, 2013 Report Posted February 6, 2013 @liitlemoon final ga if u find the solution please share it over here it may be useful for some on in the future
littlemoon Posted February 6, 2013 Author Report Posted February 6, 2013 [quote name='chelsea' timestamp='1360183628' post='1303236611'] @liitlemoon final ga if u find the solution please share it over here it may be useful for some on in the future [/quote] [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.. [b]will update the query once i am done working on it..[/b] [/quote]
littlemoon Posted February 6, 2013 Author Report Posted February 6, 2013 [quote name='GatisKandis' timestamp='1360179840' post='1303236255'] [img]http://www.desigifs.com/sites/default/files/CroppedBrahmishock_zps694518cc.gif?1350460826[/img] [/quote] [quote name='RockstarSwathiMuthyam' timestamp='1360179854' post='1303236256'] my office blocks any copyrighted material content and websites dbing thru phone now [/quote] mari block aye antha varku veyala.. thanks thou jamajacha
chelsea Posted February 6, 2013 Report Posted February 6, 2013 [quote name='littlemoon' timestamp='1360183721' post='1303236619'] [/quote] oh cool thanks
deals2buy Posted February 7, 2013 Report Posted February 7, 2013 [quote name='RockstarSwathiMuthyam' timestamp='1360182508' post='1303236498'] google searcher . not sql server [/quote] ,ari nenu eppudu adigina search chesi pettale? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] [quote name='littlemoon' timestamp='1360183012' post='1303236554'] SSIS ledhu ma dantlo [/quote] oh only database lu unnaya? aina ala ela install chestaru? mari mee daggara etl jobs undava? [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] can u elaborate a bit?
150bryant Posted February 7, 2013 Report Posted February 7, 2013 [quote name='littlemoon' timestamp='1360183784' post='1303236626'] mari block aye antha varku veyala.. thanks thou jamajacha [/quote] emchesthaam sometimes hav to do it...its a help thread
150bryant Posted February 7, 2013 Report Posted February 7, 2013 [quote name='Kaarthikeya' timestamp='1360203057' post='1303238245'] ,ari nenu eppudu adigina search chesi pettale? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] oh only database lu unnaya? aina ala ela install chestaru? mari mee daggara etl jobs undava? can u elaborate a bit? [/quote] 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
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts