#title Trouble Shooting
[[TableOfContents]]

==== Trouble Shooting ====
 * msg 1105 ..... 'sys.sysfiles1'.'sysfiles1' ..... --> 데이터 파일의 크기를 조금 늘려줘라.
 * [업그레이드 문제들]
 * [http://www.sqlservercentral.com/articles/Rebuilding+system+databases/87156/ Disaster Recovery: Rebuild system databases on SQL Server 2008 cluster]
 * [http://www.mssqltips.com/tip.asp?tip=2425 Rebuilding SQL Server on different hardware after a failure]
 * [http://www.sql-server-performance.com/2011/moving-sql-server-system-databases/ Moving SQL Server System Databases]
 * [서버 보드 교체 후]
 * [http://feedproxy.google.com/~r/PaulSRandal/~3/-54G-EsMAMs/post.aspx fixing metadata corruption without a backup]
 * [짜잘한 문제들]
 * [Master Database Restore]
 * [주어진 날짜보다 오래된 파일을 지우는 스크립트]
 * [http://www.sqlservercentral.com/articles/Collation/70685/ Changing Server Collation on SQL Server 2008]
 * attachment:TroubleShooting/TableDiffGui.zip
 * [Msg 7342]
 * [http://blogs.msdn.com/psssql/archive/2009/12/28/sql-2008-new-functionality-to-the-dm-os-ring-buffers-for-connectivity-troubleshooting.aspx SQL 2008 - New Functionality to the dm_os_ring_buffers for Connectivity Troubleshooting]
 * http://laigo.kr/category/SQL%20Server?page=1 --> 트러블 슈팅에 관련된 자료가 매우 잘 정리되어 있네요.
 * [http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2006-08/msg00307.html Decrypt]
 * [SQL Server 2005 설치된 상태에서 SQL Server 2008설치시 SSMS 에러관련]
 * [2^n코어 서버에 SQL Server 설치시 실패]
 * [http://support.microsoft.com/kb/316749 There may not be enough virtual memory when you have a large number of databases in SQL Server]
 * [http://www.sqlservercentral.com/Forums/Topic432976-360-1.aspx Memory pressure issues]
 * [http://span.com.my/forums/thread/551.aspx Decrypt SQL 2005 stored procedures, functions, views, and triggers]
 * [http://www.mssqltips.com/tip.asp?tip=1732 SQL Server Database Mail Cleanup Procedures]
 * [http://blogs.msdn.com/psssql/archive/2009/02/05/how-to-troubleshoot-leaked-sqlconnection-objects-net-2-0-part-1.aspx How to troubleshoot leaked SqlConnection objects (.NET 2.0) - Part 1]
 * [http://blogs.msdn.com/psssql/archive/2009/01/28/hot-it-works-sql-server-superlatch-ing-sub-latches.aspx Hot It Works: SQL Server SuperLatch'ing / Sub-latches]
 * [http://blogs.msdn.com/psssql/archive/2008/12/12/how-it-works-sql-trace-and-mars-connections.aspx How It Works: SQL Trace and MARS Connections]
 * [http://www.sql-server-performance.com/articles/dba/PeertoPeer_Replication_in_SQL_Server_2008_p1.aspx Peer-to-Peer Replication in SQL Server 2008]
 * [http://yseven95.egloos.com/1713374 Excel2007 파일 링크드서버 만들기]
 * [http://www.sqlservercentral.com/articles/Administration/64275/ Moving Large Table to Different File Group]
 * [분산 트랜잭션 오류]
 * [http://www.mssqltips.com/tip.asp?tip=1593 Granting View Definition Permission to a User or Role]
 * [http://a.tk.co.kr/270 윈도우 2003 서버 컴퓨터의 네트워크 링크가 분리되거나 끊어져 있을 경우]
 * [http://blog.naver.com/visualdb?Redirect=Log&logNo=50032143792 간헐적인 서버 연결 문제를 해결하자]
 * [복원후 SID 동기화]
 * [http://msdn.microsoft.com/ko-kr/library/ms188396.aspx 추적 플래그]
 * [A severe error occurred on the current command]
 * [http://www.mssqltips.com/tip.asp?tip=1559 Recover from a SQL Injection Attack on SQL Server]
 * [SSMS 등록된 서버를 내보내기/가져오기]
 * [로그파일을 삭제했을 경우]
 * [EventID 검색] 
 * [SSIS Int64변수처리 방법]
 * [SSIS 패키지 실행 작업시 패스워드 변경 처리]
 * [SSIS - 캐스트 사양에 대한 문자 값이 올바르지 않습니다]
 * [SSIS - Error Code 0x80004003]
 * [attachment:MicrosoftSQLServer/Advanced_SQL_Injection_thomas.pdf Advanced SQL Injection]
 * [http://go.microsoft.com/fwlink/?linkid=94001 Configuring the Windows Firewall to Allow SQL Server Access]
 * [http://support.microsoft.com/kb/956139 Visual Studio 2008 SP1이 SQL Server 2008 설치에 필요할 수 있다.]
 * [http://msdn.microsoft.com/en-us/vs2008/bb968856.aspx Uninstalling Visual Studio 2008] [attachment:vs2008_UninstallTool.zip UnInstall Tool Download]
 * [http://www.mssqltips.com/tip.asp?tip=1557 Configure MaxTokenSize for SQL Server Authentication]
 * [http://www.mssqltips.com/tip.asp?tip=1579 Switching Stored Procedure Execution Context in SQL Server using the REVERT clause]
 * [Msg 7390(QueryInterface returned 0x80004002)]
 * [Msg 916 WITH EXECUTE AS]