sql-lover (12/3/2012)

---

Hi,

I'm having a hard time to convince IT team that we don't need so many NICs in a dedicated SQL cluster. Besides SAN, I usually use two NICs only,...

It's now WSFC and it is indeed part of the Windows 2008 server Enterprise and Datacenter editions.

Not at all, I've never had an issue with the backup converter

The easiest...

What are the size details for the log currently?

Do you have any long running transactions?

Check this and this

What size is...

if your database is using the full or bulk logged recovery model take a transaction log backup using the following

BACKUP LOG [MYDB] TO DISK = 'some drive\some path\mydb.trn'

shohelr2003 (12/3/2012)

---

I configured mirroring with High safety with automatic failover (synchronous) option.

Now I want to change my operating mode to High Performance (Asynchronous) but getting all options disabled.

How can I...

You can just obtain the max id value after toe deletion by using

select max(col_id) from table_name

Then use this to determine the reseed value.

cracked it have you? 😉

You must ensure that while no cluster is formed that the 2 nodes do not try to access the disks at once otherwise corruption occurs. Simply hold off exposing the...

yes, the log backups taken by the LS...

This

selectobject_name(object_id) AS TableName

from sys.columns

where object_name(object_id) like '%table name string%'

group...

Your post isn't clear but here goes

if you have a log shipping plan in action, ensure that the only transaction log backups are taken by the log shipping backup job...