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
