Help!! What Is The Best Way To Move A SQL Server And Its Databases To A New Machine????

Jul 10, 2000

Hello all. I am a baby new database administrator who hasnt finished all the courses yet. I have my Administration exam but not the Implementation yet. I got hired anyways! woo hoo.. Anyways, my question is this. I have a SQL Server 7.0 machine and its databases. I have been asked to move it all over to a new, skookum fast machine with access to 3.6 Terabytes of storage. I have been researching the best way to do this but am not sure. First there is detaching and reattaching the databases. I dont like this one cuz when I have done some practice ones it completely erases the databases of the original machine. The other way I was considering was using DTS. This is easy to use with the DTS wizard but the transaction logs of the databases are not transferred. What would be your advice on this move?? I need to make a this a reasonably seemless move. Help!!

View 2 Replies

Can I Move Whole SQL 6.5 Server Together With Db From One Machine To Another And How?

May 27, 1999

View 1 Replies View Related

Can I Move Whole SQL 6.5 Server Together With Db From One Machine To Another And How?

May 27, 1999

Hi, everybody:

Is that possible to move whole SQL 6.5 server together with db from one machine to another and how?

Please show me how. Thank you!

Qian

View 1 Replies View Related

Move Sql Database From Development Machine To Server With Active Directory

Dec 23, 2004

Hi all! I know I might sound stupid, but I have this problem. I have developed my database on my laptop which does not use Active directory. Lets say I access the database with: SPIDERMANDB1 on SQL server, where the name of my laptop is SPIDERMAN, and the database is DB1. Now, I create an SQL script from sql server and make the necessary changes, like changing the computer name to say, SUPERMAN where my deployment server's name is SUPERMAN. But when I run the SQL script on the SUPERMAN server, it gives me an error like: "User or role SUPERMANDB1 does not exist in this database". I have deployed databases in this way on servers without Acive directory, so I'm sure its not a mistake on my side. So how am I supposed to go around this active directory thingi! Please help me out! I'm counting on u guys!

Wes

View 4 Replies View Related

SQL Server 2014 :: How To Move AG Databases To New Location

Jun 27, 2015

I would like to move my AG databases to new location using C#.I found article on MSDN which uses SQLCmd utility to do that, but I cant run that utility from my application.I am looking for general steps OR T-SQL if possible so that I can follow the same from my C# application.

View 6 Replies View Related

How Do I Move My Database Schema From 1 Machine To Another? (generate Create Script Is Greyed Out)

Jan 15, 2005

how do I move my database schema from 1 machine to another? Its a MSDE 2000 DB and Im using visual studio 2003.

In VS when I goto the server explorer and right click on a DB the "generate create script" options is greyed out.

What am I doing wrong?

If you cant help me with the above question could you please recommend another way for me to get my DB schema with all its constraints from one of my work stations to another. I dont want to manually recreate it.

Thankyou

View 3 Replies View Related

Move Data Between Databases

May 18, 2008

hi, I currently uses SQL Server 2005.I need to move the data to my website, how do I do that? I have the SQL Server Management Studio Express but I couldn't not get it to export the data in .sql file (which is needed to import to my website's SQL database).Please let me know of any tools I need to perform the task. thanks.

View 3 Replies View Related

Move System Databases?

Apr 16, 2002

Hi,

I would like to move system databases (master, model, and tempdb) from one disk to another. What would be the best way to do it?

your help is appriciated.

Cheers

View 3 Replies View Related

How To Move Two Separate Databases Into One?

Nov 23, 2005

I have two databases with multiple tables. Same tables same fileds.Both databases contain records, but they should not match each other.(I will run a report for matches before this and delete any data thatis not current to ensure this is the case)How do I go about moving data from one of the databases to the other inorder to create a single database with all the data? Unfortunately mySQL is limited and I cannot image how I would work around the uniqueids. Append or update maybe?Thanks in advanceAndrew

View 1 Replies View Related

How Can I Move The System Databases?

Oct 26, 2005

I have been attempting to detach and reattach the model database. I tried to set the Trace Flag 3608, but it is having no effect.

View 17 Replies View Related

Move/Copy Table(s) Between Databases

Jul 8, 2005

I need to learn how to move or copy a couple of tables from one database to another. The tables are defined but contain no data.

View 2 Replies View Related

How To Backup/restore To Move Databases From One S

Nov 8, 2007

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.

View 7 Replies View Related

Move Databases On SQL 2000 Machines

Aug 19, 2006

I need to move our production database to a brand new machine on our LAN.Both machines are running SQL2K. I'd like to place the production databasein a directory on the destination machine with a slightly different pathname than the source SQL server.How can I shrink the transaction log to the minimum size before I try themove? What is the best way to move the database to the new machine? Wehave Veritus Backup Exec.Regards,Charles MacLean

View 1 Replies View Related

Help In Moving RS Databases To Another Machine

Jun 5, 2006

We plan on moving our sql 2000 db's to a sql server 2005 box this week.

What's the best way to point RS to the new database machine?

I'm not extremely familiar with Reporting Services and would like to know are there any "gotchas" in doing this?

Thanks

View 6 Replies View Related

