Restore Databases Into A New Installation Of SQL Server

Jul 20, 2005

Hi,

I want to restore my databases from the old SQL Server installation
into a new installation of SQL Server. My new installation of SQL
Server has different data path from the old installation. In addition,
the data owners of some databases in the old SQL Server installation
are not dbo. I have backups for all the databases in the old
installation SQL Server.

Can anyone tell me how to restore my databases from the old SQL Server
installation into a new installation of SQL Server for my case? (I
want to use new path for data and log files as well as keep the old
data owners in the restored databases.) Do I need to perform restore
operation against my master database in the new installation of SQL
Server? (The data path for a newly created database has been changed
in the new installation of SQL Server.)

My idea is:
1. Create new databases whose names are the same with the databases of
the old SQL installation. Set the new databases with the new data path
I want.
2. Create new login accounts whose user names and passwords are the
same with the old login accounts. Assign appropriate permissions to
the new login accounts (e.g, the data owner for some database).
3. Use Enterprise Manager to perform restore operation against the
newly created databases using the backups from the old SQL Server
installation.

Please advice.

Hai-Chu

View 1 Replies

Restore A Complete SQL Server Installation Into A New Clean One

Oct 13, 1998

A customer is about to replace their PDC with SQL Server running on it.
MY companies role is to build the new server, and get their SQL Server running again.
I need to have the devices, databases, tables, data and the USERS copied across. I cannot use transfer manager as their will be only 1 instance of SQL Server running on the network.

If all we have is an NT backup is perfomed on the entire disk, i.e. the MSSQL/DATA directory.
How do we recreate the databases and their associated tables and also, how do we recreate the User accounts ?
Any ideas would be appreciated.

Please feel free to e-mail me with a response
NEILA@ANGLIABC.CO.UK

TIA

View 4 Replies View Related

Attach/restore Databases In SQL Server 2000

Jun 19, 2007

Hi,

I've got a question regarding attaching/restoring of DBs and wonder if anyone could help me out.

Does SQL Server 2000 provide a functionality to attach/restore DB automatically? ie, some kind of polling service to attach/restore DB that were detached previously?

Thanks

Danny.

View 6 Replies View Related

SQL Server 2008 :: Restore Number Of Databases Using Powershell

Aug 15, 2012

I have a new problem with doing a restore of a number of databases using powershell. The script I'm using is based mainly on this one (Part 2 in particular): [URL] .....

The problem I'm having is around the RedgateGetDatabaseName function. My hunch is that its down to the different version of red gate and how sqlbackup works. Basically when the call is made to the function it is returning both the Database Name and the number of row's that the SQL command in the function has ran. I've tried to include a SET NOCOUNT ON at the start of the SQL command in the function but its still returning the now count.

View 5 Replies View Related

Restore SQL Server Express Databases After A Disaster Recovery

Sep 15, 2006

Hello,

I would like to restore SQL Server Express and its databases from a tape backup to the same server. This is a disaster recovery senario.

I backed up the Master, Model, MSDB and my own test database using SQLCMD scripts. I have no problem restoring these using task manager on the server before the disaster recovery.

However, in my real disaster recovery testing, When the server is restored by tape drive (HP one button disaster recovery), I try to run my SQLCMD restore scripts in task manager and I cannot connect to the sql server. Also I cannot connect with Management studio. I have recieved the following error in event viewer.

----------------------------------------------------------------

Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 3411
Date: 9/15/2006
Time: 8:16:36 AM
User: N/A
Computer: COPLEYNEWS
Description:
Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.
Data:
0000: 53 0d 00 00 15 00 00 00 S.......
0008: 16 00 00 00 43 00 4f 00 ....C.O.
0010: 50 00 4c 00 45 00 59 00 P.L.E.Y.
0018: 4e 00 45 00 57 00 53 00 N.E.W.S.
0020: 5c 00 53 00 51 00 4c 00 .S.Q.L.
0028: 45 00 58 00 50 00 52 00 E.X.P.R.
0030: 45 00 53 00 53 00 00 00 E.S.S...
0038: 00 00 00 00 ....

