I am attaching my virtualdatabase xml file. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Emmanuel Cecchet Sent: Thursday, January 15, 2009 8:48 AM To: Sequoia general mailing list Subject: Re: [Sequoia] Problem restoring dump of SQL Server 2005 database
Hi, What backuper are you using? How did you define it in your virtual database config file? Thanks for your feedback, Emmanuel owais wrote: > > Hi, I am using two backend databases (both of MSSQL 2005) mssql1 and > mssql2. Now, when I am restoring mssql2 from mssql1 backup I am > getting the following exception > > "java.sqlSQLException: The backup set holds a backup of a database > other than the existing 'test2' database. > > I am using "jtds" driver > > Following is how I am taking backup > > Backup mssql1 init.bak MSSQLServer \\sequoia_server\backups\ > <file:///%5C%5Csequoia_server%5Cbackups%5C> > > ID > > Password > > Restore backend mssql2 init.bak > > Please help > > 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
<?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> <!--<Backup> <Backuper backuperName="mysql-backuper" 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="com.microsoft.sqlserver.jdbc.SQLServerDriver" driverPath="drivers/sqljdbc.jar" url="jdbc:sqlserver://192.168.1.119:1433;databaseName=test" connectionTestStatement="select 1"> <DatabaseSchema dynamicPrecision="table"/> <ConnectionManager vLogin="sa" rLogin="sa" rPassword="admin"> <VariablePoolConnectionManager initPoolSize="20" minPoolSize="5" maxPoolSize="0" idleTimeout="180" waitTimeout="0"/> </ConnectionManager> </DatabaseBackend> --> <DatabaseBackend name="mssql1" driver="net.sourceforge.jtds.jdbc.Driver" driverPath="drivers/jtds-1.2.2.jar" url="jdbc:jtds:sqlserver://192.168.1.119:1433/test" 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://192.168.1.119: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="mysql2" driver="org.gjt.mm.mysql.Driver" url="jdbc:mysql://192.168.1.116:3306/test_2" connectionTestStatement="select 1"> <DatabaseSchema dynamicPrecision="table"/> <ConnectionManager vLogin="user" rLogin="root" rPassword="admin"> <VariablePoolConnectionManager initPoolSize="20" minPoolSize="5" maxPoolSize="0" idleTimeout="180" waitTimeout="0"/> </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://192.168.1.119: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>
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
