SQL Server Administration
Thursday, May 26, 2016
SQL Server - Example of converting a large table into partitioned table
›
We had a 4Tb table that I converted to a partitioned table. The conversion took around 30 hours. Partitioning was laid out over 16 filegro...
Restore read-only filegroup
›
If you are missing a file in a read-only filegroup, you can offline that file (which will of course offline the whole filegroup), and contin...
Monday, August 26, 2013
Login failed for user 'Admin' with SQL 18456 State 5
›
A client receives error when running MS Access application and querying tables linked via ODBC. The error is: Connection failed: SQLState...
Thursday, June 21, 2012
Auditing in SQL Server 2005 - DDL triggers
›
If you need to implement server/DDL auditing in SQL 2005, you have to either use notifications or DDL triggers. This note is just about DDL ...
Saturday, May 5, 2012
To change the default backup folder on SQL cluster
›
Use SQL Mgmt Studio 2008. Right click on server/facets Change BackupDirectory to the new value Click OK
Tuesday, January 19, 2010
Restore Service Master Key
›
As a part of a DR test today, I recovered the encrypted database (log shipped) and restored the service master key from the production. When...
Tuesday, September 15, 2009
SQL Cluster: Resource dependencies
›
When installing a new clustered instance, you will probably want to assign multiple disk drives to a SQL instance. After you define all clus...
›
Home
View web version
