You probably need to understand more about how log file works and how to manage it. See this link.

http://www.sqlservercentral.com/articles/Administration/64582/%5B/URL%5D

I had configured cluster for auto...

Also, I understand it comes in a pack of 2, price of which should be 6874*2 = $13748

however I find sites which are selling for over 20k. Am I missing...

Thanks. I have asked my windows guy to give me a small quorum disk from the SAN or a third VM.. I will try the node+file share majority as well.

My setup has only 2 nodes so "Node Majority" quorum will not work (which is currently setup). The other type of quorum (node and disk) needs a shared disk...

Looks like...

Yes, the manual failover works but with the following warning.

The replica is on a WSFC node that does not have a quorum vote.

I manually failed over the availability group...

Thanks Grant. Yes the db is synchronized. Its a test db with no transaction. I was thinking about failover timeout n other aspects. I had setup a plain cluster using...

Yes the data and log files are on separate RAID arrays. There is no disk queue I would say right now (it was present while he was on SSD).

:sick: didnt read the question fully. Thought OP was importing...

keep ur db in bulk logged recovery and then use bcp. this will be faster.

begining 2005, log backups can run simultaneously with full backups. Full backups do not block log backups.

When you change the recovery model from simple to full (for renabling log shipping),...

in the server name enter this.

192.168.147.25,1455

Try connecting with the ip address of the server.

ip,port

i have created database of that backup...i can view my table and its data too..now i want to get data from here to my server table from where i have...

You cannot...