OK. Thank you for you help on this.

Gail, thanks for your replay.

What is the best way...

Thank you so much! this worked

Anyone with any idea on this?

Hi ColdCoffee, thanks for your response. The most start and end time a person will have it 4, so this should accommodate it.

Below is the error message I'm getting after running: Alter database DevTestdb set online

Msg 5173, Level 16, State 1, Line 2

One or more files do not match the primary file...

Yes, I'm sure that the file is there b/c I checked it to make sure it is there when I saw the error message that I posted. I believe...

yes, the file is there. This is a Dev DB, we have been doing some work on it that would take us a while to recreate. So what...

No, unfortunately, I don't have a backup file. Below is an error message that I can see in the log.

2011-10-10 15:00:50.03 spid27s FileMgr::StartLogFiles:...

Hi,

After running the query you provided, the output is: RECOVERY_PENDING.

I'm seeing the Shutdown status at the General page of the DB Property section. In the Database subsection, the Status...

Steve Jones - SSC Editor (8/5/2011)

---

I would say that if you feel comfortable answering questions about any of the topics listed on the MS site, you'll be fine. The questions...

I got you. Thank you to everyone who took the time and helped answer my question. Have a good one.

GilaMonster (8/22/2011)

---

Typically the more frequent the log backup the smaller the log file can be. But that requires no long-running transactions, no replication. If you're doing index rebuilds in full...

GilaMonster (8/22/2011)

---

I used to work with a DB that had...

Grant Fritchey (8/22/2011)

---

EjSQLme (8/22/2011)

---

So, is it normal for a t-log to be over 10GB even though you are doing a t-log backup? If so, is there a way to...