Event Type: Warning
Event Source: SQLBrowser
Event Category: None
Event ID: 3
Date: 9/15/2006
Time: 8:16:36 AM
User: N/A
Computer: COPLEYNEWS
Description:
The configuration of the AdminConnectionTCP protocol in the SQL instance SQLEXPRESS is not valid.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 9/15/2006
Time: 8:16:36 AM
User: N/A
Computer: COPLEYNEWS
Description:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 3411.
C:Program FilesMicrosoft SQL Server90ToolsBinn>sqlcmd -S.SQLExpr
COPLEYNEWSDATABASEscriptsMASTERFULLRESTORE.sql"
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred whi
shing a connection to the server. When connecting to SQL Server 2005,
re may be caused by the fact that under the default settings SQL Serve
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

----------------------------------------------------------------------

My question is, what is the correct procedure to follow when I want to do a disaster recovery and restore SQL Server Express from tape backup using the Simple Backup method and scripts.

Is it always required to reinstall sql server express from the original program file or is it possible to reinstall from back up tape.

I know my backup and restore scripts work because I tested them on the server before I do the disaster recovery and rebuild that server from tape.

This is some kind of issue with SQL Server Express being restored by tape backup.

Any suggestions, thanks.

View 8 Replies View Related

Cant Restore SQL Server Databases: Exclusive Access Could Not Be Obtained

Jul 7, 2007

Hi everyone,

Hope somebody can help me on this.

I did a full BACKUP for two SQL databases using SQL Server Managament Studio. When trying to RESTORE the DBs, I get the following error:

"System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo)"

There are NO users using the application. These are DBs for the Portfolio Server 2007 application.

After exploring a little bit, I found that there are several "SLEEPING" processes with an "AWATING COMMAND" flag. The processes come from the Portfolio Server Application, maybe from previous sessions.

Can they be deleted? if so, would there be any serious consequences?

Thank you for your help on this.

Oscar E.

View 4 Replies View Related

Restore A Set Of Databases From A SQL2000 Server To A SQL2005 Server

Nov 3, 2006

I can restore databases one by one, setting .mdf and .ldf destination paths.

How can I restore all my Databases at the same time?

Thanks

G. Zanghi

View 7 Replies View Related

SQL Server 2008 :: Test Backup Restores (full And Log) - Restore Databases Automatically?

Apr 4, 2015

I am working towards automating the process of testing our backups. For the meantime, I do it all manually - I copy the backup files (full + transaction logs) to our test server and then run the restore script. Once database restored I run the DBCC CheckDB. The results of checkdb I manually upload to our Sharepoint portal as proof that the backup file is intact with no errors.

here are some ideas I have but have not yet tested:

Create a maintenance plan with each 3 jobs:

--> Powershell script to copy the files from Prod server to Test server - add this scrip to Job1
--> Powershell script to restore databases files - add this script to Job2
--> Run the DBCC in powershell (yet to find if possible in PS) - add this script to Job3

I would like to use seperate jobs as to get a report on the duration and status of each job

Would also like to get the results of the DBCC Checkdb as proof that no errors were found for upload to our Sharepoint portal. Dont know if possible via the job.

View 8 Replies View Related

Installation Of The Sample Databases

Mar 1, 2007

Hi

How do I install the sample databases Northwind and AdventureWorks?

I know there is a link on the Microsoft website, but does anyone know a step-by-step guide to actually get it on the database?

Thanks in advance!

View 2 Replies View Related

Restore Master Database After New Installation

Jul 11, 2001

Hi everyone,

HELP!

I was wondering if someone could help me. I need to re-install the SQL Server (due to a registry corruption). What I plan to do is to:

- Detach all databases (including master, pubs, and tempdb)
- Copy databases to a different folder
- Uninstall SQL Server
- Reinstall SQL Server
- Copy the databases back
- Reattach all databases

Will that preserver all the security? (e.g. syslogins and sysxlogins) Will using an old "master" database on a new install pose any problems?

Any help will be GREATLY appreciated. Please email me at vchai@artinmotion.com

Thanks,
Vincent Chai

View 3 Replies View Related

Restore Databases Under SQL 6.5

May 18, 2004

Hello,

I'm running SQL 6.5 on an old NT4 server. I built a new W2K server with SQL 6.5.

