Thanks GM, might just do that. Will let you know if I find anything.

Rich

In this case I probably could, but not easily if I go to production and experience the same thing.

Also, there are 2TB databases on here, and if I have to...

check out dezign, cheap and cheerful, but quick and easy.

I have also tried taking a full (fine) but still unable to take a log.

Its mirrored (sync + synched) - so I don't think we can change it's recovery model.

Yes, we are sure its the right db 🙂

DATABASEPROPERTY(name, 'IsTruncLog') = 0

you can write logshipping to work taking a 2000 database to a 2008 server.

What it limits you to is that the database must either be in norecovery or full recovery...

Did, but shut down the browser. Not sure if I disconnected it all first though. Seems all a bit odd to me.

No.

The other way you can roll your own, but not able to bring the databse up to standby - just no recovery or recovery.

2008 --> 2000 no chance.

Traces? A couple, but thats not it.

Sp_who2 - yeah, not a lot of help.

Our current thinking is it might be something to do with code completion.

So have you also got a nice bit of TSQL that will parse a directory of 1000s of excel sheets, open them all and save them as xml?

duda (12/21/2009)

---

I think you misunduerstood what the statement said but if...

just one small idea - grab the statistics IO. That will at least point at the really heavy tables - it might only be one of them. That...

Yeah had some similar issues ... ended up having to slap a bunch of index hints and join hints to resolve it. Updateusage all very well, but would knock...

Robert Frasca (12/10/2009)

---

Dropping and rebuilding a clustered index on a partition scheme may move data to other drives. The whole point of using a partition scheme...

This last answer would make perfect sense if it was phrased as 'May' instead of 'Will'.

Poorly worded question - especially given how many of the questions on here are irritatingly...