SQL Server creates a self signed certificate when starting to be able to respond to encrypted connection attemps. You can see it in the ERRORLOG file:

"2008-12-11 12:12:09.68 Server ...

Hi ,

The KB articles are referring to SQL 2000. Please post the full build number for your SQL Server 2005.

It is difficult to answer without a close look at...

You can use sys.dm_os_performance_counters from your distributor to access the perfmon counters for replication:

\SQLServer:Replication Logreader\Logreader:Delivery Latency ...

Hi,

Be carefull if you plan to use SSMS to run sp_addarticle and you need to have your NC indexes on the subscribers, because it will by default skip the NC...

Hi Gail,

I totally agree. I don't consider CONTINUE_AFTER_ERROR as a *must* option either. I just wanted to mention that in some circumstances you may need to have the backup finish...

Hi Beppe,

You'll find plenty of examples on the web. The idea is to run BACKUP DATABASE with the CHECKSUM option. The CONTINUE_AFTER_ERROR option will force SQL Server to carry...

...and the SSMS reports won't work either if the database is still in 80 mode.

David B.

2) My favourite is Kim Tripp's WP: http://msdn2.microsoft.com/en-us/library/ms345146.aspx

Ron Talmage has made an update for SQL 2008 here http://msdn.microsoft.com/en-us/library/dd578580.aspx

David B.

Hi,

How did you upgrade the databases ? Was it an in-place upgrade, or did you restore backups / attached db files ? Did you use SQL Upgrade Advisor ?

You may...

Hi beppe,

Indeed the maintenance plan offers a 'Verify Backup Integrity' check box in the backup section. The command runs a restore verifyonly but the backup hasn't been generated with checksums....

Hi,

top of my head, what you should focus on:

STORAGE:

- page and row compression.

- filestream storage.

- sparse columns.

- spatial datatypes.

- Partition-level lock escalation.

MAINTENANCE:

- backup compression.

HA:

- compressed log streams through DBM.

- Automatic...

George

In the context of DR/relocation, I absolutely agree. I felt like the original question was only a matter of curiosity on 'how-to' manage system databases relocation, rather than building...

Hi,

Just a quick word,

In SQL 2008 resource is not requested to be under the same location as master anymore. The resource files are stored in the binaries directory, you don't...

Lee,

here is an explanation in PSS blog about 665 errors and dbcc checkdb snapshot errors:

http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx

It matches your scenario of running CHECKDB with high IO activity. You should schedule...

Hi Lee,

DBCC CHECKDB uses an internal database snapshot to get a consistent view of the data and not report false errors anymore. You won't be able to see what it...