have you tried bulk logging? and make sure auto create and update statistics is off during the load. i've done replication snapshots of 300 million row tables and turning off...

powershell may give you some of the functionality as well

does MS even support backing up mirrored databases? the netbackup agents just use the MS API's when backing up the data

i've had it happen before, usually when most of a table's rows are affected

truncate the log manually with backup log

or reinitialize replication. i've had times when replication would not truncate the log after the commands were replicated and had to reinitialize some publications

first did you install the VMWare additions in your virtual machine?

second it could be a vmware issue. a lot of app makers had to release separate vmware aware versions of...

yes

on the publisher you run a query and you get an index scan

same query on a subscriber and you get an index seek. the publication had been recently reinitialized which...

we have a few of these going back to the old sql 2000 days. you need to use a hint

select cola, colb, colc from sometable with(index=indexname) where colb = whatever...

the new nehalem CPU's just came out and HP's 1U servers based on them support up to 144GB of RAM. Intel also said that instead of milking this for a...

if you do db mirroring, i think the sql native client and .net 2 and up supports it. as well as the microsoft jdbc drivers

we're an HP shop here and the generation 6 servers just came out or are about to come out this week

HP Proliant DL 360 G6 ( up to 144GB of...

i run 6 MP4 and going to 6.5 soon but haven't backed up mirrored db's

did you read the SQL agent manual that came with it? it's over 100 pages long...

we have DR servers at a remote location. most apps are java and use sql logins and we have a db/tables that we use to point apps to servers and...

never did boot from san myself, but i think it's pretty easy to set up

just set the HBA BIOS on to boot from and have the SAN admin provision the...

george sibbald (3/25/2009)

---

thanks for replying guys!

Mr(?) Noob, your way certainly gets round the upgrade problem.

Trouble is I am greedy and was really hoping to leverage SRDF to keep the failover...