bsegermeister (9/8/2011)

---

Also, since we are going to present the new SAN to the Cluster through iSCSI I was thinking about puting 2 NIC's in each of my server nodes and...

sqlguy-736318 (9/8/2011)

---

I guess I should ask the following general question to those with more dba experience than myself. If I set up a database with SQL Server authentication then should...

sqlguy-736318 (9/8/2011)

---

It seems like I may need to add the network user ID's of the other users somewhere on the remote machine so they can access the remote database through...

Does the remote server have a firewall running?

Go into SQL server configuration manager on the remote server and check the protocols enabled.

Sounds good to me

In the last 7 years i've used either Litespeed or SQLBackup and they're both good, although SQLBackup would be my preference.

Andrew Notarian (9/8/2011)

---

Is there any reason we might not want to use the offline detach at old server /re-attach at new new server method of migrating from SQL 2000 to...

how many nodes form the base windows cluster?

my 3 part guide details all. See the first part at this link[/url]

how are your backups currently taken through litespeed, litespeed maintenance...

For me, backing up across a network is just asking for trouble. I prefer local then mirroring out as necessary

ALZDBA (9/8/2011)

---

SpringTownDBA (9/7/2011)

---

short answer:

DB1, min 6-7 GB, unlimited max

DB2, min 3-4 GB, unlimited max

as it is currently configured, you have 40 GB of ram and only 18 GB can...

What command are you using to change the timeout?

What does this return when run against the principal

select db_name(database_id),

mirroring_connection_timeout...

What storage mediums are you using?

Local disks, San, etc

I bulk copy the syslogins table to a file and transfer to my DR server. On the dr box I import to a temp table and where the user in...