When I tried to restore a database to the new server I got the following error: "The database you are attempting to LOAD was DUMPed under a different sort order ID (52) than the one currently running on this server (32), and at least one of them is a non-binary sort order."
Since SQL 6.5 is no longer supported by Microsoft, I have a hard time finding information related to that error. Can someone help me and tell me what's wrong?

Regards,
Toan.

View 5 Replies View Related

Restore Databases 7.0

May 17, 2007

I have taken backups of 3 datbases

as

man1.dbf

msdb,model databases on drive d: but not taken master datbases then i had to format the c: on which sql server installed.

can i take full restore in this case or i have to create datbases and then sp_attach and sp_detach databases pls help me.

View 3 Replies View Related

Test Restore Databases

May 19, 2003

Hi all:-

I administer about 100 databases. I back them up to a file on the server hard drive everynight. Once a month I would like to test restore the backups . Due to the huge number of databases now its almost impossible to manually test restore them one by one so I came up with an automated script to do it. I have a database called testrestore and I restore each backup file to it get the count on certain crucial tables, throw it in a different table for later comparison and replace the database with the next backup file. I need to run this script on production, do you think its okay to test restore 100 databases one after the other using the 'replace' parameter ? Can it cause any memeory issues ? Is there any other way to test restore such a huge number of databases ? Suggestions are welcome.

Thanks.

View 2 Replies View Related

Restore Of Databases - URGENT

Sep 4, 2001

Hi all - I may be showing my ignorance here but I am in desparate need for some help on restoring my databases. Is there a way to restore/import/recreate a database directly from the .mdf/.ldf files. What has happened it that my hard drive containing my SQL data crashed and cannot be recovered. The only backup that I have of my SQL data is a direct copy of my entire DATA directory from the now ruined SQL install. I need to be able to restore those .mdf and .ldf files into a new instance of SQL. Is there a way to do this. Any help would be greatly appreciated.

Thanks,
Steve Mueller

View 6 Replies View Related

Help Me Restore Lost Databases! :(

Nov 6, 2007

Ok guys, I do a regular daily ntbackup of my entire server. I thought I had sql backups going daily but I think a admin password change stopped that and well those backups are a LONG time ago. The ntbackup is just 1 lost half day.

Windows crashed and had to be reinstalled, so I have all the files in the database folder and what I've done so far was reinstall windows, sql, and all that stuff so now windows is back up and going. I used sql admin and created the database ncdsm. Then I took the folder from the backup of the database for ncdsm and copied it to the new sql install (after stopping the service) and then turned it back on, and it shows that the tables do not exist, but it shows the list of tables in red.

How can I fix this and get all my databases back to normal? Thanks.

View 8 Replies View Related

Restore All System Databases

Feb 8, 2007

Hi All,

I need to do a restore of all my system databases, master, msdb and model, and of course my production database.

The Windows 2003 OS and Sql Server 2005 have both been reinstalled on the server.

I understand I need to be in Single User Mode to restore the master database and I just wanted to clarify the procedure for a successful restore.

I've found this page: http://msdn2.microsoft.com/en-us/library/ms190679.aspx which has instructions for restoring a master database.

So, all I have to do is:

1. Be in single user mode

2. Using SQLCMD run:
C:> sqlcmd
1> RESTORE DATABASE master FROM DISK = 'Z:MyBackLocationmaster.bak';
2> GO

From the instructions:
"After master is restored, the instance of SQL Server shuts down and terminates the sqlcmd process"

My Questions:
When I've restored the master do I repeat the steps above to restore the msdb and model databases?

Are there any other pitfalls?

Thanks for any advice

Melt

View 1 Replies View Related

Backup And Restore Databases In My MSDE

Jul 13, 2004

Hi all! How can i backup databases which are running in my MSDE 2000 & then how can i restore them with all the data, Yes i know that their is no visual tool for doing this in MSDE but can we do it with scripts, if Yes then how

View 1 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

Backup And Restore Analysis Service Databases

Apr 21, 2003

I am new to Analysis Services. Do I have to schedule backups for Analysis Services databases just like I do for SQL Server databases? or do I just need to backup the C:Program FilesMicrosoft analysis ServicesBinmsmdrep.mdb?? Please help. Thanks.

View 1 Replies View Related

Backup And Restore Analysis Service Databases

Apr 21, 2003

I am new to Analysis Services, do I have schedule Analysis Service database backup job just like I do for SQL Server databases? Or I just need to backup the C:Program FilesMicrosoft Analysis ServciesBinmsmdrep.mdb file. Thanks in advance.

View 6 Replies View Related

SQL 2012 :: How To Backup And Restore Databases Using SSMS

Jun 18, 2014

how to backup and restore SQL Server databases using ssms in sql server 2012

View 2 Replies View Related

Unable To Restore Databases From Tape: Timeout Exp

Jul 6, 2007

I'm trying to test my backups by restoring from production onto a DEV machine.

However, when I insert the backup tape into the drive, then go into SSMS and right click on
Databases -> Restore Database -> From Device .... -> Tape -> Add -> (my tape drive \.Tape0) -> Contents
it displays the contents as it should.

So I click "Close" to close the contents and bring me back to the Specify Backup where I have \.Tape0 selected and I then click "OK"
SSMS sits for a few seconds, and then I get a time out error message:

TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

That's all the further I can get... any suggestions?

I'm VERY perplexed by this...

View 2 Replies View Related

Transact SQL :: Stored Procedure To Determine Which Databases To Restore?

Sep 27, 2015

I have 5 databases that the user will chose which ones to restore. I was thinking the variable with the 5 database names separated by commas. I was thinking about using the CONTAIN function but two of the databases have the same name except for a few letters at the end.

View 3 Replies View Related

Restore SMK And System Databases (credentials And Linked Servers)

Apr 28, 2008

Hi there

I have a concern about restore whole SQL server environment.

1st server:

x86 SQL Server 2005 EE SP2 + hotfix 3159 is installed on Windows 2003 SP1 R2. SQL Server is running under Local System Account. Server is not part of AD.

2nd server

Win XP SP2, x86 SQL Server 2005 DE SP2 + hotfix 3159. SQL Server is running under Local Admin Account. Server is part of AD. Server has Credentials and linked servers

I'm trying to move all databases from server 2 to server 1

For this I am doing:

1) Create backup SMK

