Here

STEP-BY-STEP DATABASE MIRRORING[/url]

Robin Back has a script for that.

http://www.sqlservercentral.com/scripts/Miscellaneous/30871/%5B/url%5D

Here is a link with step by step instructions and images.

That of course depends on size of your database/transaction and how much data are you willing to lose in case you lose primary server.

With synchronous mirroring, the primary server does...

Graham_Day (1/24/2011)

---

I am investigating whether an intermittant "connection failed" error in an SSIS task step could be a result of interaction between the SynAttackProtect setting (on) and SQL Server.

A Microsoft...

DKG-967908 (1/11/2011)

---

Thanks Adiga and Alex for your response, Adiga that script is good but not solving my purpose 🙁 .

Alex there must be some way to get a value from...

DKG-967908 (1/11/2011)

---

Hi All,

I have created a stored procedure with a int parameter - if user passes 0 it will stop a particular job and disable it (as per users requirement)...

It's a network/socket error.

Here is how to troubleshoot it:

kb325487

Do you get the error when running the script from the server?

jishar (12/19/2010)

---

Hi All,

Due to some requirement we want to change the domain of Sql Server 2005 Cluster System.

What are the best practise for these tasks without effecting the database which...

can you paste your syntax?

AlexSQLForums (12/15/2010)

---

On those two blades I would setup 2 ESX or ESXi hosts in High Availability mode with SAN/NAS storage.

But make sure you setup > 2GB trunk (depends on the...

On those two blades I would setup 2 ESX or ESXi hosts in High Availability mode with SAN/NAS storage.

But make sure you setup > 2GB trunk (depends on the volume...

syscomments

right click "my computer" select properties.

go to Advanced tab select "Environment Variables"

In "User variable for yourlogin" click edit on TEMP and change to D drive location.

restart SSMS.

Thank you.

I was able to recover needed data by creating a different db with same size and replacing the mdf file and than using emergency mode and running dbcc...