Then you need to design a backup strategy so that, no matter what, you can...

Why don 't you just use sp_attach_rebuild_log? No need for all the other work.

p.s. Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post...

*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!

There's no single perfect backup strategy. It depends on the size of the DB, the amount of data that's allowed to be lost in the case of a disaster, the...

If the DB is in simple recovery then the transaction log will be getting automatically truncated every minute or so, and there will be no way to get info older...

I've had probation periods at two of the companies that I've worked for. They have to be very carefully set up in the contracts (labour laws are quite strict here...

It means that either the log or the database file has been damaged in some way. If you can attach with just the mdf, great, but please run a CheckDB...

Couple possible reasons.

- It would have...

shannonjk (8/18/2009)

---

There are no transactions after this until the data warehouse is loaded again the next day. So there is no need for a point in time recovery. My mindset...

I'm going to consult an expert on this one. Please be patient...

Does restarting the instance fix that?

If not, can you please run the following and post any output that it returns

DBCC CHECKDB ('Model') WITH NO_INFOMSGS, ALL_ERRORMSGS

First thing we need to see is the SQL error logs. There should be a message in there indicating why MSDB is suspect. Hopefully, it'll be something easy to resolve.

If...

It's good practice if that is the largest the transaction log will ever need to be. 1GB is pretty small for a transaction log, unless it's a relatively small and/or...

russ (8/18/2009)

---

The second part of the question is does the back up work for both

Simple and Full recovery models?

Simple : BACKUP DATABASE TO DISK = ''

Full :...

russ (8/18/2009)

---

2) most of our databases are in simple recovery mode, which means the log file can not be backed up, however over time the log file has grown large.

3)...