Thanks everyone - I got it, We can do.

It says, Database Mirroring is not supported by ODBC 11.0

Please refer the link http://technet.microsoft.com/en-us/library/hh568445(v=sql.110).aspx

Thank you for your immediate response! It is Redhat.

Linux 2.6.32

ODBC 2.3.0

Thank you Perry, Don and Grant! Your inputs are so helpful, I am doing that.

Once again Thank you so much for your help.

[/quote]

Are the windows disks where the sql server data and backups stored coming from a Storage area network or are they locally attached drives[/quote]

They are SAN drives! Not local drives.

Perry Whittle (11/11/2014)

---

is server B a virtual machine?

Yes all are Virtual machines only in my Environment. Absolutely there is no physical servers.

what is the back end storage configuration for Server...

I have found some interesting stuff related to my requirements in the following link...

http://www.mssqltips.com/sqlservertip/2654/using-ascmd-to-run-command-line-scripts-for-sql-server-analysis-services/

Hi Bob & Keon, Thank you so much for your valuable solutions. I'll try either one of them. Btw, SSIS is installed on that server. That only SSIS and SSAS...

Thank you Whittle!

Microsoft suggested solution:

-Create new 4.8TB, convert this right away to “GPT disk” during first disk initialization at Windows 2008 R2 (assign as temporal drive letter say “X”)

-Shutdown database

-Robocopy the existing...

Hi - Start a new thread to post your questions!

GilaMonster (7/24/2013)

---

5+1? That's a very unusual RAID type. Don't think it would be that good for TempDB, 10 would be better, 5+1 would still have the write overhead from the...

I don't know how many array controllers! Regarding RAID - you are correct!! All the DBs are (including tempdb) in RAID 5+1 only.

Some connection is using the database. This is nothing to do with cluster. Find out the connection and disconnect it. To restore a database on the existing database, it requires...