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...

This is one way you can do it...

http://www.sqlservercentral.com/scripts/Miscellaneous/31032/

Off course the free MS "performance dashboard" is a good way of showing it.

and this may also be a good starting point.....

-- lists the top 50 statements by input/output usage....

Mike Martin (6/5/2008)

---

We are still having an issue with this. The interesting thing is when we eliminate the date range in the criteria, the datetime formats are different. ...

No.

You can only do that by composing dynamic sql. :crazy:

Please have a look at: The curse and blessings of dynamic SQL

http://www.sommarskog.se/dynamic_sql.html

- Keep in mind the concept of a primary key ! There must have been a reason to use this column for it ( or as part of it)

- Check...

Christopher G.S. Johnson (6/2/2008)

---

So, I didn't read these type posts before deleting the Builtin\Admin group. Now our third-party backup process is crying for failure to login as "NT Authority\SYSTEM"....

- for sure an active backup to that file will lock it.

- most of us tend to (x)copy the file to a safe zone at the end of the backup...