2) Detach all user databases

3) Backup all system databases

4) Copy all this stuff to server 1

5) Run Server 1 in single-mode (-m)

6) Restore master database

7) Try to restore backup SMK that was done on step 1 and get this error message:

Msg 15329, Level 16, State 11, Line 2
The current master key cannot be decrypted. If this is a database master key, you should attempt to open it in the session before performing this operation. The FORCE option can be used to ignore this error and continue the operation but the data encrypted by the old master key will be lost.

My understanding is that credential secrets, linked server login passwords are lost and should be recreated. DbMK can be restored using passwords.

As far as I know this can be avoided if the same domain account is using for both servers. But the question still this - if I have stand alone server, using local system account for the SQL Server service and have encrypted objects - I cannot restore SQL Server on another box (say in case disaster lost original one) without loosing credentials and linked servers even if I have all backups including backup of SMK.

Sounds gloomily for me. Any idea what I missed?

PS This links

http://blogs.msdn.com/lcris/archive/2005/09/23/473464.aspx

http://blogs.msdn.com/lcris/archive/2005/07/08/437048.aspx

http://blogs.msdn.com/lcris/archive/2005/09/30/475822.aspx

http://blogs.msdn.com/lcris/archive/2006/04/10/572678.aspx

and all relative topics in BOL were studied very carefully

Regards,

Gennadi

View 4 Replies View Related

SQL Server Admin 2014 :: How To Do System Restore To Previous Restore Point

Dec 31, 2014

In Windows Server 2012. How do I do a System Restore to a previous restore point?I need to install the 64 bit and 32 bit Oracle Client Install for connections in SSIS and to create Oracle Linked Servers.

If you make a mistake it is not fun removing it. Sometimes it corrupts the machine and it is difficult to uninstall since there is not an Oracle Universal installer for Oracle 11g.If you install the 32 bit before the 64 you mess up the machine.how to create a restore point.

View 6 Replies View Related

OLAP Services: Automating Archival/Restore Of OLAP Databases

Sep 19, 2000

