Right.

I only have Access 2007, but...

Hi,

By clicking on the External Data tab in Access, you can either create a copy of the SQL Server table in your access database, or you can create a linked...

Too funny Derrick.... yup, a shrinking post is like the...

Hi Rick,

I've seen some issues with incorrect space usage reporting in SQL Server 2000 (which you say you are using).

You might want to use the updateusage argument with sp_spaceused, or...

GilaMonster (10/29/2010)

---

SwayneBell (10/29/2010)

---

So, if we find that we have too many VLF's (e.g. due to a log that has grown many times by small increments), do we have options to...

Thank you!

In fact, I had looked at DBCC LOGINFO, but until I read your link I wasn't aware of how to interpret...

george sibbald (10/15/2010)

---

mssqlsystemresource - There is no SQL command to back up this database, so just once for every SQL upgrade, take SQL down and make a flat file...

Thank you Gail.

That's very helpful.

PS: I think I'll just add "thank you Gail" to my signature in this forum and save the typing.

Thank you for the responses and script.

Much appreciated,

Steve

GilaMonster (10/15/2010)

TempDB can't be backed up. You'll get an error if you try.

Msg 3147, Level 16, State 3, Line 1

Backup and restore operations are not allowed on database tempdb.

The master...

george sibbald (10/15/2010)

---

SwayneBell (10/15/2010)

---

George,

I'm getting the sense that the exposure from data loss in one of these databases is inconvenient, but not fatal? (i.e. some new jobs may fail, new...

George,

This is very helpful and I will proceed based on your input.

I think, because we are making very pervasive changes to our backup routines, I'll err on the side of...

GilaMonster (10/13/2010)

---

SwayneBell (10/13/2010)

---

The unfortunate close second is in the 'Data Corruption' threads - the number of posts with a corrupt production database and no backup is stunning - I'm sure...

My hat is off to you Gail, you are incredibly patient

You go through this whole series of explanations every day with new people, even debunking the inevitable “truncate the log...

Point-in-time recovery is not required. The business is okay with 24 exposure. Which honestly is the disconnect with the decision to use full recovery model. So when the diff backups...