Ed,

I may not have worded the question very well. My only concern in this type of environment would be having applied a SQL upgrade to the current live box, the...

EdVassie (3/16/2009)

---

My old place used this approach, and it worked fine.

The full setup they had was:

1) Server 1 in DC1 in UK, all drives attached to SAN1

2) SAN 1 replicating...

You won't be able to prove which is better without hard figures, look into SQLio and SQLIOSIM to get stats on performance. Benchmark your current config, and then run tests...

Go ahead, put up some more of your cursor-based code, we'll keep doing it and then you can brag to your boss how you improved the performace of your system...

exam question? google 'rebuild 2005'

OK, this is untested but I believe it should work. I will try to find the time to test it soon but feel free to have a go yourself.

The reason...

making a copy of the system database files is something I do every time I Patch an instance and is the best workaraound for the situation you describe. doesn't seem...

cannot see any point in doing that, you may as well just do it properly and set up a cluster.

If you don't want the cost of a cluster then investigate...

I have changed the compatibility mode of the master database from 80 to 90 a few times with no problems, I am sure there are some new code features that...

there will always be log usage, all you can do is minimize it by batching up the copy into smaller transactions.

Once the log grows the first time the fact that...

for multiple files in a filegroup SQL adds data in a round robin fashion using proportional fill algorithms, i.e how much data is added to each file depends on how...

if doing it via configuration manager:

;-T1204;-T1222

add that to the end of current startup parameters. You should see the flags referred to in the errorlog when SQL is restarted

If you want...

Rudy Panigas (3/11/2009)

---

Hello everyone,

I believe this will make everyone happy and there is not coding involved. Just search for SQLScripter. A gentleman has create a neat application to script out...

another reason mirroring is seen as 'easier' is that microsoft included that claim in their marketing to encourage people to upgrade.......

or am I being cynical 🙂

have you set the security audit level to 'failure' for the instance? If not do so (will require a SQL restart I'm afraid). Look up the error 18456 messages in...