Showing posts from November, 2011

Moving tempdb to a new location

The following example moves tempdb from its current location on the disk to another disk location. Because tempdb is re-created each time the MSSQLSERVER service is started, you do not have to physic…

SQL Server Service Accounts

Service account for Files and folders Access MSSQLServer Instid\MSSQL\ba…

What is Database Mirroring

In the proposed database mirroring solution there will be two groups of active-passive windows clusters deployed at each location (PRIMARY SITE and Secondary Site). The Primary Site will be the prima…
Subscribe Our Newsletter