Will a restore work for getting the backup into a readable active log?

~BOT

You don't need a third party tool.

use DBNAME

SELECT * FROM ::fn_dblog(null, null)

GO

With some poking around in 'pre-emergency' time you should be able to figure out

what you're looking at. ...

Andrew Gothard (1/5/2009)

---

Just to check one thing. When you say tempdb, do you mean "the system database used by SQLServer called tempdb" - or "a user database which will...

I just wrote one and have a new one coming out on the 12th or 13th. Keep your eyes peeled.

http://www.sqlservercentral.com/articles/career+growth/64632/%5B/url%5D

~BOT

That's irritating, isn't it.

I think for data storage purposes I use varchar(128) when I need to store sysname data.

Typecases between varchar(128) and sysname are implicit, so it doesnt' matter how...

george sibbald (1/3/2009)

---

Hmmm, page\sec way too high. This value can be thrown out though by processes such as backing up large files to tape, as these really thrash the memory,...

Or you could just rebuild them 🙂

Rebuilding is fine with page level locking disabled... it's just reorg that fails.

Rebuild online if possible.

~BOT

Thanks Barry!

I like it!

CASE replaces an if/then/else block and the ; terminator issues the commands. Clever.

My one complaint is that it might be difficult to write in good error...

Jeff Moden (1/2/2009)

---

SQLBOT (1/2/2009)

---

RBarryYoung (1/2/2009)

---

SQLBOT (1/2/2009)

---

Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it...

RBarryYoung (1/2/2009)

---

SQLBOT (1/2/2009)

---

Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it is possible.

It probably...

Nice Article,

I don't think that useful and necessary cursors are that rare.

Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's...

That's worth looking into, but the error happens /any/ time the dbcc's run and /only/ on master and /only/ on 3 out of 8 instances.

These Instances are on a server...

Remember too that SQL 2005 has metadata visibility "issues".

so if you don't own it you won't see it in the results in stored proc or fuction output

They'll have to pry the cursor from my cold, dead fingers...:w00t:

~BOT

I've seen this before.

sp_helprotect might show you some things.

Remember that DENY statements take precedence over grants.