Hello All,

Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.

--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220

Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com

"Once in a while you can get shown the light
in the strangest of places if you look at it right"

JG 1942-1995 RIP

View 1 Replies View Related

Unable To Restore Databases From Tape: Timeout Expired. The Timeout Period Elapsed Prior To Completion Of The Operation Or The

Jul 6, 2007

I'm trying to test my backups by restoring from production onto a DEV machine.

However, when I insert the backup tape into the drive, then go into SSMS and right click on

Databases -> Restore Database -> From Device .... -> Tape -> Add -> (my tape drive \.Tape0) -> Contents

it displays the contents as it should.

So I click "Close" to close the contents and bring me back to the Specify Backup where I have \.Tape0 selected and I then click "OK"

SSMS sits for a few seconds, and then I get a time out error message:

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

That's all the further I can get... any suggestions?

I'm VERY perplexed by this...

View 11 Replies View Related

SQL Tools :: How To Restore Multiple Databases From Multiple BAK Files At Once

Aug 14, 2012

I am trying to restore multiple .bak backup SQL database files onto a new server. However, I have found that it will not allow me to restore multiple databases at once. Is there a way to do this so that I do not have to manually upload one at a time? I tried adding all the .bak files at once to the backup device window but it only did the first one listed. It would be so much easier to restore them all at once so that I do not have to continue this manual process. I am restoring them via device.

View 13 Replies View Related

SQl Server 2005 Installation Is Depend On Installation Of Visual Studio 2005?

Oct 2, 2006

Hi every one,

I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.

I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .

View 11 Replies View Related

SQL Tools :: SSDT For VS2012 Installation Fails With (Same Architecture Installation) Error

Mar 9, 2013

The 6:th of march Sql server data tools for Visual Studio 2012 was released.

[URL]

I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).

why I'm getting this installation error.

View 14 Replies View Related

Error Installing SQL Server2000: A Previous Program Installation Created Pending File Operations On The Installation Machine

Oct 2, 2005

I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq

View 3 Replies View Related

MSDE Installation Fails Due To Detection Of Previous Installation

Jul 23, 2005

Please help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?

View 1 Replies View Related

Express Installation Fails With Invalid Installation Package

May 3, 2006

I get an error when trying to install the SQL Native Client. It
says it cannot find the installation package and to use a valid copy of
'sqlncli.msi'. I've downloaded the Express setup twice and get
the same error from both of them.

I'm attempting this in a VMWare session setup for Windows 2K, Advanced
Server. I am trying to test my installation and setup
procedures. This is not a production setup, just install testing
and documentation. I have allocated only 272MB to the VMWare
session, which is why the system doesn't meet the recommended settings.

Any help would be greatly appreciated.

Below is the Summary.txt output file.

Microsoft SQL Server 2005 9.00.2047.00

==============================

OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)

Time : Wed May 03 09:54:23 2006

CPCWIN2KVM1 : The current system does not meet recommended hardware
requirements for this SQL Server release. For detailed hardware
requirements, see the readme file or SQL Server Books Online.

Machine : CPCWIN2KVM1

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.2047.00

Install : Successful

Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLSupport_1.log

--------------------------------------------------------------------------------

Machine : CPCWIN2KVM1

Product : SQL Native Client

Error : An
installation package for the product Microsoft SQL Server Native Client
cannot be found. Try the installation again using a valid copy of the
installation package 'sqlncli.msi'.

--------------------------------------------------------------------------------

Machine : CPCWIN2KVM1

Product : Microsoft SQL Server Native Client

Product Version : 9.00.2047.00

Install : Failed

Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLNCLI_1.log

Last Action : InstallFinalize

Error String : An installation package for the
product Microsoft SQL Server Native Client cannot be found. Try the
installation again using a valid copy of the installation package
'sqlncli.msi'.

Error Number : 1706

--------------------------------------------------------------------------------

Machine : CPCWIN2KVM1

Product : Microsoft SQL Server VSS Writer

Product Version : 9.00.2047.00

Install : Successful

Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SqlWriter_1.log

--------------------------------------------------------------------------------

Machine : CPCWIN2KVM1

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_MSXML6_1.log

--------------------------------------------------------------------------------

View 4 Replies View Related