facing problem in taking SQL Server 2005 database backup--regarding

[Abhishek Reddy]

Iam getting the following exception
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot perform a backup or restore operation within a transaction.

Query:
String backupQuery="BACKUP DATABASE jiffy TO disk=?";

Iam using hibernate for database transactions:

tx =session.beginTransaction();


SQLQuery selectQuery=session.createSQLQuery(backupQuery);
selectQuery.setString(0, path);
selectQuery.executeUpdate();

tx.commit();

[Paul Sturrock]

DDL is non-transactional. Do as the error message tells you and run it outside a transaction.

[Sagar Rohankar]

The exception says, it can't perform backup operation in transaction, so had you tried removing the "transaction" specific statement, like beginTransaction and commit and re running ?

[ujjwal soni]

Hi,

The problem is that your code opens a transaction and then

try to execute the backup command. See the error message. You need to make the jdbc API not open a

transaction for you. How you do that, I don't know, it would be a jdbc issue, Perhaps in the

connection string, perhaps by using some other function calls in jdbc.

Cheers!!!