The 5 tables I gave were just an example, the system I am working on is very normalized. I will create a test script and send it shortly. Thank you.

Two things: As I mentioned, first go to C drive and type c:\>cluster group to see all the nodes connected to your cluster. This command only LIST groups, it does...

I don't have a Always ON failover, but from what I have I can expand services. Right click on the service I need to failover to, and it gives a...

If you want to move a cluster group manually from C drive, use below:

Please note SQL3 would be the destination node, SQL1 (cluster group) is your source.

c:\>cluster group

Listing status for...

Yes, thank you Gail.. You are the best..

Never mind, I fixed it.. Thank you for the clarification, I declared the values as decimal... That I was not clear about, thank you.

Thank you both. So how you correct the query to print 1.9?

hi Gail -

Sorry, one correction... I just realized that the user wanted to get the actual decimal result, in this case the result should print 1.9.

declare @val1 int

declare @val2 int

declare...

Sean -

Thank you for the quick reply and big help.

Yes, thanks. I initially was worried about the system files but things went smooth. We started by 1) putting resources offline 2) backup files and copying them else where 3)...

never mind, I was not searching correctly for how to implement it. There are many articles out there:

http://www.sqlservercentral.com/Forums/Topic1058329-5-1.aspx

I just made backups, put sql server cluster resources offline....

Nothing is virtual, it is all physical drives.

All I need is to know exactly the steps to migrate all the data and log files (system and user data and...

I have node 1 and node 2 (physical boxes) attached to SAN. All data and log files are stored on SAN LUNS, but the temp files stored on the local...

Gail, thank you.

Gail, thank you... How about temp files in SQL 2008?