Make sure you're not connecting to alias.

I think so. Because if I do it myself, on next moment I get something like this:

Database Name Log Size (MB) ...

This is old story, but does anybody has ever resolved this?

As we know checkpoint on tempdb is issued when logfile gets filled by 70%.

I'm executing:

dbcc opentran

DBCC SQLPERF(logspace)

dbcc...

Ok, understand.

I have extended my view on several things 🙂

Must say Thank You for educational discussion.

Yep, I know it approximately +/- 15 minutes.

Actually, if I would see update statement, I could guess was it application or was it some of my teammates.

And returning...

Database is in full recovery mode since its creation (approximately 1 year).

I have daily full backups for last week + transaction log backups made each hour (also for a...

How to say ... currently I am trying to understand who or what has modified data in one of databases I am responsible for.

Since this has happened in past,...

GilaMonster (11/1/2011)

Yes, but this is solid investment. Can you recommend me some...

Hi,

I have same problem. Few instances of SQL 2000 are running on windows 2003 server.

On one of instance jobs were running normally for months. Then suddenly i saw that...

Hi there,

There is not standart way for moving msdb and model databases.

There is no real need to move master database. Master db will automatically updated while attaching your other...

Ok, i see ...

Anyway thanks guys for answers!!!

With best regards

Aivars

Hi there,

I had xp_cmdchell 'start bla bla bla' running well till last night. I spent hours figuring out what could be wrong. Exactly same situation as you told.

Doesn't really...