BIDS

Mohit (3/16/2009)

---

Urg .. Not a long rant but why do people have in their mind SQL Server backup is not online?

Everyone at my work seems to think that to, I...

we usually stick with the 3 years NBD, but i'm buying some servers now and going to try the 5 year NBD. Almost every time HP's has had a new...

most of our thresholds for rebuilds are 5% or 10% fragmentation just so that if it fails one or two days it's no big deal. i've noticed i still get...

pretty sure i read in BOL that index rebuilds, create index, etc are fully logged even if the recovery model is simple

mostly depends on your hardware and I/O

on the old SCSI drives it took a long time. i have an archive db on the new SATA drives with one of the...

i've done bulk inserts which is the same way a snapshot replication does it and the log file can grow even if it's simple recovery model. i think it creates...

we only do index rebuilds, this way we don't have to run update statistics

the speed of the tapes depends on the tech being used. new LTO-4 tapes are around 1TB per hour per drive.

for exchange/file backups we run Seagate Evault Infostage. it's similar to Netbackup or Commvault but the data is on disk. it runs on top of any x86 server and you...

for #1 it's normal. you have to remove the table from any publications that it's in and then you can delete it

for #2 our SOX auditors would laugh at us...

is the recovery mode of the subscriber full? make sure it's simple

we did this last year

backup

detach databases from current sql instance

uninstall sql on old cluster

install sql on new cluster

attach databases

create logins, jobs, replication, etc

we've been using Netbackup Enterprise for almost a decade and it's great. one place to schedule everything, you can control which backups go on which tapes, easy to search the...

studying for 70-431 and there is a question about creating a database master key. sounds like something that will work for you