I don't advise to shrink data/log files on production boxes !

If sqlserver needs it, leave it that way ! so if you make an assesment of your space needs, you...

Last year at the SQLPass2007 conference there has been a pannel discussion regarding os virtualistion.

The conclusion in rough lines was:

- don't virtualise our db servers in a production environment

- virtualise...

No you're on 64bit.

In task manager, in the processes...

don't just move the binn, install, log,... because they are instance system resources.

To move data files, there are Ms KBs that describe the way to do it (userdb vs system...

you can download SQL2005 express edition at Microsoft download.

(keep in mind to download the sp2 version)

When running the setup, you should specify "kbmss" for instance name (according to your requirements)

also keep in mind, if SQLServer doesn't need memory, it will not use memory.

i.e. it may be your sqlserver only uses 150mb, if it decides it doesn't need more.

However...

I did interprete the line as "you can only mirror a database to a single mirror".

I'm still doing some tests with it, and didn't test the scenario you aim for.

What's...

An option is to have your spare server hosting two sqlinstances, so you can use db-mirroring.

Keep in mind you'll have to duplicate jobs, instance level user admin, ...

the docs:

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Johan

well, even with "copy" it gives you the choice :

1) use detach/attach mode

2) use SMO object mode

I just wanted to point to not using the first one.

btw I'm using a...

especialy after the first time you refresh statistics, always perform a free proccache so your plans are recompiled using the new statistics.

also take a snapshot of "missing indexes" (performance dashboard)...

So you have a split database ?? :ermm:

One part on node one and the other part on node two ??

This must be a very, very high trx volume db. :blink:

If...

just my 2ct

be carefull when using the copy database wizard, because in some scenario it will detach your production database briefly !!

It is better to use Yelenas methode of backup/restore.

Don't...

thank you for the feedback.

Glad you resolved the issue.

Can you post the tricky parameter(s) or odbc set ?

Ah, but you posted in a SQL2005 forum ... hence my reply.

for sql2000 I use this:

- sp_who2

- and the consumers :

if (object_id('tempdb..#tmpVerbruik') is null)

begin

-- tmptabelleke aanmaken

select min( @@Servername ) as...