GSquared (2/23/2009)

---

In recent fantasy, I really liked the Wheel of Time series, for about 3 books. Then it just got more and more boring as it went along. ...

Once the trace has finished, you can then import it into a table using fn_trace_gettable

How are you backing up? SQL native backup?

One series I'm really enjoying at the moment (not Sci-Fi) is the "Dresden files" by Jim Butcher. It's about a modern-day wizard living in Chicago. Butcher's other series "Codex Alarea"...

Please post table and index definitions as well.

There may be another process on another schedule that doesn't have the no_truncate, or maybe even...

Richard (2/23/2009)

---

The log file for this one database does grow huge, only when running a RE-INDEX. After I've cleared the log file down (by switching to "Simple" Recovery Model,...

No.

Ok, so let me see if I understand (ignoring details of virtual log files and statuses, which is just complicating the issue)

Your log file is constantly growing, despite running regular...

Look up...

Backing up across the network's not recommended for several reasons. Firstly the network speed may make your backups take longer. If there's a network glitch, the backup will fail and...

Depends on how much work SQL has to do in...

Or, using the 2005/2008 system views

SELECT COUNT(*)

FROM sys.procedures

What traceflags do you have enabled? That doesn't look like the output from 1222. Looks more like 1204 or 1205

Ok, three steps back...

What's the problem, why are you worried and what issues are these 'status 2' files causing?

How many log files do you have, how many database is there...