We also have an off site facility hosting the same database (replicating to and from) and the same backup routine on this server takes just 10 minutes, so clearly a...

Thats the trouble - It's backing up locally!

Actually I fibbed a bit. There are also a couple of 10gb databases backed up in that 10 hour space. But still, 7...

And my final jigsaw piece. We have data coming into 30 tables. We are then tidying it up and filtering in 20 other tables ready for population of text files....

I'm going to have a Primary and Secondary filegroup. Primary to contain the .mdf file and just be the db catalog. Secondary to contain all the objects. Is there any...

Top tips. Thanks for all your help!

We are talking full AND log backups off onto their own array?

Also the tempdb - I'll have 1 for each core. I'm going to put them in with data over...

GilaMonster (12/2/2008)

A separate one. Backups onto the same array as data is firstly an...

Good to have a verification! Thanks

I think I'm gonna go with a RAID 5 10 disk for the Data and Tempdb and Raid 1 2 disk for the logs. If the tempdb useage goes up...

I have a 10 disk RAID 5 setup. Would performance be better splitting to 2 arrays of 5 and logs and data split between the 2?

Ah you know SSIS is disappointing me somewhat. At first I thought it was great, but now I'm starting to get annoyed with it.

I was trying to import some migrated...

Good plan. So I'll have to make sure I have a related field in the Items table to connect on the Comments table in order to test. I guess I...

How does anyone feel of doing this kind of project withotu Enterprise edition and using Standard Edition instead?

Looking at cost cutting. Obviously I'd lose out the ability to use the...

Other questions -

I had 1.4 million records transfer at 100000 commands per second, yet it took 3 hours to get through?!?

I do replication from Server A to B to...

From that workstation do you have an IPC$ share to the server hosting the sql instance?