even if it is replicated you can still change...

to delete a trace you have to stop and close it

exec sp_trace_setstatus traceid, 0 --stop trace

exec sp_trace_setstatus traceid, 2 --close trace

all of this is no good until you know the...

SQL2005 must be licenced per virtual processor. However if you licence the physical sockets on the host box you are covered for unlimited virtual cpus\VM's on that host

check for more...

Leo (11/17/2008)

---

Hi Perry,

I have similar situation at work. My IT guys build a Test Server for SQL 2005 and he said that we have 2 400GB x RAID 5 drives...

it's also worth noting that under bulk logged and simple recovery models the following are minimally logged

ALTER INDEX

CREATE INDEX

we always set our db recovery models to bulk logged, rebuild indexes...

i have books from Wrox which are fantastic

Professional SQL 2005 programming

Professional SQL2005 performance tuning

I recommend these. They go into a lot of detail about the database engine (datafiles, logfiles,...

it could be the backup is larger than the free space available!!

database mirroring provides a warm standy copy of the database.

Log shipping works differently, log files are shipped to a remote database and applied. The database has 1 of 2 states,...

RAID 5 is ideal for...

untrue as far as i am concerned. I had a call open recently with MS...

i have been tempted for some time 😉

why not just run the scripts through a sql job, no need to use SSIS

although you ran a log backup there could be an active transaction occupying the end of the log file

run

dbcc opentran to check for open transactions

then

dbcc loginfo

a status of 2...

personally you cant beat VMWare VI3. There are a number of players in this arena now, but remember VMWare have a 10 year +...

you need to research and decide on a virtualisation product and storage method first then build from there as the hypervisor and storage mediums form the foundation of the systems