Thanks for the response..i will look into the log shipping option.

would there be a need for an additional license for the active node sql installation?

Thanks!

Is you current Cluster an Active Active or Active Passive?

How about the new node that you want to add? Will it be an Active node or Passive node?

If it is...

1.Depending on the company Policy, it is better to have an approval from the management for any such change.

2. Always have a Rollback plan handy.

3. Backup and restore works...

Thanks for the reply. I was able to connect to the Cache as well as destination database. I had to use the ADO.Net source task to view my source data....

I created a connection manager using ADO.Net connection. When I use the ADO.Net source to read the data, it does not show anything.

In the source I am able to view...

Ok Jason: Do they never complain of blocking issues?

Thanks!!

In the worst possible case,lets assume that the 90,000 Select *'s are required. In that case will not be feasible to run them as Stored Procs rather than inline sql's..just...

A best practice is to be on a Build version that has been tested to be more stable like SP4 for SQL 2000 or SP2 for 2005 ( I believe...

I am assuming this is the Full backup schedule. What about the transaction log backups?

For...

I normally prefer mm/dd/yyyy way but most of the date fields here at my current job are varchar as 'yyyymmdd' and sometimes I get to work with real datetime fields..

Thanks!!

CallEntry is a datetime field..but all the previous scripts on this topic couldn't fetch the result set.

Till now I had an inline as below

select * from CallerDetail

where CallEntry between...

Wow Lynn this works like a charm..just that I had to take out the -1 and make it a zero as I want to run this the same day..

But this...

Today I am trying to run this query for today..

I want to hard code the time but the date should be retrieved from getdate().

The field takes input as mm/dd/yyyy...

Well thanks for the above script but heres the thing...

I am getting the output as 2009-03-04 07:00:00.000

but my callentry gives me empty data with the above result set

for it to...

Thanks Dugi..the script runs well but the CallEntry input needs to have the day also in the format m/dd/yyyy hh:mm:ss to be able to return the correct records where...