ananda.murugesan (9/17/2012)

---

Hi,

Principal server mirroring monitor history logs (intervel time every 3 min)

Unsent Log 7588 KB

unrestored log 600 KB

Mirror over head - 40 Milliseconds

Next intervel time those are 0 kb, 0...

If you don't want to write your own scripts, there are many available on Google and on this site. Search a little 😉

no you dont. You take a tail backup of the primary...

First check the windows firewall and ensure it is completely disabled, the firewall has 3 profiles. Best thing is to stop the service and set it to manual.

Can you provide more detailed info on how the virtual environmment is setup?

Can you post details of the odbc connection steps too?

SQLCrazyCertified (9/14/2012)

---

Perry Whittle (9/13/2012)

---

John Mitchell-245523 (9/13/2012)

---

I would recommend backing up the databases first, in case the worst happens, which it has done for me before. Given that you have...

i use a simple vb script, works for me

scogeb (9/13/2012)

---

Another post got me thinking, so I figured I should post....

What do you think about SAN LUNs? My storage guys here just gives me LUNs for each SQL...

😉

alanspeckman (9/13/2012)

---

If we have 2 resource groups

1. MS-DTC

2. SQL Server

And the MSDTC resources lyes on Node A, and the SQL Server resources(disks, IP, SQL Server, Agent) lye on Node B,...

go to the MCP site and check the regs there. Microsoft have very strict regs about the size and placement of the logo on letterheads and CVs

For details of how a diff resumes an LS plan see the start of my article at this link

Humble pie anyone?????????? 😉

For the future, bear...

the worst thing thats likely to happen is you type the wrong path\filename in the alter command. If you do then just re issue the correct command and the database...

John Mitchell-245523 (9/13/2012)

---

I would recommend backing up the databases first, in case the worst happens, which it has done for me before. Given that you have taken a backup,...