Hello , 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
Hey guys. I'll have an active/active cluster and seperate accounts for SQL Services and Cluster service. The question is what rights should the cluster account have in SQL if I've removed the 'builtin admins' from SQL? Thank you
I'm creating one of my first asp.net pages, and it accesses an MS SQL database.It runs fine locally, but if you go to it remotely through a web browser, you get an exception saying that the database login failed for user ASPNET.My brother told me to do the following in SQL Server Managment studio. It seems I don't have that program installed, so I did it from the SQL command prompt.CREATE LOGIN [bigblueASPNET] FROM WINDOWSuse AdventureWorkscreate user [bigblueASPNET](Where "bigblue" is the computer name and "AdventureWorks" is the database my asp.net web page reads from).This only partially fixed the problem - now when you open the page remotely and try to access the DB I get an error message saying that permission to use the SELECT command is denied.I searched on these forums, and found this:http://forums.asp.net/69166/ShowPost.aspxFor future reference, let's call what my brother told me "Method 1" and what the previous poster did as "Method 2."I haven't tried method 2 because I don't know exactly what I am giving ASPNET permission to do. Does method 2 enable ASPNET to do anything to any database? It seems method 1 is more secure, as from the commands I could already tell it only has permission to access AdventureWorks.So, I'd prefer to use method 1. Can anyone tell me what further commands I can use to give ASPNET permission to do specific actions?If I can't figure out method 1 and have to do method 2, how can I undo what I did in method 1?Thanks!
View 1 Replies View RelatedHey guys. I've an application which uses an account named Uaccount1. I've given it db_datareader and db_datawriter permissions to the tables. I've given it execute permissions to all sp's I've given it reference permissions to the symmetric key. And I gave it reference permissions on the certificate. At this point, it can't see the certificate. If I give control permission to the account for the certificate, it works perfect. Is it necessary to do that or am I missing something. Our security is based on symmetric key and certificates...
Thank you
Tej.
Hello All,
I have multiple SQL Server 2000 databases all identical in structure (Company1.mdf, Company2.mdf, Company3.mdf). I have a situation where while connected to Company1, i want to create a record in Table1 and have that same record automatically be created within Company2 and Company3.
If i was working with MSAccess, i could use linked tables where i would link Company2 and Company3 to Company1 Table1. This way if any changes are made, all three companies and working from the same record set.
My situation deals with mutiple tables that need to be in line with each other across mutliple databases.
Your suggestions are appreciated.
Thanks
I'm using SQL Server Management Studio eExpress and I'm tryng to link to a database created in Visual Web Developer Express. My problem is that I can't see large parts of my file system when I try to attach a database in SQL Server Express. Web Developer Express likes to put its databases in C:Documents and Settings<User Name>My DocumentsVisual Studio 2005WebSites<Site Name>App_Data. However, when I try to attach a database in that location to SQL Server Express (Right Click Databases node, select Attach from the shortcut menu then Add from the Attach Databases dialog) I get a folder tree that won’t let me go any further than C:Documents and Settings<User Name>. There seem to be large parts of my folder structure that I cannot access with this dialog.
Just in case this is a permissions issue, I am using Windows XP Pro on a stand alone machine. I log on as Administrator, and the <User Name> in the above paths is Administrator. The Administrator is a member of the Administrators group. I have never logged on as anything else and never made any changes to the way permissions are set. When I start SQL Server express I select Windows Authentication.
TIA
I am getting the error:
Cannot open database "aspnetdb" requested by the login. The login failed.
When I browse to my ASP.NET 3.5 LINQ web application on the IIS 6.0 server on Server 2003.
I imagine this is because while I granted SQL Server 2005 login and permissions to my database that the application stores its data in, I did NOT grant any rights to the service account the IIS Application Pool uses for its identity to the aspnetdb database on SQL Server which is where all my roles information is stored at.
My question is what are the MINIMUM permissions needed for this database so it can perform its roles related functions?
I'm using Windows Authentications with the SQL Role provider for authorization.
Thank you.
EDIT: I think I only need to open the aspnetdb database and add my login to the aspnet_Roles_FullAccess role. Is that correct?
I have a scheduled job to perform exports of SQL databases to a file share. The file share is setup so everyone can write to it but only the AD account 'SQL.Bkup' can delete. I have setup SQL Server Agent to use this ID when performing backups but the backups fail each time when trying to delete old backup versions.
I have logged into this id (SQL.Bkup) and can delete files on that share without a problem.
Is there some thing I need to setup differently to get the backup process tol run with the correct authority?
Thanks,
Ken Nicholson
During install of SQL Server 2005, we can of course use a domain account or the built-in system account for running the services. I lean toward domain for obvious reaons but would like to know a +/- to each option and why I'd choose one over the other and what consequences or limitations one may encounter if I choose one over the other.
View 6 Replies View Related
Hi,
If we were to assign permissions to a backup agent such as Backup Exec to backup the databases on the SQL server, what role would give the least amount but sufficient permissions to perform the backup? I know domain admin would make the agent a local admin and therefore allow it to back up the database but is there a role available to allow backup only?
Please note that I'm referring to a domain account used by Backup Exec to directly backup the databases rather than sql server agent.
Thanks.
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
Hello,Can anyone tell me how to backup read-only databases? I want to backupthe 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!
View 6 Replies View RelatedHelloI'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 RelatedHi 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?
I have been running a script in SQL Server 2000 as sa also as a Active Directory user who has administrator rights (I tested both approaches SQL Server then Windows Authentication) in Query Analyser which grants execute rights to the stored procedures within the database instance and Query Analyser does not give any errors when I run the script. I have made sure that each transaction has a go after it. I then return to Enterprise Manager, check the rights (I apply them to roles so that when we create another SQL Server user we just grant him/her rights to the role) and discover that the role has not been granted the rights. I seems to be occurring only with 2 of the procedures. Is there a known bug that might be causing this?
yours sincerely
Craig Hoy
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.