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:///\\sequoia-server\backups> 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
