Hi Owais,
Sequoia does not have specific support for SQL Server 2005. The backuper
was originally a contribution from Adam Fletcher back in 2006. If you
can find a set of commands that would work for backup/restore operation,
we could update the backuper code to support SQL Server 2005.
All contributions are welcome,
Emmanuel
I have 2 separate database machines (each containing SQL Server 2005
database). I need to save dump on the folder where other database machine
can access the dump. Storing dump locally will not solve the problem.
Secondly, is sequoia support SQL Server 2005 or onwards? As when I look into
the sequoia code, I found that it is using following SQL command to restore
Dump
"RESTORE DATABASE (DBNAME) FROM DISK = (Path)"
Now, when I ran the exact same query manually on my SQL Server 2005 Query
Browser, it is not working. Surely, this code needs to be reevaluated as far
as SQL Server is concerned. What do you think?
-Owais
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Emmanuel
Cecchet
Sent: Thursday, January 15, 2009 10:35 PM
To: Sequoia general mailing list
Subject: Re: [Sequoia] How to restore SQL Server 2005 database from the
backup dump.
Hi,
It's hard to tell and I don't have SQL Server 2005 to make any test.
There might be a path problem, the name resolution might not be working
properly. Try to use a local disk path rather than a network path for
the backup file name to see if that makes any difference.
Try to change in config/log4j.properties:
log4j.logger.org.continuent.sequoia.controller.backup=INFO,
Console,Filetrace
to
log4j.logger.org.continuent.sequoia.controller.backup=DEBUG,
Console,Filetrace
You should get more traces in log/full_cluster.log on what is happening.
Hope this helps,
Emmanuel
owais wrote:
I have 2 backend databases of SQL server 2005 attached to a single
controller. Now, when I am starting my sequoia controller, I want to
create backup from one of my backend database and by that backup I
want to restore my other database. I am using the following commands
Backup mssql1 init.bak MSSQLServer \\sequoia-server\backups
<file:///%5C%5Csequoia-server%5Cbackups>
Then for restore
Restore backend mssql2 init.bak
But this command is not working, its giving me the error that
operating system access is denied. My sequoia-server is a ubuntu
machine and I have given all access rights to my "backups" folder. But
why it is giving me this error.
Following is my Virtual Database file.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";>
<SEQUOIA>
<VirtualDatabase name="rubis">
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select" caseSensitive="false"
applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="MSSQLServer"
className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper"
options=""/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="sa" password="admin"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="sa" vPassword="admin"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="mssql1"
driver="net.sourceforge.jtds.jdbc.Driver"
driverPath="drivers/jtds-1.2.2.jar"
url="jdbc:jtds:sqlserver://DB1:1433/test2"
connectionTestStatement="select type from master.dbo.syscharsets">
<ConnectionManager vLogin="sa" rLogin="sa" rPassword="admin">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="mssql2"
driver="net.sourceforge.jtds.jdbc.Driver"
driverPath="drivers/jtds-1.2.2.jar"
url="jdbc:jtds:sqlserver://DB2:1433/test2"
connectionTestStatement="select type from master.dbo.syscharsets">
<ConnectionManager vLogin="sa" rLogin="sa" rPassword="admin">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<!-- <ResultCache granularity="table"/> -->
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog
driver="net.sourceforge.jtds.jdbc.Driver"
driverPath="drivers/jtds-1.2.2.jar"
url="jdbc:jtds:sqlserver://DB1:1433/test_recovery"
login="sa" password="admin">
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(20) NOT NULL"
sqlColumnType="TEXT NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECK_POINT"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(50) NOT NULL"
backendNameColumnType="VARCHAR(50) NOT NULL"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<DumpTable tableName="SEQUOIA_DUMP"
dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="DATETIME"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Can anyone please guide me what should I do.
-Regards
owais
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [email protected]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
