*yawn* now we've all finished slagging off MS, their products and their Gold partners can we move onto something else. A lot of the people in this thread doubtless earn...

when the database is in full recovery model and you delete a log file, it will still list in sys.database_files and sys.master_files.

You must take a transaction log backup and the...

what is the recovery model of your database?

make you sure you get all the pre reqs in place as SQL Server 2008 requires a handful of hotfixes etc to install before installing SQL Server itself.

Any reason why...

it is the port that sql server would listen on for all IPs assigned to the server

Get SQLIO out and push the storage to see what you can and cant get out of it. this forms the base of what you can provide performance wise

sjs-36273 (1/10/2012)

---

One solution I am thinking of is using a third party backup tool to get the backup to be smaller due to connection constraint between the two sites. ...

shijimon.jacob (1/10/2012)

---

Thanks for your feedback.

Just to claryfy

Clustered Instance_1 on Node A and Clustered Instance_2 on Node B and the failover would be between them.

Clustered Instance_3 on Node C and Clustered...

yep, saw that after i'd posted 😀

accessible for which accounts?

are your sql server servcies running under domain or local accounts?

This has SSMS Express download and install this

Execute the following against your SQL server instance to find the default trace path\file name

select value AS DefTracePath from fn_trace_getinfo(1) where property =...

the scenario above is perfectly valid

instance 1 is installed...

Minaz Amin (1/9/2012)

---

Hi,

Please do let me know the pre req for configuration of active /active cluster.

We are planning to have 2-node active/active cluster with two separate instance running on both...

what quorum type are you using disk or MNS