Use the Alter database modify file command (see BOL) or you can use the GUI, right click on the database, select properties, go to the files and just overwrite the...

Also -

you cannot run checkdb on a mirror database

yes a DR solution such as log shipping or mirroring is often paired with clustering which comes more under the heading...

this bit makes B the best answer - 'outages need to be made transparent to users'

with failover clustering, when the cluster does failover to another node, there is an outage...

you cannot backup a mirror database.

if this is a test database I would:

make the changes on the primary

set mirroring to synchronous mode (if not already)

failover. (alter database dbname set partner...

you cannot directly. If you have enterprise edition you could create a database sbapshot of it.

If you update the principal, it WILL get copied to the mirror.

see this thread as well, there are some links to msdn description of how SQL uses database files.

http://www.sqlservercentral.com/Forums/Topic950819-361-1.aspx#bm951048

round robin - one after the other then back to the beginning, so if 4 files, 1,2,3,4,1,2,3,4 etc.

One definite rule, only one log file because log files are sequential write...

azadsale (7/12/2010)

---

but if there are 4 data files and there is only one filegroup (primary).now if there is insertion going on.so the data will be divided between 4 files.i mean...

if you have multiple drives you would see an io improvement as data would be written to different files in parallel. Its like doing disk striping via the database physical...

No. Data for a non-partitioned table will be confined with a filegroup. You can split out nonclustered indexes to a different filegroup but you have to explicitly define that behavior...

Correct.

calling filegroups database partitions is not normal terminology and may cause confusion. Just think in terms of filegroups, partition schemas and functions.

no best practice as to no of filegroups. Maybe a primary plus one more to act as default group for user data.

If you decide at some point you need to...

So it looks the ideal is DBA + everything else under the sun.

no change there then.

🙂

If only 4GB physical RAM available all you can do is add the /3GB switch to the boot.ini file. No need to change max server memory setting.

If this is standard...

Robin Drury (7/9/2010)

---

I have an application that has moved to 2008-:w00t:R2 in the past few weeks. I was asked about setting the database up using Mirroring. So I...