Anything more in the SQL error log?

From the looks of the error, either the backup is damaged or the original database is corrupt.

Can you get another backup to try?

Can you...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic980836-1550-1.aspx

Ok... This fix sounds a little odd, but it does work.

Create a transactional replication publication and publish one table (a small one)

Once the publication has been created, stop the log...

From the looks of that there's another half-setup publication.

Can you check with someone that would know whether or not this server is supposed to be involved in replication at all?

It means that replication (specifically transactional replication) is preventing the log space from been reused. Is this DB the publisher for a transactional replication publication?

What's the output of DBCC OPENTRAN

I...

If I had to guess, I'd say this was written and tested as an update trigger and either the delete added later or just never tested.

Query sys.databases. See what the log_reuse_wait_desc is for that database.

As for the target size, that's how small you want the log. Pick a value based on what you know of...

Ok, that's totally pointless.

With the -1 on both sides of the join it's as if they weren't there. Just like Algebra, if you add (or subtract) the same term from...

It means what it means in any mathematical expression. Subtract 1 from the value.

Can't tell the reason, but it's so that Product ID 2 from one table joins to Product...

If your goal is to rebuild indexes (remove fragmentation) just rebuild them. The rebuild has several algorithms it can use, including in most cases reading the old index to create...

'Not recommended' is an understatement. It's an extremely bad idea. Do that and you're risking the integrity of the DB. A single network dip could make the DB unavailable or...

What is package 2 doing that requires a Sch-M lock? Those are very restrictive locks

All queries require and take a Sch-S lock while they're running, to prevent the table from...

If you drop and recreate a clustered index, all nonclustered indexes are recreated twice. Once...

You could simply test it and prove it to yourself.

It's stated here: http://msdn.microsoft.com/en-us/library/ms189858.aspx (table half way down titled "Rebuilding an Index") and here: http://msdn.microsoft.com/en-us/library/ms188388%28SQL.90%29.aspx (under the section REBUILD [ WITH...

No.