Being dealt with here - http://www.sqlservercentral.com/Forums/Topic408782-357-3.aspx

Please don't cross-post on multiple threads - thanks.

How large is your database, and how large is the largest table you're reindexing?

I'm not sure I understand your question. Are you asking whether full backups are possible in SIMPLE recovery mode? Yes - but you cannot take log backups too so your...

There is no way to do what you want except with an intermediate step similar to you have. It's a commonly requested feature. The problem is that the database size...

Only by using the undocumented log scanning function fn_dblog, and only if the log record you're interested in hasn't been truncated from the log. It's complicated but do-able.

If you want...

See here for the descriptions of the new features.

Good topic for a contraversial blog post. See BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it and SQL Server 2008: What's been removed in...

Kimberly also just wrote a blog post last week about her preferred architecture for partitioning a table into two tables - one with read-only partitions and one with a single...

You can use profiler to do this - checkout Data File Auto Grow in Books Online.

Going from 2000 to 2005 we rewrote some of the backup internals around multi-threaded scheduling and buffer management (backup uses its own schedulers inside SQL Server) - this may account...

I did a blog post about this a few days ago - Search Engine Q&A #7: Restoring from a backup file containing multiple database backups

One thing to be aware of - the TRUNCATE_ONLY and NO_LOG options have been removed in SQL Server 2008. We tried to remove them in 2005 too but they go...

TheSQLGuru (10/11/2007)

---

Doing a full backup will NOT allow log file to shrink. You must in some way backup the log to allow space reuse. This is a VERY...

Nipa also sent me email - I gave her some more links:

- A video recording of my Secrets of Fast Detection and Recovery from Database Corruptions talk from TechEd this...

ok - cool. No offense - just that I've seen a bunch of posts on various forums who are advertizing their product without giving any extra advice. And yes, on...