mic.con87 (12/6/2011)

---

Quick question: Can I mark this question as answered and add to the reputation of those that helped?

ChrisM@Work (12/6/2011)

---

Cool, thanks for the feedback. I learned the trick from an article Lowell did years ago 😀 Thanks, Lowell.

Dev (12/5/2011)

---

It sounds OK. Just make sure once you enable jobs they restore the backups in proper sequence (without breaking the chain).

MSBI Learner (12/6/2011)

---

Thank you Dev, could you please help me on how do I implement the same?

DECLARE RM_CURSOR CURSOR FOR

SELECT D.id,D.PeriodDesc,D.StartDate,D.EndDate

FROM #DateRanges D

ORDER BY D.id

OPEN RM_CURSOR

FETCH NEXT FROM RM_CURSOR INTO @id,@PeriodDesc,@StartDate,@EndDate

WHILE @@FETCH_STATUS = 0

BEGIN

Is it related to performance Tuning and Data overloaded error ???

ns22boss (12/6/2011)

---

Here is the connection details

Connection con = new Connection();

con.setDbHost("10.60.1.50");

con.setDriverName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

con.setDbName("QATESTDB");

con.setDbUser("sa");

con.setDbPassword("pa$$word");

con.setDbPort(1433);

con.setConnString(ConnectionAction.formConnectionString(con

.getDriverName(), con.getDbHost() + ":" + con.getDbPort(),

con.getDbName()));

ConnectionDetails conAlias = new ConnectionDetails(con

.getDriverName(), con.getConnString(), con.getDbUser(), con

.getDbPassword());

return conAlias;