SQL Server Troubleshooting

How-to's

253817 - How to back up the last transaction log when the master and the database files are damaged in SQL Server
2019698 - How to schedule and automate backups of SQL Server databases in SQL Server Express Editions
2023538 - How to setup the custom log shipping which has a RESTORE VERIFY ONLY step

968872 - How do I open the firewall port for SQL Server on Windows Server 2008?
823938 - How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port
244980 - How to change the network IP addresses of SQL Server failover cluster instances
318605 - How SQL Server uses a certificate when the Force Protocol Encryption option is turned on

294209 - How to rebuild or move a MSDTC installation to be used with a SQL failover cluster
811889 - How to troubleshoot the "Cannot generate SSPI context" error message
295732 - How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed
237980 - How to convert an Access database to SQL Server
306397 - How to use Excel with SQL Server linked servers and distributed queries
315521 - How to troubleshoot SQL Server merge replication problems

198891 - How to run a DLL-based COM object outside the SQL Server process
231619 - How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
908018 - How to create a package template in SQL Server Business Intelligence Development Studio
912426 - How to detect the status of the SQL Server Express service or start the SQL Server Express service by using Visual Basic or Visual C#
945934 - How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008