GilaMonster (11/6/2010)

---

p.s. How come there are no backups? Are you absolutely sure there are no backups at all? Query the msdb backup tables (sysbackupset and related) to see if maybe...

I think the default trace might have it, if it's not overwritten yet.

" ... As you can see, we were able to gather some pretty significant information about who created...

I read this part:

"... These packages have been made available for general testing purposes only and should be deployed in a non-production [environment]. ..."

SP3 is the most recent version for SQL.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

The wording makes it appear that Windows is SP2, not SQL

Or a troll

This should fix the error:

Select top 100 * from table_with_one_billion_rows

Or get a bigger monitor 🙂

........... After your FULL backup completes

Differentials are cumulative, so you only restore the most recent diff. T-Logs are additive, so you restore them all, or up to the desired point in time, since the...

I don't know of a way after the fact unless you had a trace running ....

I run transaction log backups every 15 min, so I look at when the...

More detail would be helpful.

Do they get an error trying to access the data ?

Were they able to get data before, but now they can't ?

What application or method are...

I clean up the text files in the same maint plan that does the backup ...

Sounds like you have an uncommitted transaction(s).

http://support.microsoft.com/kb/317375

What is the result of DBCC OPENTRAN ?

If you search "The transaction log for database 'tempdb' is full" you will find plenty to read...

I did ...

harita (11/1/2010)

---

yes i did change it to 0 , but can you explain me whats going on here, we run this report every moth and never had this problem but...

Craig Farrell (11/1/2010)

---

homebrew01 (11/1/2010)

---

I suspect that what was meant was that less experienced SQL DBA's, or people thrust into the role of DBA are the "weekend warriors" trying to make...