😉

it can backup log during database backup but cannot truncate the log file

have you tried contacting Quest support?

are you using T-SQL or SSMS gui?

naushi (11/21/2008)

---

i tried to restore a database A (with 2 data files and 3 log files ) to Database B with 1 data files and 1 log file and it...

couldnt agree more, does your SAN admin understand the...

is it absolutely necessary to have dev databases that large??

at most a small subset of data is usually good enough, 400GB is a bit OTT.

i always prefer a fresh install, that way the original server remains available

i'm still trying to decipher the last post :blink:

if using database mirroring be sure the network connection is stable otherwise you could end up with unwanted fail overs. Log shipping would be more preferrable, but it depends on...

what columns does the table have?

which column(s) were you thinking of creating the index on?

are you running server side trace or through profiler?

what events are you capturing?

try this link

http://sqlug.be/blogs/wesleyb/archive/2007/07/25/memtoleave-issue-in-sql-server-2000-x86.aspx

sounds like a job for SSIS!

replication doesnt replicate all objects, for instance if one of your tables has no PK it will not replicate. Then you have all the stored...

how much cash do you have basically, clustering will cost more to implement and administer