It's set to Simple

yep, we're doing a nightly replication. I do not do backups. The way we use this db, backups are not needed. This db houses data from devices...

LOL!!! Thanks, but I've tried to tell them that. I'm doing what I'm doing from Google, a book, and this Forum. They don't see a problem. ...

The main db is REPLICATION; replicated db is CHECKPOINT

Well, this rears it's ugly head again. My disk filled up (only 60Gb remember) because the db grew like crazy, so I dropped the database and restored from a...

Thanks. The indexing helped a little. I'm up to 1.6Gb free now. It looks like some major table cleanup is in order to really free up some...

I'm more of an Oracle person than SQL Server. How do I reindex?

Running sp_spaceused shows:

Reserved Data Index...

Thanks a bazillion for all the help!

Holy cr.....!!!! That worked like a charm! After doing all that, I ran the backup with truncate_only, then the dbcc_shrink and it went down to 104K!

I...

replication frequency is set to 1

Ok, bear with me here. We're not doing transactional replication. We're actually doing a nightly replication to another database, then extracting data from that database. BUT, just...

GilaMonster (7/9/2009)

---

That's saying that the transactional replication has never replicated a single transaction.

Is the replication on this server transactional?

If it is, are you seeing transactions replicating to the subscriber?

Is the...

Replicated Transaction Information:

Oldest distributed LSN : (0:0:0)

Oldest non-distributed LSN :...

reuse is at 6; description reads REPLICATION

Uh, sorry for the multiple posts, guys. I was getting an error that the post failed. Guess I should have checked to...