sysprocesses is a server-level view, it's not database-specific. It returns all of the sessions connected to the server and, as one of the columns, has the id of the database...

Query sysprocesses and see what connection is connected to that database.

Tom Breit (6/25/2009)

---

I guess I was not explicit. The Backup Exec backup job was NOT called by the Maintenance Plan, BE runs on a different server, and does a SQL...

Lynn Pettis (6/25/2009)

---

GilaMonster (6/25/2009)

---

Gaby Abed (6/25/2009)

---

I can only imagine the discussions that Paul and his wife, Kimberly Tripp[/url], have when they catch each other's mistakes, rare as they may be....

Gaby Abed (6/25/2009)

---

I can only imagine the discussions that Paul and his wife, Kimberly Tripp[/url], have when they catch each other's mistakes, rare as they may be. Eventually will...

Not that I'm aware. Maybe ask Steve to do a query against the DB.

I've asked that the username be included for exactly this reason. Personally, unless the email comes from...

Ah, that's what I was suspecting. BackupExec has been noted in the past to cause exactly this problem - error saying that no full backup available, even though one's been...

nscott (6/25/2009)

---

P.S. I went into the properties of the main DB in question and set the tlog to unrestricted. But when I went back in to view the properties,...

Tom Breit (6/25/2009)

---

No, I haven't tried running the command in t-sql.

In fact, looking at the error message in the history says 'cannot perform a differential backup... because a current...

To do that you need a calendar table, one that has all the months in it. Then join the tables together (left join) and group.

Edit: And you're probably going to...

Yeah, I know. It's...

Take DTA's recommendations with a large pinch of salt. It tends to suggest wide indexes and way too many of them. I've seen it before now suggest 3 indexes and...

Tim Walker (6/25/2009)

---

Hey Gail, do you know what would happen if one index was narrower but fragmented so actually occupied more pages than a wider one? Which would be chosen...

Jus (6/25/2009)

---

No. my question was......If you take the differential back up second time after the full backup, will it (second differential backup file) be holding the data changed after the...

Indeed, and SA's through to the quarter finals which is nearly as astonishing. Our local team's been playing so poorly lately.