depends on the code, if you look at the fix list since RTM there are a lot of things MS fixed in cursors and other issues when running some commands...

if you're going to overwrite it then just detach it and tell the GUI to kill all connections. i've found some apps like weblogic like to reconnect as soon as...

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