here's my situation. i want to take a copy of my database at work and take it home to my home pc. what/how is the best way to do this. i am relatively new to this stuff, so detailed directions would be nice.
sidebar - if i have the .mdf and .ldf files, can I restore from them?
Please, anyone out there can tell me if there is a special code that can reload data from the database and display in the application. Thank you.
View 10 Replies View RelatedI've had issues where backup up and restoring data from sqlserver2005 does not reattach the data to the correct users. Any tips on how to best accomplish full database moves where data is owned by different security users?
thanks,
SQL Nubie need to accomplish two things. 1. backup an SQL2000 db on old hardware. 2. Use backup to build same SQL2000 db onto new hardware, which will replace old hardware as main system. Running Win2000 server standard edition on old server and Win2003 server standard edition on new server. Old server does not have a tape backup, but it has a cd burner and access to a Novell corparate network -without any established Windows domains. Asking for much, hope someone can help. Some source material would go along way. Thanks
View 1 Replies View RelatedHi,
I have an existing sql server 2000 installation on one server. I now need to take one 2000 DB and restore it to a new sql server 2005 installation (on a different server).
What is the best way to do this. I can not upgrade the sql server 2000 installation to 2005. Basically i hoping all i need to do is backup the 2000 db and then restore it on the new sql 2005 server.
Is this possible...thanks for all help.
Ok. I dont know what I'm doing wrong but its not working...
I'm trying to move a "schema" (I guess thats the term) aka database from our webserver2 to our webserver3. I backup the .sql file, and move it over to webserver3. I tell it to restore that file and create the database if it does not exist. Part way thru i get all these errors like:
Error while executing this query:INSERT INTO `boats` (`id`,`date_modified`,`userid`,`category`,`city`,`state`,`zip`,`price`,`make`,`model`,`year`,`length`,`beam`,`draft`,`weight`,`hull_type`,`engine_make`,`engine_type`,`engine_year`,`engine_hours`,`horsepower`,`cruising_speed`,`max_speed`,`water`,`fuel_capacity`,`fuel_type`,`trailer`,`picture`,`pwd`,`confpwd`,`description`,`mileage`,`vin`,`photo`,`paypal`) VALUES
(41,'2007-08-10',83,'','chicago','','28443','83','46','157','1990',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'blue','','12345','12345','good','',NULL,'photo/new41.jpg','ok'),
(42,'2007-08-10',84,NULL,'hampstead',NULL,'28443','5516','2007',NULL,'2007',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'white','','12345','12345','good','',NULL,'photo/new42.jpg','ok'),
(44,'2007-08-10',86,NULL,'carolina beach',NULL,'28428','7144','2006',NULL,'2006',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bold','','12345','12345','nice','',NULL,'photo/new_69.jpg','ok'),
(45,'2007-08-10',87,NULL,'carolina beach',NULL,'28428','5468','2006',NULL,'2006',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'high','','12345','12345','good','',NULL,'photo/new_47.jpg','ok'),
(46,'2007-08-10',88,NULL,'hampstead',NULL,'28443','4574','1960',NULL,'1960',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'red','','12345','12345','nice','',NULL,'photo/m3.jpg','ok'),
(218,'2007-08-25',315,NULL,'carolina beach',NULL,'28428','5000','61',NULL,'2004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orange',0x2F396A2F3677416652564254415869633763454244514141414D4B6739302F7437414555414141414E7730674141482F34414151536B5A4A5267414241674541534142494141442F2F67416D51334A6C5958526C5A4342696553424A6257466E5A55646C595849734945466A5933565462325A3049454E76636E41752F384141455167416C674449417745694141495241514D5241662F62414951414277554642675545427759474267674942776B4C4577774C43676F4C4742455344684D634752346448426B624778386A4C535966495373694778736E4E6967724C7A417A4D7A4D654A6A67384E7A45374C54497A4D5145494341674C43677358444177584D534162494341784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445782F3851426F674141415155424151454241514541414141414141414141414543417751464267634943516F4C4541414341514D444167514442515545424141414158304241674D4142424546456945785151595455574548496E45554D6F47526F51676A5172484246564C523843517A596E4B4343516F574678675A4769556D4A7967704B6A51314E6A63344F547044524556475230684A536C4E5556565A5857466C615932526C5A6D646F6157707A6448563264336835656F4F456859614869496D4B6B704F556C5A61586D4A6D616F714F6B7061616E714B6D7173724F3074626133754C6D367773504578636248794D6E4B3074505531646258324E6E6134654C6A354F586D352B6A7036764879382F5431397666342B666F4241414D42415145424151454241514541414141414141414241674D454251594843416B4B437845414167454342415144424163464241514141514A3341414543417845454253457842684A425551646863524D694D6F454946454B526F62484243534D7A55764156596E4C524368596B4E4F456C3852635947526F6D4A7967704B6A55324E7A67354F6B4E4552555A4853456C4B55315256566C64595756706A5A47566D5A326870616E4E3064585A3365486C36676F4F456859614869496D4B6B704F556C5A61586D4A6D616F714F6B7061616E714B6D7173724F3074626133754C6D367773504578636248794D6E4B3074505531646258324E6E613475506B3565626E364F6E7138765030396662332B506E362F396F4144414D42414149524178454150774442314B4672534B346A47454D6A486275584F5152782F4C2B64632F6679504A4462523751436F5A38723333482F414F745855366F423574315A69614E774930436C6C7952782B6E6575643153336B686E743873475578674167636356346D446D727150384157786A4236324E52354748686A796D4B7645364D75437649353966773765745A476B594F6E716A7A6A4D552B315979446B37754D69744F362B304C6F634D6A495668325944464D666B63567A39755442654C4732347635736271796E376F50497A2B597052584E47662B496131544E305855554B5351684D4B4E7734474D486F4D2F6A53474B5347454E45374C6B446274474D47713051616656436B62686E44456B706E504A2F772F6E566D574B5779746E53627A53325163756E55594F514430726E6347746947554E46334C61584D736A68506D2F694872696F4E4A5A5974566E6B6C2F636951375136636875654F2F58696E61584A753070314C67504935354A775236484E4D732F4C67763268696D5679546B6E47346B35485054303936326E71356C50646C754B7A744A7464654F343142526E37724657355963447430727468612F77426B6162636D533469624A4C4B6B59336256793250544752584366326D747071625478796E7A576B4F36614E4143426E674156767242633349765A4C75534B525A464A474741494F346E6E302B6C5A31556E5A4D474A346275704C653076694A664C4C4F6D647647654772714E537637654735525669613357632F50634D443035794141446E3644394B35505162474B372B307779584561625A45594D7A415A47537642507577726F4E6268746F64536A6D6B6B6B4B4B506D336263456764416179786B5637642F3130484A616D64593667624F38387546766C456A6B35364E7867484272433043334D6A6D4B53557174764E4F414659416E42544F50774E5333636D57463562386B794D64754D6A42484934726D724B655239596D684F376235726E432F77353664666343744B64506D6737416C64476A4D49376E787A4648624F7353476359355041723048784A5A2F3266384D626C5A484C4F3845616A4B4873527A2F4D64613873567A42724D636A34796B68424863395258563637346E764C6E7732326D2F617A4A5A424542474D41386A2F43743638487A552F4B773274555731655350774A70346A7556457632527A68523930636E6B394F2F537339645346744249496F3971797A6A44444F43464141352F476864305068534646434D7068507A44746B482B672F6E56574B7952374D544D37724C457A626C32384C69524150304A2F4B75565257742B374A5A59756456617A5863717369737751726A424F616B4775334A7432587A6A764334392F774450547056472B757A4E71554C546F6F654E7A494F4D483775425546394F4A56447878474D456B5A7965542B4A34705169744C49686236467656376D5765384164574969596F464B67595066702B4E56644E6C4D65765173305162415A63482F64505036303279564A596F70475669356661632F686A386574545771702F62385362384A68736B44706B486E486576566776396B61665A6D6966756D7259464A74554C794E4B692F4D63675978674C786E742B565976694E4941305933537676354B734F6D6366343172366442356B36682F4D414B53726851636B6A625850654B6D2B53304C526C5A6D3550424879376942332F3261344B4E5039344B4B4F793043796B7472573164537958445738544A35612B5A6B4576686662702B7561337361782F7A7A7576384176312F3961714F6A544C70326B78626F354855327347516A456576636A6A72567A2B324C582F6E7A752F3841763650384B3471726935616737484D4E4D356E75704C6D4A4141676A4C644E707A31485074574A66334B5433694B6758596F326851434278375664765A6C61526F784676597148324836486B59724575484275466B68774E797177486F63563632437074506D613644676A6F6277655A6F634C49374F424868675239332F363348663172467569696178593745456362527075326E71527753542B424E573363514A4548336C476A33624D38456E417250314144374270632B3471784C4B53523036482B74464A622B6259524C6F4B52366B797445554C4541344F636A427750382B74507562346D4978467A67727643466A30326E743272506A382B4F664C7342356D4F56594864396364507052647A373778646F48796F5146417A2F65352F4C2B56516F624373566C6B6A69307945377A763345464150317A565054626F6A563047384972454B546A70795036306B75343236674D514D382F6B4B54546B32584B7A4953334F30726A725855344A4B544C61334E3261316542705A5976336A655A67684D2F507A6B394B3747333148544C2F77374E484C616D33756B514D72516F52356D4364705072794F7631724530614338677658614D4F6B5A66495534444E7765765074396130626932387A37536B596C51426436354A494947536553654F39636A6A6531794C6D4A48356E6C504E473061345A515152363170616E64532B5262753079794D72625644636A702B565557574F4747346B434D6362664C494A783148583871667137796947474E7742745A5371647345437178464F395335664C63696137337934387661462B3651534F4E76702B64594769794F6E69564E6A6C504D7A6E4236392B2F30726356496B335234447A69546A5A794343684858366971476C6147333972577A744B6A4656797968733839782F6A5470786A434C54374432526C69557A6167587A754C53737850726B6D7457385670644F55375176796A414847656C5A67673236696B496250377A4132392B6132746130323630375437644A5933696A6668643535786A76576C66346F7045793657466A6C613330654D4167417837655236352F6C7A5652723576732F7A76754C746B6E50754F663071764C6376396C6A515945635955446E725657642F4C3039564C4E6B484F3064674457436F3333376B63747936722B5A664E4950756C4F394E695A5450447944477A6A6A4F526A49714F7A387A4C53494358444149534D673865394B735478784B726B59425A7476546D726A543173556F4672514C777A6C464B68564570774232365670577053505867366F43565669426A5049553961783941696B674B6F7967457557776663442F41417251593431574E6C48504F51652F427275356255576C356A614C736338776C697545754E685A484738454C6E4A48627433715335314F57612B556E416B5350796C6B4B4239673748622F414A366D7338527358742F4F455A43722B58494F4B624C657A3664666F317649364932634665534F4F656672586C78692B637A767165695779794E6278517967777249696B4F6A454677454858327A6E734B6D2F73364C2F414A2B782B5A2F77724C385058627857397A4E766161534D46764D59634B5369663447726E2F4353586638417A33542F414C35726E635A583052716B635A71766C472B6A75625279366D79387473706768736E4E6336735A686D4B742F4352794B394338565745476E61564330385A6976343245653053467949385A47652B6331794F6E32446172666D4733674D7253483932706C43416454315046657454714B4B585962646830616D3552524845716B523741636B6B34354A344861733355354A66375068696B412B516A41486267442B574B39416774494C4F33686768676D6A6E4D5A456F444669523348474D6A4F61702B4A5042356E69682B77544962615350683262356C49783934644F3336394B6D4D71616C3877535851342B33457374724A6351786855556A4F51546C7341663071717A58416B4D6851716F424842396331314A30793830367A6974706D6E2F646A435A566741446E7032782F6A56654853487535476844713853344C6E4A41342F7A2F4F71307663646A6D686273557A7677724B50703077663556703646615246304557444A757A756B4F46423747756C7476446B77754331725A4C67426D2B5A43464F305A504A34786A465834764364364E4846355045496C6B3456414D67726E484E513671617633466134615662577476504C4A66796566506B37556A4A5166566A32486233726F66736D6B6A5437394A4A544865665A33784578336A6853515153506647426A39617361506F3131396D386F574C7870494D655A676745594A4236357A78322F576D2B4A4E44693850365064337A5863675A3479466A50385250476366513966576D71592F5A7663342F773548707A66615939526B6352694D4E487459594237486B656F2F57693654544C57346D45384C5453592B5546736269656A6339756C54664433543754577458754972316A464848446C53534F54754136477537314C3465615263776B7876497245677049427577754F63632B673471366B4C765570527673655153363271536C7261314B766E35586B47636667507871466E757269614B356C7553493058615274326C765849423936395062345A3250326B6266744B707379504D6641446568494761774E56384F7A5153537743316A5178714D53463976792B7750425048622F414271505A5757684C673761486D543343323270724D4633694F5548446678595065756975622B48554C5574637358326B79486167344A2F7030465659504338756F616B6265334F514357334F514141505830712F4A6F516578687434784C3568623934416D637432482B6665744B715767704A324D6B53327479465437492B56783877666875656D4D656C4E6C75624C3750695054795A4F636D5A3835392B4D656C62646E3459314454706C6C6B73324E744B47423349634D754D656E546D6F50384168487A634C4C4D3538714E4E71716F54312F483035724B33556D306A462B31677769474F44596E47634E786E474D2F5770374349537A624A496D6C44734F4648506638417846614A306C724A465752526D5163416A4F654B7336665A6D324C79754F5170786734427A782F576B35534A626B6862757A2B79585546756E6C41425364345A574C4539695236566E492B33564969506C4A4A475166556634565A75624E34626F5353534E47374A764B79444248474F66725765306A52616A4777636A6B386A4847636975794B2F64573868394E54585A3144714A453374477779707A7A6A31785657367445756F6A35647535326A41632F7738353471475738574F3642646544305544465478616E356B7A6A44496841423341633446656134754C756A42585271364A3539757857327574724D43726B664D434E7647516670304661754E512F7743667950384138424B356C64596C693342465544726D50414150546E3036667253663239632B736638416E386130684674477975783369472F64723047535A5A55474D43484F422F3841587A6D712B69512B66644E4A4735387956664C52486A777039526E50394B303762524138697145414A4F4D743272717258773163334F7743466F3467662B574F6366582F414361362F5A714B4F6852544949627A2B30726932746B73326A676550444F4D4656786E497A31727139483148527450736C736275315A3431503841793377325051446E706E386177376677584E504F2F77445A4E7970626B4E357370562F66436B5648642B444E643834573870574D5038716E7A4F4A50624A347A376436354C516C506B556C66743147364D6B7232304F3569314C773565325479537832303859344A636450664A3763396A33702F6D2B48375737534F4B4F3351737638414342304134786A70586E4678345031327969574F57797578437034434B5748346C654F7770715265646933654E49354662356D4D5A33455936486E6E36597258367331314A535851395374395230356F44746D7478626F666C4C4848413979656552304E536661374A596D6358556336796A616B5A5A51716B446F4232354665584732597743327476506E6C4C5A32726B6A3842566B46724B5046376152414E795330587A4438534B616F4A4F35615232657461394C614641706768774F515833456A2F4149446D764F2F456D765261776A4E4A466C6A6A42425041476663315631423764704D5770506C73666D586557724F5349486C773231656748792F6A58516F69624E667732316859415233494D685A7633685944414848355630726174625755554D567665794B6B6535684C67746E505041394230726A625A5A4A35465747476152323770796630726669384D61724F6971756833685A6A2F72486A5964716C795637584B696E625136534478776649434D30636A494D4231646C35776563455644346938515136746F55795370477864516F5A56334548363534366461353662524E57686A784C4530534435646A73467A56534F4B2F696947323949436B59676A632F6A6B356F63644E41615A466F45373230724C474970465A546C4E704C66686A722B64647A5A7753326D6E4E39713061414C494364717171734236486A2F774376584661643970572B43526F774F37646E4F334234505872586F7474346C73356257453677545A334D6D664C6D432F4C4E6A76676672584E4B7279564C536937573357714E3434666D7038385A4B3939683048694854567449314B5242472B58446B4D6575434350626E6973375574533039375466466257737162546C5734774F4F67417A557573365861616E617463324E7A4178584944787348543666374A727A3356457562465A4C5A3554357A72386F556256726F53556C6462474C54547330477158304C71545A32696C314A3273795A41555A357752576444716746755A5766793768506E4342763841395761574B53554D56775163416E59783535394B6A754949596E4A6A56643351676B7552307963397566536C374C735A4F4A6B366A6333562F4B397874564F4143726B676C656D526E697333355A376844475249674F5777324F2F2B65613668344D364F73543341534C4F34493447562F4C50485035316B506252466D58797A7558492B516665725658745A6B38686E54574567427549764D4A326E355376492B6E2B6330514B3637497058786E4756586A2B597256614F3561326A6549764867394163666A375531426C564D676A59344B377334352F727855323048625378516E79506C685A534D597A6E417A2B482B4656764C75503730582F66772F345630317262626D4B577A6F67326E63575861414F33622B6E657076374E6C2F352F62582F76722F37477155624455543162532F434F71774550424C4842486A6B6C73483842312F4F744F343057614332422F74743149357748787A3759787A58586D326153345A6E7445417A38724D774A464C4E7074684862764E644A45456A5575376E6741446B6D69317A53396A7A765531736D73794A4C695353363438755267643450714E76465A53654B4E513032655778763058554C5441334752443930394D3548383639467339483054553773585672714C79376C34515038763078696E5750677A54374E5A567543626D356C5974497A6C6C552B6778365679346E417871367652397A6F772B4C64505464646A44305457374B385255302F565A72527A30686D506D6F50774A7A2B41617247753347706166625454586D6C4C713167385730765972387948484F564A7A2B49704E652B463972664133476B536978754F706A424A6A622B6F726A68346838552B41376F52616E41375164415A4F5559657A567A65317865463066764C7A4E2F59554D527254646E324B7474706570615659786966544853655935456779634B653342774457666378544E4B566B75487A7744356B665048515633576E66454C5339593874375A3067764231744C6A4157596567626F443648697254654C764250327868644B6C72635A32794357454571336345455A466447585635596D4435316161335279346D6D364C31576835724C70655343747A4347626F696B6B6A3871645A61497876664C6C6E6A534862756B646839305636526466384143435874757A2F384A4662514B666D4A6A6456782B46656465493951306D4B6348524C7138764E4D5079746479526B526D51645655385A7744365676696F3159556D366131466856537156564762736A6F7258784C6F2B684C35656E57726C66346E4A77572F72577A5966466D307479456B7447432B787A586D435856706375675764434D6367486D736257645674724B557857784D733434594868552B70396661766D735051712B3276464E7A39543647725477736164353748767266457A773571536556635275763841767837682F5775583166556643704C69505A62527566384158526A61515436676A7037444665484E725634574265355A515439324D42662F414B2F36316274376D65533652374B43535736366F774A64776659386D76556557346D63756564586C39447A4658776B66646842733942385432642F5A6154766974644E6A736B514B5A35774D79746A4934493345394F67493547656C635A66533344584D4770616A71456C396262304D34696B4F664B504F422F6439434D645252483448385A65497048614C537275596735647054742F56694B6F7865457645476833556E326D47336A696D5178534B30364D4D4836453132314D54536847304A7136387A476E526E4F566E457074346C754E4F315174704F71794C48444F78747952734A556E507A6A474742474D352F4B766264496973664676686D3376726979524A5854356845774A6A62315567344972794C53664466682F5462704C725572354E516E553557306A5268475039356A6A5030412F4775776A38537A78796D5731755569664745433443714F7778364376497A50464F713073506450767376547A3966754F7A44594F53692F617235464C5537503744664730336F36673456303544446A38717069466A4F464A64654D416C53423765746464706C684A7155354F7157385556784A6C316C56674566314A34344E626161446377484B525774786237732F7544356A5A7832363942587452757263793173654D31467538646A6749624B57614D534A627A4C45414F566A33412B7050705657367339306A4E4B6752587A383349422B6C657258506853315A504F61366D74634C67784B2B33497A6E47507A34724376644530754D467A745947583734596A49774F7563344F66384139586172633742796E6E7A524D68424F4352393039542F6A32714F4733536151356A32386B6C52776677394B3376454F6A70704E2F6D4630655041494B4D416359394D38565A305057625854376D534739736C5A3147446B44475058474B6E32714976626335784C526F7A68474A4854446B34584F4F2F39616C2B784E2F7A30672F384141682F38613630334768334E3474784259794D3241504C424742366A6E3850792B6C572F4D30372F414B41722F77446A74447257324765796939636B4B3057373032484E46784C4650617442633277614752436A6F354F474247434B3539467542386F76664C7A333267633149306C354646694F2F67507A597979722B565570584E4F57787955375866686A55504B6B56567469333771534A634B42365937665375343054784E427145537858446753592B562F3861784C75472B764958686D387165467867674263663841363634725670563848366C444139366A4A4C7973624F4E3666584838363370314C726C6B5954703872356F6E734131504E303171354D55796A4A5548676A2B3850555651316D5A356F7842356B4D38636E486C794943442B646376703275573272577152584C6C675075534B634D68396A58472B5034645130474B4C56784863334B5279376C7562666F6741794377376338644F39564B687064505155612F52725569385565487253654738676A6974725856556B6349496A735861506D444D53646F47446A31794B38663142645446327A5869537976474E70596E634D4430596345563658346438576158346E7656586D4C554363694A736233502B793535796662483431334F6C2B496644326D584A74626933746265526C32532B664B7557395151657634316D6C4745744671627563357873336F66507472714E736A417A57714848636A4971397250696A557037574E4932686E746F77416F47666B3974763841685864664644774A6F7476614456394141686B6C633474347A756A6359795350377648595A483072794F614734687532745A6B387552667667484F42374775694E6474574F65564E4A334A6F3736377658456B30675242304344424E57524A786A47414B71435350714D4164423756712B47704E4E6655796D6F512B63474749747A454C7539386461797256665A77633272324E615550615355466F56344C4B39314F3438717974704A33394648412B70364376535043756C3658345A7434722F56357062322F414A466E616E596964766D6671666F4B6A533638754C79596F6B676A48335569414178394B775045757333476D78784343494D5A4D35636A4F334874587A6C664756635A4A556161736D653753776450447839704E37485A61393855395476492F73634D71365861456256696854715071502F72567972334E3164534D69366F7A75765653325350714B786448307538755239767662312F337963434E6A75326E6E4752302B6C622B49315A32565655756373514F53666573616C4F6A52584C42336634485868334E75366A79782F456F5357567A4B32476B522F716F71396F5868753631572B386F58554545536B42355A4734487342334E6370724D6A324F7352473276354959706E415A513333665534394B327050454F706142634E594E44424A476633734D6A727936483178333478585A5277376C5A3354545637624850696366795868617A587A5058357A6232476C515751627A566A52556555415A624741447761726166487038747876736D644A54314C6F763954584A364238535631694E4E4E6A304B3169762B676B38334379447638754F446A337256757445314249704C6D617975455566776F7648317A6A4E657246766C39355750446539307A7470395466544C66646336586253526B354C46777650355652587872707A456F6D684B6F43344942424241783756792B6A5873524169436C7772595A4851456A503148313656316E3262516D52664F744A466438444A51726A6A725130426D747233682F554A484D6C6C4A4778344A55394F63396364667972493162772F4265685A644E596B6B594B64786B6334365A7830392F774261364B36304B30765938574A6B5546546746514D6E6A76307878566E537446754937567265614A6F474B3756654D6E4150544F4F6672576251637161504C58733737544C675250433657356B7A3833562B7649717A35792F3838705079466568367A34596E46724C4A445A52586338674741386F554141444C6A507632726D502B4562316E2F6F4557762F67514B49706D6470523052323658614E416847376166764535342F77413856576B7672574B56533675485849595A4942394D6568716E4D48573338314C6C574F634861446B4836592F7A78556C6D346269655146635A5031726F6A515452557172526C2B4C66474336486F6B6C7A462F724847794264772B39366B65316544795875702B49645538754E706269356D633449355A6961367A3477616F4A76454D566C4341735545513448637479663078532F4371383072544C6D3475723037626C79496F476359556A717744486A50537461644E51324D3554637457613972623639344A68736A714D736331765038753957503770757973542F4144396139493850654B49626946726559426F794E736B556736656F494E65532B5074596861366C6353463558554B73546E654E76726A747A2F4F754F7364573144546F7052486373676C58424235502F7742616E53714E74364764536D6D6A652B4A746C6F39683477336548596D6774354633377732554439397670697355612F714674417361366A643751426C566B4B722B436A69704C4C5530766256744C763233524F64795348716A656F724E2F732B35477152366155486E794F4934386E4166505135394B7139787057305051374C53395273593175744E756F3956306554392B4C4F386A796A2F41436E4752307A3878394F6138366E6E696E314F346C687430746F334A4969566A684F66756A505046656765463947752F4446784E62366866777045355865735758375A4179634B4D595066504E59477461506157562F4A6661623971754130753553776A65504A50544B4D663655637655536C304F57627A4A5A664B694142786B6E50465176473654486353414430446631725A3071356845397A6453526F5A575937526A68666F4B705473504E4C5A566C4C644F7452666F576A7266444F76726652665A70332F7742496A4842504739665836316F33305358746F38457638512B553931505931352B743474753852746C32624D486739542F6E4E64485A654A3757344153632B544A6A6B6E37702F4776447865416C546E37576B763841674876595047776E4432645A2F7744424E4C52336B683078626563425A49574B45447067486A394D566E367A727957612B56456430703644302B74644E3455307544784C72713273747746746C51753278686C3845664B442B4E63443473534D654D645A455561787878334D6B6149677746436E6150304658686346375754717A3276735046343332455653703732334D6D3564377963794F337A73774F6651477476534C6D316B5339572B676B75377752626265547A53416844416E6A766B416A487654504463537961376169574F4A346934526C6B7879434D63652F706A76696E334D49734E617534346F6771527A4D6D526E6B6475707231553438334B756950446B323957556D6A754C563176496D4B707579727165564E66556E7772385279654F76424343346C593374712F6B54375777534D634E2B50394B3847314451575877504A653569386B4F7178434E743253462B5A7566557258532F415058704E4B38555874754137527A3232347170787972446E3873315878496D4C737A33512B456257467A4B6B556F6B34357A6B6E383835712B4C526B6A574E7045564332506E414F65656E49716C63654F49496956654F5647423734782F4F73326678527072414D6B6C7A424F65506D646D554431786D6F644E6C71614E702F4D535177535149673671797278514754634248745665513359743035726E346645697A516D443754464C6A6F42674D505447635A373164566C6D426B686B4D5963424359694D482F5A4977522F2B756F7330586F58706F6F4444357735417A7874494A786E6A365653382B322F3539312F372B4373712F6C75724A327932496359565577675535376E4F4D594A725038413753622F414A37702F774342616634306371475A576D546D3632764F6345486A42497A576F39355A5178455359556A7376516D754D456A516B596C59446A4744304E62326D6D47654E566D424A7879657464396A697565516646465166474458434B52484C476A4450734D6630727050684A62322B74366466364A4F6B4567446955704B4D3542474D676578412F4D56306E784838466E586644715846684547764C506379496E38614847562B76516A386138593058574C3377377130642F5A50736E514663486F515267676973376447576E6F645A71316B7348694672364F792B3232385A6542776D4747564F4D675A3971784C587770716D6F58713238634B784E4932496C6B666C75702F514376525043666A667764503465744E4F3157453230384342537A6F53486275647735354A4A35396158572F466E6850544E6230532B73584530647130724F73434573647945415A507566576B6F74614264484E3678344E7550437667363475623436574A324969557247386B6A4D5430444D51464F4D6E495874574234587674563166563758513455686E4D725951544A6B4C675A4A7A3236552F7741612B4E6276785A654B306B5967744973694742546B4C376E314A72752F6778344A6E696A6B385333734255794B5574412F414950336D2F6B422B4E5030446F594F7650712F68793167687572576253397973496A444C7552736A4A4F4D38456363317A4E3934676B6E696A4577676D637238317771625A547A3359642F726E725872586958345236353470314A7279373852577935344559747951692B6E5773582F686E69345462763852786A64365770502F7331476F575235584865574D576C79772F5A6E61374C686F70316B77464864575848503134716738724F636B313637592F4163333133636F6E69464767684951544C613544762F454D62753348502B466156742B7A336243567674506943526B555A495332322F686E63615668335044777841414278696C436B6E71507A7236444837503368337A426E553953322F56502F41496D7255487747384A7753455458476F7938643556412F52614233504B766844642F5A76695470384C4F566A6E33784E672B716E48366756443853644A625350694671304C4B516B38686E6A507148352F6E6B66685873326A66426677396F4F755161724465587A5357386F6C6951794C745848505047535078714C34756541357646476B51366E7030494F7057696B655776575750715648754F6F2B7071685850465044476C79584677743339716974384169463563375449503453656750666E6974613173724B35686C6E755A6F3275336B4A4D4C715375374F537839767872413850384169433438503667474D43547742773031704F506B636745636A314754585632586A485350744F6F466644747569334D6F6C69513449692B55416A49584F4D6A4F414F3959796F7165776331697434763150375070513071336E57533262623551586741633558487475503531642B454D4D6B6576336436714D7977322B7A49395749782F4931794F7233567871576F2B5A4F71687675525271753156476541425875506744513766512F437951785351334530683879346B6A495962795075676A73426A396657745955314263714A7663314A4446655A3878734D6536674143734F37696B523938556D5550792F4D634E302F7872613147345657486C6F56412B38575049484E5A7A616A41463353727562755758482F313675775849744F6E5A376B4A4F51546A3776544A342B6C61316A484F38352B7A53694D45454A6B6B672F6857592B7032324E7144596E634B63665870566472314D73305677724D6E4A504F4F763638564D6F3356696F7655334A726939743761574F57594F34494156676566705648375866663838582F3735482B4E54545855456A69564A4633592B595A7A6E6F616A2B32772F37482F66417269545855367264696E50597752323668673234632B6F714F77754657345A433667642B613370624F4234384F5346376A4F613576564C5662566936517448476F7A35685941486A304E6568657878574E6962566243776A3333476F42465948436E7163656E65764A6648692B474C2B346B76644C6165472B647375766C34696B395432495076696D3668644F30724D58334D63354F63697561764E3773636E4E4A6F6D4C4D7758415162474466525478534E644A6A436F78396D4E534E623535785454426A6E464C5530304E587778633652623678486436335A766551526B46625A48324B782F774272673548745874467038614E4F614C596D6B4F71527268514A5141464859444665437045527A56684D6763554C5154505774562B4C39322B712F61744E67574F4952655835557557424F633534787A775031724F7576693772747946414D455A556B676F70366B59396347764F647A34786E696D6C53614C736D7832592B4932747836624459323933396E676947414956436B2F5539543631444C343031695145767174363265756268763841477552436B486D6C3274526468796E5466384A6A7167786A55627363597A357A66343071654E6459516B6A55377A4F632F774376617558326D6C4348306F39344F55374744346761384D5931653834395A536176772F4650784A62454D4E544D6D52794A4556732F6D4B344A5179386471637839685271466931346F316876454E38313763323853336266666C68514A3568395741344A393678494776597A694B56302F335352563452626D7A3656616774686B3536394B61695665794C6E6862776471666957396377756F5750486D5453747775656E755478587348686A77666165463361346C766E6E6D5A53755642574D6A36657631727A2F77656C7A62367035734D6A7043696B796B5A77526A41422F45313262583873726B6C7A7A787A3346506C73546336473853463837537531526B5A362F345668584E6D48675A746D3761636E50537030457A573541664742787954327830714B63534346673253705831785473426E686F424D6B51494C6E4F31557978503041716534307049417632686F62497A456F6775575A48626A72674B53423963567A4771584D396C715676634A4D3045626A794A47553941534D4838774B66706C3364544D35314363737345686A59794D712B57526A4A4C6B48484A4741426B3839685259457A736243326A696964704C71435364527356625A7A387533314241392B6E70552F6E53663841505A7679482B4E63315961726132576F6954375A4650484C4B71484A7956626B484F514365446E4F4258552F323370582F507862317731494B4D6A73707A626952525873307744753263386668584B2B4E42664A647874506447534A314A5263394D63632B7631726F72542F41464B6655667972463865396250384133572F6D613775787953324F496B6265756364617A5A6F67577857695039577631716A4A2F7250382B6C5530516971304B714D6B557A794255386E336162322F43707357583942384E54612F645352515378522B576F5A692B656D636359487658635748776F74522F774166756F794F5231574A414232376E507236566C6644662F6B4A336E2F58456638416F5172315A503841575366542B69314A5352793968384E4E4274476B2B317879584B6C7430594C6B59584947446A48664E614635384B664474376166756F356252774346654A73357836673572666B36702F756A2F77424472586A2F414F505966377A555741384538526644793530433165364E33424E4172374F415662505062703239613562374D414F31657A6645582F6B575A663841727638412F4631354365672F43694C334A656865384E6546702F453273783666625452524F774C46704D344148586F4B377476675A6668514531613159734F4E3062442F414430724D2B45762F4939526639636E2F6C5876592B3946395036476B335A6C4A487A6A34692B486C2F34613039727935756257534D4652694D746E6E70314663734C666356484753634376625069742F774169712F384176525634796E2B736A2F3368516E644361734D2B7A474B566F7977344F4F4B3750512F4258327459726935754657462B64735979782F4F75556D2F342F7050392B76562F442F38417943625836663046556D4B78647462433073724157397043493058722F7448314E5A4E3042747A6744424947423656764A2F716D2F482B597242757675442F656171426B634E7A4A45783238414473656C50754E524B78664D756367344F5053713338542F512F7A714B382F31432F52763530434B326F5152583665544B677849754342774B7252775471596B6C69744C694E666C4F35536A735267426934354A474B75742F726F76702F5555672F31672F337A2F4F6B42526D695338554D3845554B706E5A48466B375365435378354A4F422B56516632595037782F77432B6A56745039562B582F6F565330575253502F2F5A,NULL,'123',NULL,NULL,'','photo/4f10_2.JPG',NULL),
(217,'2007-08-25',314,NULL,'castle hayne',NULL,NULL,'6199','61','default','2003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Silver',0x2F396A2F3677416652564254415869633763454244514141414D4B6739302F7437414555414141414E7730674141482F34414151536B5A4A5267414241674541534142494141442F2F67416D51334A6C5958526C5A4342696553424A6257466E5A55646C595849734945466A5933565462325A3049454E76636E41752F384141455167416C674449417745694141495241514D5241662F62414951414277554642675545427759474267674942776B4C4577774C43676F4C4742455344684D634752346448426B624778386A4C535966495373694778736E4E6967724C7A417A4D7A4D654A6A67384E7A45374C54497A4D5145494341674C43677358444177584D534162494341784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445784D5445782F3851426F674141415155424151454241514541414141414141414141414543417751464267634943516F4C4541414341514D444167514442515545424141414158304241674D4142424546456945785151595455574548496E45554D6F47526F51676A5172484246564C523843517A596E4B4343516F574678675A4769556D4A7967704B6A51314E6A63344F547044524556475230684A536C4E5556565A5857466C615932526C5A6D646F6157707A6448563264336835656F4F456859614869496D4B6B704F556C5A61586D4A6D616F714F6B7061616E714B6D7173724F3074626133754C6D367773504578636248794D6E4B3074505531646258324E6E6134654C6A354F586D352B6A7036764879382F5431397666342B666F4241414D42415145424151454241514541414141414141414241674D454251594843416B4B437845414167454342415144424163464241514141514A3341414543417845454253457842684A425551646863524D694D6F454946454B526F62484243534D7A55764156596E4C524368596B4E4F456C3852635947526F6D4A7967704B6A55324E7A67354F6B4E4552555A4853456C4B55315256566C64595756706A5A47566D5A326870616E4E3064585A3365486C36676F4F456859614869496D4B6B704F556C5A61586D4A6D616F714F6B7061616E714B6D7173724F3074626133754C6D367773504578636248794D6E4B3074505531646258324E6E613475506B3565626E364F6E7138765030396662332B506E362F396F4144414D4241414952417845415077447A437A31694743796B7433506D71666C56656736593450305036647178626E5449524D5567645333424256754163394F6E30724D457844376763415A49464F38397043775976767763455678786F3872764562643978747970684C4B5377494F434F6C4D67555353734647633441794F63397175696154554945736E4A4C782F4C466B415A48705657414A45634B374275704A474E702F7A33725A5051476C665130435373634D56786B4A744B59413735342F4C697465505635725757334D587A5045467A6B6A35697671505446594D4636747649307A786F386A5932377875366657727639704C635472626D4A703063384D373463646359505164617A6C473437713268314D656F693975686353495544714643686C77707A6A3634786D744F31764946754A336C6D5A68734A79543764636334342F4B754E7464534E73363277514972454267464F547A31466455313139696D68563751375A6C4C7336674568546E47523234374431726C7155373664436F7458314F6A307164495A434C6D3362644C67686D58425265765438652F5775793044784C4E6F743545786B645963717A717656786B354A3971387A30792B7647682F66547449375075684C4A6E35417042497743534332422B4835623172665774334D494C7056655232584F7869517631412F7A3739613535776C4670784E464A4E575A66385A654B39533852654C4A4C507A705073573745635154424348396135744E4A6E65304D31326F69594173456365577A447638416534394D593961395630437A302B4B796C7549346D6C7556626449336B6C584B39734472794F6C65532F4554785265663237495937706F34535273674D654367364850366A72394B37563753326D2B687A7452524862654B576975307462534A68624B32305947634574307A6A6B347251385436576B74756C31617846355366336B672F6A782F466A3645666C5844615065433361366C6430414A56673764515236484250513961373752646574627179386964476868436C764E5055456E4135394D382F6E58484F447031564F507A3878704A717A4F4976466449683534335267456257794B774A4A50736B306756677967664C786E50493656374C50445979327867757269485549315466467579726577357763382F79727950553950534C554C67535376456B63685142313534363944363133776B6D37462B7A32535A51572F6E6552524A4B784763664F63385665686E636C7976456842786E6759373471764E5A7865544738444D5177366B4872372F41495554356952564C493067554D436F7A7951442F58394B75365A43567479304C31577346694A79774978386F34417A2F6A2F4F72797A747569797172464A6E5953436339754D656C5A317059796D595354776B527279336F654D396A33785531715A726D574E35476A38754D62533744494335365950317148626F43646C7164485A364A452F3261434667776E425A355A53426A6E3279663834716554777A6458467949726C6D423368464B4C387171464A2F6F4B6F4855356D6B58374F694D56495541446C674F6850346D752F30612B413059527954744A634B7A4F575563523548662B64636B36736F5375564E7157786C474333306E5442464D534C517557626479434F774242344835646163326F575530635572487A6263356A42564E6F59415A376E4F636D75563133556E757239344A726A5943764751506D553969414D56697733455433434B4A354955536243784D536368753448746866725750315A7A3935736C4D3951454D5633756147646B336E4C7347775735376B39662F723076396B4A2F7A39502F414E2F562F774161773474526D696857517A5A77562B6A454433354E542F38414352536633462F4D316E374F594B53366E693559427434497942786E76566A7A764E69434D4172397A5549676D442B57697353654467566368737070596C6C574175463238714D672F77436348387139787449466462454D3670434130557A737847543876306F6C6C44736A6E4735686C6A366D72567862323736657249345766507A4A7A3078314862384B7251526F625A6A744C4E4752675936354F4D66725354304661346867333867376E787744785673634E627371515237663363677A372F65502B6531527A714577456A594A6A437437646636697265675766326E55346B6C74524F75345A52383459642B6C4B543075777472596B306F7466616A62776C764C64706C4554382F4C6B342F49646137545864543075434F317433756F584E6F35436D3356794A6B4F4D6C79534D453752363965744D6E744C5051624761524E6E396F33622B64424A48454E6B517A304835343656782B7153733979456D694B76477A4B7756686A743666543961776A4A5648377578646B644271486953612F534F3373704A45746B596C566C5935474F67366B59362F6E552B6A585574707154504462766443496775577A674E6A6B6B653376574870624971695279715237535168344A627467383450505848537573384A52514E716F676E5174464B34425A6D4261523863396659397655566E4E7143646B472B35365A70766A54546B75316769734A7A6433434150737A7458686A6A6766686D76466648456C724C34687570624F4578576A486369445037746A7952302F51394D3136356332455039724F385079465556636E75414735483531786E6A7A77364D51366C6177415735552B63597A7443484F4E3230397A6E74336F6858764A5837446450513831745235382F6C68794133527553536577726F4E4F314E624748374A614E766E64677A535A776F776334493659782F537565564D684569786C2F6C3549414A422F537530384A36426154794737765366394650336C584353454448796E324939757462564C577579456E304F32655732766441743449764F742F4B692F652B7241383534487230727A48583452487145304D317973784C46764E586B6E3631326571544E65516E5952464A676748616346657736317775712B59302F6B7368584148494F51654B7A707479656F355261526D777A6D4B426F3848357A7449376748422F70557950356A6F736473476C596557467A304A3442352B764656797247592F4D51547778413471644C614D37575A7A67357A6A7231725A3252506B61576E615850653345624269495A4A566A6556736C526B34362B67715338686D734C2B6178676B52305233684D6B66335A4172486E6E714F416176574D463763326A52515452773234496B565A472B63374F414E3351662F57724C316D356D3871474948617A5A4C734231352F50742B74517457556F36457470456A61724644627A4D684462574C45484A4847526A395070317230323075764A38745A437A59366C7A317267664445506B6F626C465235466A475333384F44314848487058535361764C48457253522F4D6547417944332F502F774376584E55584E4B3359306972366E4D2B4E704866584A4A4A5934316A5541786866722F577558696B54375A484B48593753472B376A6E307264385833453135644B56666645454156694D626659317A6C7259334570444D306361486E4C48705858546A376D706E4A4F35324672635479515233446F5153434D42535239666D2F7A6D7066744D76712F3569693073342F4B515253727441413877635A7832342F4372583264762B65782F77432F702F78726B6B3146324D395563496B42656264353652776B4465724F446E4857745A4C6C5A49354C595730567571344B466C4763665848512B6C59556B6372734733466A6A4A4C484E57624B36314330456B6355706A52385A324D563537667A4E646B71664D6A657975616D70576467756B6C304A2B3071514E7754437478302B76762B465A326B32356B6C6C6473425073386A6A3565367157483672537A3346356452496B306A4D423044484F546A4855315070717A4C4E4B68647A2B346B555A4F5267715152516B3478746346464E6C2B57306967307A53726B54786D346E416B56436D574934583664564A77666172396A50707945504334456358424A4750624A4F4D566D7A32766B784B774A44474B4F4E4D39754D2F3172506E676E6B4F576D475634777736666C5563696B724E6A6B6D7455645271666936426F56747859435741497947517674786E2B3778394B77707276544C32345753412F5A696F2B37356648543242717047724241784D62636E4C64683647724F32344144715649365941366635352F4B68556F51566F6D537157334A6243437957324A6C6E33475135614A593247336E6F43562B6C64566F5770577468504D746E706B30785A43336D4471507A3666577550486D37444958554D677A6B35774F77785374636E79774E78326B445042705370786C75487432746B6439642B4A74627562395A7261433174777679596B6C334E6E6E735035567A486950557645476F756B4678655767566552396D6A63446E3133566D787330306B6B437A624A735A554874786B314A4E62366D73617356696B334544357371446E3371347770726F684B724A376C653174376C5A44495A556432666378326763357A2B417A3656765258306B555337444E484372444D635A44413844382B6F4E5A4D636B6B454262794D6B3868354D644D6A742F6E72562B5454645354533761565970575364335178516A63593241445A774F672B59666B653153377437452B306C5933646473764975626F744A64745A524D49784C48497041476348646763416E4A4149485775634E6E4863526E59386E6C506B416C526B48742B47613662777634567664653143613731435259495A3761554B3179786A456A434E694370497764704150626756315633344F384F3662344C7372354C6D347537704E322B434A317A4A454E784D696A4754676C652F543656736F396B557074725538616B7478416A464E7A537163747A79414F3957375349506546336941423577526E3659482B656C6148696E54596E74494E62302F486C53447937754D6638733552332B6A59795066497249746D594B68336E65666C3345386E2F4978554E4E6A53766F6A71536B62356A6A696641795171536253505138672B762F36717A356F7043355177495144787647346A382B5078786D717A33306B4256566E4B6A484F3169467059395467336B672B59796E424739736A39656C58486B53764A446D6D75707136565A504764374437325156423669744F65307446684C764170774D3873787857565A36706179754D706B4867664D5341667A71585662367A2B79764846627747526C497A3178323936316734532B4647546B2B724D653669744C683232694D717544685636656C5074645073456C556B464133496248424763567A797A7241444778626430584879676E30785679337670355235617975536F41436B66556E384B796C556D6E6445335A31682B79776A62356B6A7170424A5145696E66624E50394A663841766B56685762545A55733854524D666E474F6D5062366D74444E742F30792F3734622F47735A566276564773597861315A7867756C35436F426A4F535161656C305375584143636A307A2F6E69716D64684B71634C6E356374302F794D302B4B786E6C4B2B57416F6673782B587231353656765A454B546655757249726E6169636B34474F66774E537758545236677172686E355173703641676A6E38366D747450644C56704275454F6362796341666A565353322B79795A6C41386C2B6A527144676575522B465370526568616D30726E5457467A446658567A4647646B6E324B59516A48495A49795152376E5A742F47734C5539536C7557686479486B6133525467636E475637663775616E384D4E4976692F536F6C554973317847682F36357351434D31556830324259595856316A6152536345355A534F334A39656C57744B64764D6C7A626478467559354C454E62776C5A63465849364475415054505072546C6D6C655A77496D4C396365767638417056775763363869796C6B4F4D377770775030782F774471393673576D6D5830734A6C654B394F7846774E684F53434E77365A3769736D7264434C6F6F776F7A595A49775764435172664E302B7676532F593435454C7176634F357A77516550782F78717A70396F786E667A495A424949397A526C73354A36454C6A702B76394A4C4F3375435A624743325178466C4C70506A636E5461426A7036483631504E5A36434C44326C756B4257326A486E77786773454F485667446B456E6F633548487037384D754C6C3768594462796F396F454B374E2B336B597744394D6A6D6D47346A6C674D74354249732F33424A487744787763656F7A57664C45384E3174695A3472646753664D58355A4F4F33626D6C474E397776324A586C6558657A78674D76335642364148676631725138506D433731354A5A7279355152596C4A7447414B4564435750413578363146617750727478484462526563377356534D4B54745534363437633137426F586772522F44396B67764874353767387445666D5565674B6A714236456A767858525367355052416D37464877352F614F74616C4E6536643464755A555643494C71396E584B6B34425A664D4F306B6A493441786B316238552B455045646C656166716E6E47655862694E6269556234426B6E6771526B44643235343769756D612F3036376D69697649476D6A6A594750597051703659414F4F4F32617A76697064505A61485A336A43377562425273687A74456B55687867717741794D6763482B5761364A302B55754C624F44306C625733385A746F327257536F6C36776959702F71386E42424339427A373446563762346461394E346775744A6A306153654744377477554378735034666D62417A375A34702F686E346D7757486A2B43432B6843774D504C61642F76456E484F534163486A38713978315737743747424A43797571707656513244496E74376A50355A7146546931726F446C4A50512B65764666684F62776C647462367445694353507A49764C494B734F652F545042726C376A546748646C695A5A686778727547534D3448762B6C65712F46753974764563326B32646B6851514A4F5761516A6343437541633973352F4F764C4C4235726B5471786A614E4632417375664C39434748492B596A48626D75536F2B5674525935536230594742744B754D54456C45624C72747951656F42485938455657754A7A4E475173674C4849796341343976705635376D535A7A63616D6A50634A483552773333736A414F656D414469716A4B3849614E585A6B4241435979662F77425846464A7
and then all the tables are not put into the database like it should be. Any idea why this is not working for me? :( Thanks.
I set up MA plan to full back up by schedule
and I would like to move them each completing process to another computer for preventing failing if harddisk of server was damaged.
How to move them by schedule to any computers ??
Please give me some suggest.
I have a problem when i restore my .DAT_BAK file. I am getting error like "The backup set holds a backup of a database other than existing database. Restore Database is terminating abnormally".
I tried by using
RESTORE DATABASE <DATABASENAME>
FROM DISK = 'D:DATAMYTEST.DAT_BAK'
WITH MOVE 'VZAI_DATA' TO D:PROGRAM FILES..MSSQLTEST.MDF',
MOVE 'VZAI_LOG' TO D:PROGRAM FILES..MSSQLTEST.LDF',
REPLACE
And also i tried like
RESTORE DATABASE <DATABASENAME>
FROM DISK = 'D:DATAMYTEST.DAT_BAK'
WITH REPLACE
When i use like this,
RESTORE FILELISTONLY FROM DISK = 'D:DATAMYTEST.DAT_BAK'. I am able to get the output as LogicalName, PhysicalName, Type, FileGroupName, Size, etc.
Can i anyone please help me out?
Thanks in Advance,
Anand Rajagopal
I am trying to create a job using power-shell script to move the backup files from one folder to another. I am using Ola Hallengren script for backups. Ola hallengren created a common backup folder with sub-folders for databases and even more sub folders for Full and Log backups. My goal is to move full backups, which are older than a month and save them in a different drive along with the same folder structure. I was able to move the first set of backups without any problem, but I can't move anymore files and keep getting this error even when I try to overwrite the previous file with the force statement:
Move-Item : Cannot create a file when that file already exists.
At line:5 char:9
+ Move-Item $i.FullName C:Test -force
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (C:BackupVALIDATIONgcommon:DirectoryInfo) [Move-Item], I
+ FullyQualifiedErrorId : MoveDirectoryItemIOError,Microsoft.PowerShell.Commands.MoveItemCommand
Here's the script that I used to move the first set of files:
foreach ($i in Get-ChildItem C:BackupVALIDATION)
{
if ($i.CreationTime -lt ($(Get-Date).AddMonths(-1)))
{
Move-Item $i.FullName C:Test
}
}
Hi there
I'm getting this message on my third automated backup of the transaction logs of the day. Both databases are in full recovery mode, both successfully backed up at 01.00. The transaction logs backed up perfectly happily at 01:30 and 05:30, but failed at 09:30.
The only difference between 05:30 and 09:30's backups is that the log files were shrunk at 08:15 (the databases in question are the ones that sit under ILM2007, and keeping the log files small keeps the system running better).
Is it possible that shrinking the log files causes the database to think that there hasn't been a full database backup?
Thanks
Jane
Does someone know whether it is better to drop and reload or sp_recompile a stored procedure to get a new, recompiled execution plan? I have another DBA telling me it is better to drop and reload the stored procedure rather than use sp_recompile. I would think that sp_recompile would be the preferred method.
View 1 Replies View RelatedI am doing a master page and i want the page to update itself when a new value comes in. Example, my master page default value has login and register (both are set as linkbutton)
Login | Register
Then in the login page, when the person successfully logged in to his/her account, master page update linkbutton login and register text will change to welcome john and logout.
Welcome John | Logout
I have a problem with getting a dropdown list to change a txt field every time I select a new value on it.
I have a parameter called "Type" that is selected from a non-queried drop down list. This contains values like "Month" "Day" "Quarter" "Week", etc. I have a query that takes those parameters and then returns a "TimeInterval" for each one. I want this value to appear in a text box (Which is a MaxDate parameter for an entirely separate query) whenever the user selects a value from type. However there is a catch, the user needs to be able to also change the value of the textbox so that he/she can customize that end date for report rather than the values that I have pre-canned for them. This is a bit confusing so I'll try to give an example. The wants to run a report and selects "Week" from the drop down list, this value is passed one of my datasets and that data set returns the value 07/15/2007. That value will then populate in the MaxDate parameter field. The user then changes his/her mind selects "month" from the Type drop down list. What should happen is that the MaxDate field changes to be 07/01/2007 (This is returned correctly in my querry, but I can't get it to show in the maxDate field after the first time.), but instead it still shows 07/15/2007. Here is my SQL code for the dataSet that uses the parameter Type to return a date
IF(@Type= 'Day')
BEGIN
SELECT dbo.F_START_OF_DAY(getdate()) AS TimeInterval
END
IF(@Type='Year')
BEGIN
SELECT dbo.F_START_OF_YEAR(getdate()) AS TimeInterval
END
IF(@Type='Month')
BEGIN
SELECT dbo.F_START_OF_MONTH(getdate()) AS TimeInterval
END
IF(@Type='Quarter')
BEGIN
SELECT dbo.F_START_OF_QUARTER(getdate()) AS TimeInterval
END
ETC....................................
If you need any aditional information or have any questions, I'de be more than happy to answer them. Thanks in advance, /jcarver
Is there anyway of including/excluding some javascript to reload the report (with the parameters the user has chosen) on an automatic basis?
View 1 Replies View RelatedI would like to empty out my 2k8 database (remove all the data in the tables only) And reloaded it with the data from production (2k5). I know I would have to dis-enable any constraints, triggers and remove all indexes before I can run a Truncate/Delete on all tables correct And then import the data via Wizard or script And lastly enable all the constraints & triggers, rebuild the indexes. Is this the only way to go about this? I don't want to do a backup & restore because the 2k5 doesn't have a 20% of the tables that are in 2k8. The 20% of those tables in 2k8 i'm not going to remove.
View 0 Replies View Relatedthis might be a stupid question.
I have a parameter which has a default value set to it. when a second value is selexcted is it necessary to click the view report button.
Could it be set to auto reload on dropdown selection.
I am using reporting Services 2000
Thanks.
Hi folks,
After getting a form view inserting some values into a mdb file, it inserts the same values a second time on page reload.
How may I cure this? Any suggestions?
VB Code is below.
many thanks in advance
Rosi
1 <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="km_Eingabe.aspx.vb" Inherits="km_Eingabe" title="km-Eingabe" %>
2 <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
3 <table style="width: 750px; height: 210px">
4 <tr>
5 <td style="height: 38px">
6 </td>
7 <td style="height: 38px">
8 <asp:DropDownList ID="dropdownlist1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource2"
9 DataTextField="polKennz" DataValueField="polKennz">
10 </asp:DropDownList>
11 </td>
12 <td style="height: 38px">
13 </td>
14 </tr>
15 <tr>
16 <td style="height: 235px">
17 </td>
18 <td style="height: 235px" valign="top">
19
20 <asp:FormView ID="FormView1" runat="server" CellPadding="4" DataSourceID="SqlDataSource1"
21 ForeColor="#333333">
22 <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
23 <EditRowStyle BackColor="#999999" />
24 <EditItemTemplate>
25
26 </EditItemTemplate>
27 <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
28 <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
29 <EmptyDataTemplate>
30 keine Daten vorhanden
31 <br />
32 <asp:LinkButton ID="NewButton" runat="server" CommandName="New" Text="Neuer Eintrag"></asp:LinkButton>
33 </EmptyDataTemplate>
34 <InsertItemTemplate>
35 Datum:
36 <asp:TextBox ID="DatumTextBox" runat="server" Text='<%# Bind("Datum", "{0:d}") %>'>
37 </asp:TextBox>
38 <br />
39 Fahrer:
40 <asp:TextBox ID="FahrerTextBox" runat="server" Text='<%# Bind("Fahrer") %>'>
41 </asp:TextBox>
42 <br />
43 polKennz:
44 <asp:TextBox ID="polKennzTextBox" runat="server" Text='<%# Bind("polKennz") %>'>
45 </asp:TextBox>
46 <br />
47 neuer_Eintrag:
48 <asp:TextBox ID="neuer_EintragTextBox" runat="server" Text='<%# Bind("neu") %>'></asp:TextBox>
49 <br />
50 aktuell:
51 <asp:TextBox ID="aktuellTextBox" runat="server" Text='<%# Bind("aktuell") %>'></asp:TextBox> <br />
52 <br />
53 <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
54 Text="Einfügen" OnClick="InsertButton_Click">
55 </asp:LinkButton>
56 <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
57 Text="Abbrechen">
58 </asp:LinkButton>
59 </InsertItemTemplate>
60 <ItemTemplate>
61 Datum:
62 <asp:Label ID="DatumLabel" runat="server" Text='<%# Bind("Datum") %>'></asp:Label><br />
63 Fahrer:
64 <asp:Label ID="FahrerLabel" runat="server" Text='<%# Bind("Fahrer") %>'></asp:Label><br />
65 polKennz:
66 <asp:Label ID="polKennzLabel" runat="server" Text='<%# Bind("polKennz") %>'></asp:Label><br />
67 neu:
68 <asp:Label ID="neuLabel" runat="server" Text='<%# Bind("neu") %>'></asp:Label><br />
69 lfdNr:
70 <asp:Label ID="lfdNrLabel" runat="server" Text='<%# Eval("lfdNr") %>'></asp:Label><br />
71 aktuell:
72 <asp:Label ID="aktuellLabel" runat="server" Text='<%# Bind("aktuell") %>'></asp:Label><br />
73 Dienststelle:
74 <asp:Label ID="DienststelleLabel" runat="server" Text='<%# Bind("Dienststelle") %>'></asp:Label><br />
75 <asp:LinkButton ID="NewButton" runat="server" CommandName="New" Text="Neuer Eintrag"></asp:LinkButton>
76 </ItemTemplate>
77 <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
78 </asp:FormView>
79 </td>
80 <td style="height: 235px">
81 </td>
82 </tr>
83 <tr>
84 <td>
85 </td>
86 <td>
87 </td>
88 <td>
89 </td>
90 </tr>
91 </table>
92 <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/KfzDaten_Ansicht.mdb"
93 SelectCommand="SELECT DISTINCT [polKennz] FROM [qry_KennzeichenAlle_ohne_ausgesondert]">
94 </asp:AccessDataSource>
95 <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/KfzDaten_Ansicht.mdb"
96 SelectCommand="SELECT DISTINCT [Datum], [Nutzer], [Fahrer], [polKennz], [aktuell], [neu], [gefahren] FROM [qry_Fahrtenbuch_letzter_Eintrag_pro_Kfz] WHERE ([polKennz] = ?)">
97 <SelectParameters>
98 <asp:ControlParameter ControlID="DropDownList1" Name="polKennz" PropertyName="SelectedValue"
99 Type="String" />
100 </SelectParameters>
101 </asp:AccessDataSource>
102 <asp:SqlDataSource ID="SqlDataSource1" DataSourceMode="DataSet" ConflictDetection="CompareAllValues" InsertCommandType="Text" runat="server" ConnectionString="<%$ ConnectionStrings:KfzDaten_Ansicht_mdbConnectionString %>" ProviderName="<%$ ConnectionStrings:KfzDaten_Ansicht_mdbConnectionString.ProviderName %>"
103 InsertCommand= "INSERT INTO Tab_import_Fahrtenbuch([Datum], [Fahrer], [polKennz], [neu], [aktuell]) VALUES (@Datum, @Fahrer, @polKennz, @Eingabe_neu, @Eingabe_aktuell )" >
104 <SelectParameters>
105 <asp:ControlParameter ControlID="dropdownlist1" Name="newparameter" PropertyName="SelectedValue" />
106 </SelectParameters>
107 <InsertParameters>
108 <asp:FormParameter FormField="DatumTextBox" Name="Datum" Type="string" />
109 <asp:FormParameter FormField="FahrerTextBox" Name="Fahrer" Type="string" />
110 <asp:FormParameter FormField="polKennzTextBox" Name="polKennz" Type="string" />
111 <asp:FormParameter FormField="neuer_EintragTextBox" Name="neu" Type="Int32" ConvertEmptyStringToNull="false" />
112 <asp:FormParameter FormField="aktuellTextBox" Name="aktuell" Type="Int32" ConvertEmptyStringToNull="false" Direction="Input" />
113 </InsertParameters>
114 </asp:SqlDataSource>
115
116 </asp:Content>
117
118
guys,I have a project need to move more than 100,000 records from onedatabase table to another database table every week. Currently, usersinput date range from web UI, my store procedure will take those dateranges to INSERT records to a table in another database, then deletethe records, but it will take really long time to finish this action(up to 1 or 2 hours).My question is if there is some other way I should do to speed up theaction, I am thinking about use bcp to copy those records to datafileand then use bcp to insert it into SQL Server table. Is this the rightway to do it or should I consider other solution (then, what is thesolution.)Thanks a lot!
View 8 Replies View Relatedhi,
I have a access database. In this database there are 10 tables and this tables are related to each other.
I want to move these tables to another database according to a field in XYZ table (vertical fragmentation).
for example there is name coloumn in the XYZ table and I want to take only joe lines and other tables related to that from database A and move it to database B
how can I do this?
thanks..
I’m working with an msde database on my local machine, but need to take that database and move it to my remote host. This is problematic because I can not just do a back up and restore.
I was wondering if there were any asp.net applications that would generate lots of sql statements to reproduce the database on my remote host.
I had built a program to back up all the tables in that way, but, forgot that the membership stuff uses stored procedures, and I don't not know how to modify my program in order to back those up too.
Any help will be much appreciated, thank you very much for reading my post
Hello,
What is the easiest way to move a database from one server to another with the all table structures, view and stored procedures?
Thanks,
Using sp_detach and sp_attach we can move different databases to different locations.
how do we do the same for system databases such as master,model,msdb and tempdb.
As off i know we got to be in master database to runthis command, if not this how do we go about this.
Thanks,
sheena
I read the one of the replies to a question.
"Subject:
From:
Date: SQL 7 Restore (reply)
Manish (manish45@yahoo.com)
11/1/01 9:03:43 AM
If you want to move all the databases to new server. Stop the SQL server service on existing server. Copy mdf and ldf files of all databases to same location iin new server. Also take the backup of master and msdb database from existing server. Then restore master and msdb on new server.
"
My question is how to move my database to a DIFFEREN LOCATION on a different server. My two servers are different file layout (not my choice though.)
Thanks a lot in advance.
Wuchun
P.S. Should I use the DTS at all to perform this task?
Hi:
I need your suggestion or experience about how to move a database from SQL 6.5 to SQL 7.0. The server where SQL 6.5 resides locates in different network than SQL 7.0. DTS does not work for the database move because of two server can not talk directly.
We need to do this task very soon in production environment. I tried to backup database to a disk (backup device in SQL 6.5) but I failed to restore it in SQL 7.0 because the backup file was not detected by restore utility in SQL 7.0.
Please tell me what I should do. Besides BCP, are there any other methods to move the database from SQL 6.5 to SQL 7.0 in diffferent networks.
Thank you very much.
Joan
Hi
I am new to sql server 7 and dont know how to 1.make a copy of a database
and 2 to move a database i know there are sys stored procedures but the syntax looks crptic and i dont know where to type them in if any one could give me any really clear examples of how to do both of the above i would be really grateful, thanks!
i've got to move 37 SQL Server databases over to new server. My manager tells me that i have to conduct some "check totals" to make sure that the databases contained exactly the same data from what it was when it got moved.
Is there some stored_procedure to do this ? to make sure that all the stored procedures, views, tables got move across ?
Hi,
I'm new to SQL Server. How do I port the modifications of my table structures, store procedures, functions on the staging server to the procduction server without affect the data?
Can I make this modification to production database while user are still accessing the database or I have to bring down the database to make these changes?
Thanks in advance,
Is there a way to move database from developement to production servers along with the logins and their associated roles as well as passwords. I did backup and restore and used sp_change_users_login to fix the logins
I mean is there a way to copy logins and roles Thanks
Can anyone tell me if it is possible to move the data directory of SQLServerfrom the application server where SQL runs to another system (the file andprint server) in the network?regards Joop
View 1 Replies View RelatedI'm needing to move a database from SQL 7 to SQL 2000. What is thebest way to accomplish this and keep all tables, data, permissions, etcin place throughout the move.Should I use BCP, Replication or something else?Thanks for any help.
View 2 Replies View RelatedI have a web project in VS.NET 2005 on my development computer that uses an ASP.NET database (ASPNETDB.MDF) to manage user roles. Now I would like to move that database to a test computer with IIS. After copying the web project and database I am able to read from it but when I try to update I get the following error:
Failed to update database "C:INETPUBWWWROOTMyWebAppAPP_DATAASPNETDB.MDF" because the database is read-only.
I think this is because the user 'Network Service' that IIS uses does not have access to the database. So how do I give 'Network Service' access to the database using SQL commands?
I'm trying to move a database created on SQL Server 2005 Express Edition to the SQL 2000 Server (that's the version the company uses). I understand that this is done by making a script that, when executed, creates an exact copy of the database structure on the target server as well as copying the stored procedures.
After that I somehow need to export the data from SQL Server 2005 Express to SQL Server 2000. How can I do that. There's no export function in Management Studio Express.
I am using VWD 2005 Express, with SQL 2005 Express. My web hosting company supports ASP 2.0 and SQL Server 2005, but have put SQL on a database server, which is separate from the application server. I successfully published a "Hello world" test application, but my database application failed after displaying the logon page, presumably when it first tried to connect to the database.
VWD has created my database within the application folder (appApp_DataASPNETDB.MDF) and created the configuration string in web.config: -
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
This all works fine on my local development server, but naturally fails when the application is copied to the web host, and the database can no longer be run from an application sub-folder. With SQL 2000 the problem would have been simple to fix. I would have created a database in the host DB server. I would then have backed up the development database, and restored it into the target database. I would then have changed the connect string, and all would have been OK.
How do I get the development database into the target database with SQL 2005 express? I can't use backup/restore, since there is no backup within VWD 2005 Express, and although there is a backup within Management Studio Express (MSE) I would need to get the database into MSE first. I tried opening the MDF file, but MSE wouldn't recognise this. I can't find any way of exporting the database - the equivalent of SQL 2000's DTS is not available within MSE!!!!!!!!! I tried installing an eval. version of the full Management Studio, but the install failed because "there is no upgrade path".
Once all that's sorted (if it can be sorted - I may have to go back to SQL 2000), where can I find out what to write in the configuration string?
Thank you, Robert Barnes