Script for Multiple Restore in one shot SQL server

Windows update can't check for updates because the service is not running

Patching does have its own issues, hard to predict

 This time I was doing windows updates

Control panel --> System and security --> Windows update -->check for updates

The image file is valid , but is for a machine type other than the current machine

While patching SQL server 2005 SP1 to SP2, we face below error

Error: The image file is valid , but is for a machine type other than the current machine

This error clearly states that patch file is good, the issue  is with my machines

SQL Server System Databases

 Many people does know about system databases but no one remembers detailed version and get confuse in tricky questions. So I have put this in points

Master Database :

1. 
   

Script To Reindex Database In Sql Server

A file activation error occurred. The physical file name may be incorrect.

Copy all files from one drive to other via SQL Server Script xp_cmdshell

Copy all files from one drive to other via SQL Server Script using Robocopy

SQL Server ACID Properties

Difference Between Mutex vs Semaphore

SQL Server Full Job History

EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’

Replication Doubts:

The list of trace flags available for SQL Server

How To Increase Performance Of Slow Insert In SQL Server

Restore Latest Backup in SQL Server

How do list files ,date and size inside a folder using SQL Server

How to delete Transaction log file in SQL server : Demo

How To Read Default Trace In Sql Server

SQL Script To Get Available And Free Disk Space From SQL Server