Presuming here you still want all 3 databases on the same server.

Performance wise it is probably only going to help if you put each database on a different drive.

availability wise...

Cannot remember details (its probably in BOL) but each page has a header as well at least taking up bytes, so the 8th row did not fit and went onto...

not aware of a definitive recommendation from MS, but all the info I have ever seen suggests small, about 500MB - 1GB. not much point going really small.

Never had a...

sqlbuddy123 (8/27/2010)

---

Hi DMarvez,

Actuall after the Server Rename and SQL Rename you need to...

CirquedeSQLeil (8/27/2010)

---

Steve Jones - Editor (8/27/2010)

---

AFAIR, Incrementals haven't been a part of SQL Server. Perhaps in v4.2, can't remember that far, but I think it was always diff in SQL,...

SQL has never had Incremental backups in the sense most people think it means, those are differentials. I think you will find they are using a confusing term to describe...

To make the failover automatic you need to be using the latest access components, i.e. as Perry said SNAC. check BOL and msdn for details on this.

You would also need...

this would be the normal practice.

sys.dm_tran_locks is one of the new dynamic management views that came in with SQL2005 and allow you to extract information about what is going on within the SQL engine. It...

@rem70rem

what happened here in the end? was any of the above useful?

ricnav (8/20/2010)

---

Hi George, I was rounding up to GB units. Here are the actual numbers, with their actual units:

Windows File Manager:

mdf file 575,784,960 KB

The results of sp_spaceused are:

database_size: 771,292...

You say 'The db file is 575 GB. The GUI tells me that currently allocated space is 771 GB and available space is 205 GB (26%). The drive has a...

try a shrink with the truncateonly option first to get back some space with minimum resource usage (might not get any back but worth a try) and then do the...

bbaird_1945 (8/19/2010)

---

We also change our SA passwords on all servers. Keep in mind you need to restart the SQL Service when you do. On a cluster you can...

All available from cluster admin tool under administrative tools