I could be wrong, but I believe a clustered index is for how the data is stored, not retrieved. From what I've read the optimizer can take various ways of...

TempDb is used for several things in SQL Server. DBCC CHECKDBs, temp tables, row versioning, etc. If TempDb keeps getting to 2GB in size I would say that is a...

Copy-only full backups are the same concept as copy-only log backups. It does not write an archive bit so the log chain is not interrupted with the backup. It is...

It is not so much that the agent is not supported, the functionality is not actually present in the express editions.

Features Supported by the Editions of SQL Server 2008 R2

If...

Just came across this:

SQL Server Management Studio 2012 errors when doing restore to SQL 2008

Take a look at the workaround and see if that works for you.

Did you actually read any of the articles that talk about remoivng log shipping? All stored procedures for log shipping rely on database NAME, not ID. DB ID would not...

There is something else you can try. Can you go to the directory that the SQL binaries are installed (normally something like c:\program files\microsoft sql server\MSSQL10_50.<instancename>\MSSQL), go to the log...

Correct. There are many pieces to log shipping. You need to specify the log shipping server and database in log shipping that you are removing. There are links to the...

Do you have jobs/maintenance plans that run on a scheduled basis? Is it possible that another full backup kicked off between the time that you performed your full backup and...

Run sp_who2, look in the blkby column and find the process that is at the start of a block chain. Identify its SPID. Then you can run "kill <SPID>" to...

Yep, restore from backup.

How are you planning on enforcing the encryption for the connection? I ask because if you are using FIPS I would test it out because you can break application functionality...

Interesting. When you restore the full backup are you leaving the db in recovery?

I would restore using T-SQL. You only have 3 backups to restore (2 if you don't want...

How to: Remove Log Shipping (Transact-SQL)

Then go through the full and differential restores again in SSMS and before executing the restores script out the actions and post the scripts here so we can see what...