public boolean backupIRMS()
	{		
		boolean stored = false;
		String query = "ALTER DATABASE SYSTEM SET RECOVERY {SIMPLE};";
		String query2 = "BACKUP LOG { IRMS } TO DISK= 'C:Documents and Settings\user\Desktop\system_backup\systembackuplog.bak'";
		String query3 = "BACKUP DATABASE (irms ) TO 'C:\Documents and Settings\user\Desktop\system_backup\systembackup.bak WITH DIFFERENTIAL'";

		try
		{   
			DBConnect db = new DBConnect(); 
			db.openCon();
			db.execute(query);
			db.execute(query2);
			db.execute(query3);
			db.closeCon(); 
			stored = true;
		}
		catch (Exception ex)
		{
			System.out.println("Error on Execution: " + ex);
		}
		
		return stored;
	}

quote:

---

Originally posted by jen

why don't you create an sp for the queries and call that in your application?

atleast you'll get error messages in the sp when compiling , check { } and ( ) in your text.

--------------------
keeping it simple...

---