Hello,
Can anyone tell me how to backup read-only databases? I want to backup
the secondary databases in my log shipping pairs.
Thanks,
TGru
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
ok when i upload my databases that i created in VS2005, they are read only.
so i though something was just funny, so i installed sql managment studio on the server and attached the databases, and when i attached them there grey with (READ-ONLY) displayed... how can i get my DB's out of read only! i tryied going through the properties of the DB through MSSQL managenet studio but that only generates an error...
any ideas!
We have a client with several databases in read-only mode. When we try and take the dbs out of read-only, we get the path to the mdf files may be incorrect, which they are not. SQL 2000, SP3a. Has anybody seen this? The files themselves are not read-only, I gave the network services account full control and still nothing. The issue started when the client lost power, lasst week, the dbs came up suspect. Detach/Attach brought them back up in single user.
Any hep is appreciated.
Hi,
About a month ago, a couple of our databases started up in read-only mode for some reason. I am the new DBA on the job, and the error logs from a month ago are not present.
I was wondering if anyone has had a problem where a SQLServer 7.0 database did this to them? We restart our DBs each day using scripts, so it is odd that this happens only intermittently (no one has seen a pattern at this point).
Any information would be muc appreciated!
Thanks,
Joe
Hi,
How can I provide a user read only access to all the databases on the server. I have 15 databases on the server. I know I can give db_datareader access in each database individually but that is time consuming and I have 10 servers for this to be done.
thanks in advance.
Hi,
I was reading that many of these high traffic websites actually have 2 databases, 1 database is used ONLY for reads, while the other is for writes.
How does one go about creating such a setup? How does the database where writes are allowed replicated the data to the read only database server?
We have several read-only nodes in our AlwaysOn cluster, which are set to use Synchronous-commit mode, which ensures that the logs are updated on the read-only nodes before any update statements complete. Even with this option, if we query a read-only node before the logs have been processed, we can read old data. I would like to know a strategy to ensure that a read-only query will definitely return up to date information. I had an idea that if I just used a different transaction type, like Serializable, that it might block the read-only query from actually getting the data until after the log file was processed, but I have not tried it, yet.
I would like to move more queries to the read-only nodes, in an effort to offload CPU utilization from the primary node.
hi all
right now , i am still learning how to use sql2005
is it possible if i want to read the backup data without restoring the backup database.? if it possible can you show me how to do it
cheers Arif
arifliminto86
Hello,I have:- server MS SQL MSDE (2000)- database 'COLLBASE'- table 'MAIN'- row: column 'NAME' value 'version' and column 'VALUE' value '003'I make backup files by SQL query.I have more backups for different versions of this database (differentvalue in field 'VALUE' in table 'MAIN').I would like to read this value from backup file without server assist,to get backup as ordinary file.How to do it?How to move in this file?What is physical structure of backup file?I can't to read this file from begin by compare strings, because thesefiles are very large, few 100MB.regardsZenek
View 5 Replies View RelatedIs there a way to read a backup file to see if it contains a file withoutrestoring the backup file? We are missing a record from a table, and I needto find out when it was deleted. We have nightly backup files of thedatabase. Is it possible, knowing the database name, the table name, and theprimary key value of the record, to determine if the record exists in acertain backup file? If not, is there an alternate way to determine when aparticular record was deleted?Thank you!Neil
View 2 Replies View RelatedI want to read certain data from the backup file of MS SQL 2000 without restoring the database backup file. Based on the data selected I will manage the further functionality such as restoration of the backup file.
Is it possible to read some data from MS SQL 2000 backup file without restoring? If yes then please let me know how?
is it possible to take the system databases backup to a location of another server.
(i.e ) shall we able to take a backup of the databases from server 1 and putting in server2
I know we can move the databases backup file , but above condition is not possible , but before working on this stuff i wamt to make sure.
I have this sp that backsup all our db and the master. I want the backup files to be put in D:sqlbackups. I get a return message stating that all the files were successfully backed up but only the master.bak shows and the other db files are no where to be found?!?(Processed 2000 pages for database 'master', file 'master' on file 1.
Processed 1 pages for database 'master', file 'mastlog' on file 1.
BACKUP DATABASE successfully processed 2001 pages in 0.121 seconds (135.413 MB/sec).
Processed 828272 pages for database 'MARS_SYS', file 'MARS_SYS_Data' on file 1.
Processed 1 pages for database 'MARS_SYS', file 'MARS_SYS_Log' on file 1.
BACKUP DATABASE successfully processed 828273 pages in 84.552 seconds (80.248 MB/sec).
Processed 148736 pages for database 'MSystem', file 'MSystem_Data' on file 1.
Processed 1 pages for database 'MSystem', file 'MSystem_Log' on file 1.)
Here is the sp:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER Procedure dbo.sp_BackupAllDatabases
AS
Declare @strDatabaseName nvarchar(254)
Declare @strDatabaseLoc nvarchar(254)
Declare @Path nvarchar(255)
Declare BackupList Cursor For
Select name from sysdatabases
where dbid > 6 or dbid = 1
Open BackupList
Fetch Next From BackupList into @strDatabaseName
SET @Path = 'D:SQLBACKUPS' + @strDatabaseName + '.bak'
While @@Fetch_Status = 0
Begin
BACKUP DATABASE@strDatabaseName
to disk = @Path with Init, Skip;
Fetch Next From BackupList Into @strDatabaseName
End
CLOSE BackupList
DEALLOCATE BackupList
return
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Hi
I'm trying to setup a back up plan for a number of databases, I initially set up one plan to include all user databases which worked fine or so I thought, when I check them a few days later I noticed that some of the databases were not appearing in the backup set, the only way I could get these to appear is to set the comp level to 90, now when we run certain applications we get an error, when I return the comp level back to 70 then the application works fine, is there a reason I can not back up any database on sql 2005 without it being a comp level 90?
Thanks inadvance
Hi - I use the windows scheduler to execute an SP for my SQL Express instance on a server.
The SP loops through the SQL Express databases, and makes a backup - however, it will only backup the attached databases.
Is there anyway I can modify it, to make it backup the databases in my various web sites, within the app_data folder? These aren't attached, but I think get attached when the web application needs them, then detached afterwards - so they are never permanently attached!
Thanks for any help,
Mark
The SP I use us:/**
File Name: BackupExpress.sql
Description: Backs up all databases. This script is mainly meant for SQL Express instances
The script requires a C:ackups directory by default to backup to but can be changed with the @OutputPath variable.
Accompanying file is BackupExpress.cmd, which is used to schedule the script.
Author: Brian Knight
DateChange DescriptionAuthor
8/15/2006Initial releaseBrian Knight
**/
SET QUOTED_IDENTIFIER OFF
USE master
GO
SET NOCOUNT ON
DECLARE @dayofweek varchar(20)
SELECT
@dayofweek = CASE datepart(dw, getdate())
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END
DECLARE @OutputPath varchar(500)
DECLARE @DatabaseBackupFile varchar(500)
DECLARE @FolderName varchar(25)
DECLARE @DatabaseName varchar(25)
DECLARE @strSQL varchar(2000)
DECLARE @hostname varchar(255)
SET @hostname = (select replace(convert(varchar(255),serverproperty('SERVERNAME')), '','_'))
SET @OutputPath = 'C:Backups'
DECLARE cur_Backup CURSOR FOR
select name from sysdatabases where name !='tempdb'
OPEN cur_Backup
-- Fetch the db names from Cursor
FETCH NEXT FROM cur_Backup INTO @DatabaseName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @DatabaseBackupFile = @OutputPath + '' + @hostname + '-' + @DatabaseName + '-' + @dayofweek + '.bak'
PRINT ''
PRINT ''
print @DatabaseBackupFile
SET @strSQL = 'BACKUP DATABASE '+@DatabaseName+' TO DISK = "'+ @DatabaseBackupFile+ '" WITH RETAINDAYS = 7, NOFORMAT, INIT, NAME = N''Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10'
PRINT @strSQL
PRINT ''
EXEC (@strSQL)
FETCH NEXT FROM cur_Backup INTO @DatabaseName
END
-- Distroy Cursor
CLOSE cur_Backup
DEALLOCATE cur_Backup
SET NOCOUNT OFF
I need to back up about 50 databases that are currently sitting on MARS. Every saturday they will be backuped so that they can be moved to HOMER
Pls help as I don't know where to start
BTW..I have also set up the SQL Maintenance wizared Backup procedure which copies to the local server but I want to be able to move the database files to HOMER (another server) so eventually they are backed up by TAPE
Any ideas
Emer
hi,
I have just started a new job and they have nightly backups of the master, msdb and model databases.
But why would you need a nightly backup of the model database? surely the model database never changes, so would a one time backup not be sufficient?
Please advise me if I am incorrect
Cheers
HelloI'm seeing the backup using SMO fails with big databases (>15GB). Ihave a 2GB database and I can see the command go thru. in Profiler butafter it's about 50-70% done, I get an exception saying backup failed.There is no details on the SQLServer log.Here's the code snippet:bk.Initialize = m_backupInit;bk.PercentCompleteNotification = 10;bk.PercentComplete += newPercentCompleteEventHandler(bk_PercentComplete);bk.SqlBackup(m_Server);Here's the command as captured by SQL-Profiler:BACKUP DATABASE [Test_MODEL] TO DISK = N'D:TempTest_Model_Backup.dat' WITH NOFORMAT, INIT, NOSKIP, REWIND,NOUNLOAD, STATS = 10Has anyone else seen this. The wierd thing is it works using old SQL-DMO.thanksSunit
View 1 Replies View RelatedHi,
I currently have 2 mirrored servers and would like to implement a backup solution using an existing TSM server. The first thing that comes to mind is using the TSM client or Litespeed by Quest, but I'd like to know the effects of performing backups on principal and mirrored servers first.
Will using one of these products cause errors or problems should the backup client try to backup a mirrored database? Can anyone make any recommendations on the effects of using TSM client or Litespeed for a mirrored environment?
Thanks.
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 RelatedHello , everybody
Is possible to set up server role to NT user in order to backup ONLY
any databases on server (nothing alse )
Now I am specifying this user as backup operator to each database
This NT account is domain account used to run Backup.exe software
Thank you
Hi All,
I have a requirement of migrating all databases from one server to another. I need to backup all SQL Server 2005 databases (both SQL and AS) with the exact replica copy. Also I need to migrate all the SSIS packages. Unfortunately I am not a Database/System Admin.
Is there any Script/Tool/Wizard Functionality that would help me doing this? I would be happy, even if you can help me reducing the parts of manual work in anyway you can think of, so please pour you thoughts in.
Thanking in Anticipation,
Jasraja
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.
Greetings all and thanks for reading this post.
Here is my situation... I have 2 fairly large databases. Full backups are 83gb & 63gb. I am in the process of moving these database to a new data center. I've taken full backups of these databases and shipped them to the new center. I have been taking transaction log backups (larger db every 24 hrs smaller db every 15 min ... from log shipping).
I want to restore these databases in the new data center. I've gone ahead and restored the dbs in the new location.
Question final cutover.. can I just apply the transaction logs to the databases on final cut-over or do I have to restore the database backup first then apply the transaction logs?
Is there an other way to do this that I'm missing?
Thanks.
Kurt
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 RelatedI 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 Relatedhow to backup and restore SQL Server databases using ssms in sql server 2012
View 2 Replies View RelatedHi,
I want to create two databases by restoring from a
single backup file in sql server. I am using 2005-sqlexpress .Is it possible?
Thanx in advance..
I am using alwayson on my SQL 2012 databases. I am using ola hallengren scripts for backing up databases. Full & diff db backups work fine, but the log is not getting backed up. The tran log backup job doesn't error out too. Trying to figure out what I may be missing?
View 10 Replies View RelatedI have a backup that contains multiple databases. I am restoring it to a different server. How do I restore each database? Tried to restore under SQL Server Management Studio, but can only restore one of many from the backup (it appears it has only 1 logical file name in the backup) If you can refer me to a web page that would be great. I tried googling the topic but nothing seems to come up.
View 5 Replies View Related
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 scheduler 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 scheduler 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.
I've got a couple of backup database tasks setup to run one after the other. The are set up the same, Alldatabases, backup to a device each, and overwrite every time. The task on databases full works fine but the one on logs fails every time, right away with the following rather esoteric error pulled from logging in the event log.
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 29/01/2008
Time: 09:54:11
User: OILCATSsqlservice
Computer: GUNKVBPROC
Description:
Event Name: OnError
Message: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter.
Operator: OILCATSSqlService
Source Name: Back Up Database Task 1
Source ID: {BF117128-FB4C-470D-AC00-4C68797C2C97}
Execution ID: {450BA60C-2EBF-453B-B3E4-80FBC2042F83}
Start Time: 29/01/2008 09:54:11
End Time: 29/01/2008 09:54:11
Data Code: -1073594108
What is this elusive Execute method that is only relevant to the log aspect of this task?
Hi, I've just been given the task of finding out how to implement a backup procedure for our SQL server databases. Most are running 2000, some 2005.
I'm a programmer, and I'm used to having a DBA to help me! I've seen a few methods on the web involving a stored procedure and running the task from task manager.
I need to backup and restore all the databases in SQL Server 2000 and work out a way of displaying whether or not it was successful.
Can anybody please point me in the right direction as I've no idea how to do any of this really. I guess if I could setup a sproc to loop through the databases that would help, but I'm not sure where to start.
Thanks in advance.