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…
Showing posts from November, 2011
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…