Have you checked the script library here at SQL Server Central. If you can't find exactly what you are after, you are pretty likely to get something fairly close

e.g....

Your understanding is close. The txn undo file contains modifications that were not committed on the source database but were in progress when the txn log was backed up...

I am not exactly sure what it is that you can't find. So here is a few things to check.

Maintenance plans are normally created and changed using SQL Server 2005...

You certainly can - just install client tools

The difference between a covering index and an index using INCLUDES is that in a covering index all columns in the index are included in the b-tree. This makes...

I am inclined towards mirroring. It is so much easier to manage and if you do wish to have automatic failover, that is just so easy to get up...

Are you able to get to the log file for the database ?

If you can, you can backup the log and get the last 25 minutes of transactions with...

You can't easily select a different folder for each database. Yeah, it would be nice to have more flexibility especially when it comes to storing partitions on different drives...

Just a quick note on the use of indexes and LIKE searches. Yes, prior to SQL Server 2005, a condition such as LIKE '%Xyz%' would not have benefited from...

If you are needing a high availability solution, replication is not really a very good choice.

Have a look at SQL Server clustering and also at Log Shipping. These are...

Have you considered using full text catalogs for your meta data columns ?

To get the table definitions and data to the replica database, you will need to create a subscription. In Enterprise Manager, you should see a node called "Replication"....

The code supplied is for SQL 2005. Instead of sys.sysprocesses, try dbo.sysprocesses

I think Jeff is saying that if the logreader agent fails, the transaction log will grow (which is true because transactions must remain in the trans log until they have...

I have customers who regularly have multi-gigabyte transaction log files and they don't experience problems. I also have not noticed any posts from people having problems.

Are you able to...