Move Log Files For SQL 2005 Databases To Another Drive

Jan 24, 2008

Hello,

I need to move all log files for my SQL 2005 databases to another drive. I don't wish to shrink the files, I need to move the logs to another drive spindle. I did find an article (Article ID: 224071) that describes moving both the database and logs using sp_detach and then sp_attach. What is the best way just to move the logs to another drive on the same server, and that keeps the databases in their original location?
Thanks.

View 3 Replies View Related

Move Mdf Files For System Databases To Another Location

Mar 18, 2008

Hello there,
I've been told that it is good practice to keep mdf and ldf files in another location... We have it in place for all our user databases, however mdf and ldf files for our system dbs are still at the same location. I was wondering what is the right way of splitting those should be?

View 5 Replies View Related

Preventing Access To Databases Using The Machine Number

Jun 28, 2001

Hello,

Does anyone know how to prevent a certain machine from accessing SQL server? We have users who use a generic username and password (i.e. one login for 15 users) and I need to prevent a certain machine (in a high risk location) from hitting my databases. Any ideas

Thanks for your time and help

Gurmi

View 2 Replies View Related

One Package, Two Configurations, Mutiple Databases On Same Machine

Jun 14, 2007

Hi,

I have package on a single server. This packages extracts Data from System A and loads System B, database C. What I'd like to do is use configurations to have this one package loads System B, database C and D.

When a I create two configurations (one pointing at database C and one pointing at database D) and run the package only the last configuration pointing at database D gets loaded.

Anyone know how to get around this and use configurations to load both database C and D?

Thanks,

Mark

View 11 Replies View Related

Copying Database From 2000Server Machine To 2003 Server Machine

Jul 23, 2005

Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA

View 1 Replies View Related

GetDate() - From Server Machine Or Client Machine ?

Oct 23, 2006

Hi,

If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?

From "ServerMachine" or from "ClientMachine"

Thanks

View 3 Replies View Related

Ssis Package Hangs On Script Transformation When Running On One Machine Not Developing Machine

May 4, 2007

Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as

Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )

The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?

What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)

Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite

Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE

Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06

Thanks!

View 4 Replies View Related

SQL 2005 Enterprise Edition The Image File Setup.exe Is Valid, But Is For A Machine Type Other Than The Current Machine

Nov 28, 2006

Hi All,

I have enterprise version software CD1 and CD2 of SQL server 2005

when i try to run setup.exe..the following error pops -up

The image file Setup.exe is valid, but is for a machine type other than the current machine

MY OS version is windows 2003 32bit Operating system...

I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software

Thanks for your Help

Mohan

View 4 Replies View Related

Connection Pool Leak In Production Machine (in Other Machine It Runs Well)

Nov 16, 2006

Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.

View 2 Replies View Related

Running A Stored Proc On A Standalone Machine From Another Machine In A Domain

Oct 2, 2000

Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...

View 1 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008

Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from login:passw@machineb.dabatase.dbo.customers

thanks!

View 2 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008

View 6 Replies View Related

Migrating SQL 2005 Test Machine To New Machine

Jul 13, 2007

Hi Guys,

I was wondering if there was any white papers on the migration part from microsoft?
Apparently the situation is like this
Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.

Now, wanted to move this 2 temporary server into another 2 new servers.
Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.

So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?

It would be great if someone can show me the links to kb article. Thanks

View 1 Replies View Related

How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql

Aug 10, 2007

Hi,

We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.

When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?

Thanks.

View 1 Replies View Related

How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql?

Aug 10, 2007

View 5 Replies View Related

Move/copy Database Objects From SQL Server Express To SQL Server Standard??

Sep 7, 2006

Can anyone refer me to good 'recipes' or sources of information on thistopic??I have Visual Studio Tools for Office, which installs SS 2005 Expresslocally to my XP box, and I want to develop in SS 2005, then copy thetables or queries or reports etc. to a SS 2005 Standard server.Thank you, Tom

View 3 Replies View Related

Move Instance Off A Server With Hardware Problems SQL Server 2000 Sp4 ENT With Replication

Apr 2, 2008

We have a SQL Server 2000 ent edition sp4 with 3 small databases and one 4 GB database which is REPLICATED
The Server has been bouncing like a yoyo today because of a disk controller problem and I am preparing to move the Instance to a whole new server this afternoon. The new Server will have the same IP and name as the original server.

Any suggestions for the easiest or most seamless way to make this happen? preferably using Backup and Restore since they plan on taking the old server down completely and then building a new server with the same name and IP ... any suggestions would be appreciated.

View 1 Replies View Related

Move Job To Different Server

Sep 27, 2004

Thanks in advance!

I have several jobs (most scripted in activeX) that I need to move to a different server. Is there an easy way to "copy and paste" them from one server to the other? (SQL7 to SQL2k)

View 8 Replies View Related

Move Db To New Server

Sep 17, 2007

I have a db that I created on my local machine and need to move it to our server. The problem is that I created it with sql server 2005 express and our server is a sql server 2000 so restore and attach don't work. I don't have management studio (just express) so I don't know what I need to do to move it. Any help is appreciated.

Thanks

View 3 Replies View Related