- Use Forfiles utility (forfiles.exe) to delete old database backup files:
forfiles /p "e:\sqlbackup" /m "*.bak" /c "cmd /c del /Q @path" /d -2
- Use ALTER USER WITH LOGIN to repair orphaned logins.
- Use sp_addsrvrolemember to give yourself the sysadmin role.
- Use the PortQryUI utility to troubleshoot connectivity problems.
- Use a different strategy when running DBCC CHECKDB against large databases.
- Use the Import Package Option to deploy SQL Server Integration Services (SSIS) packages to the msdb database.
- Use SQL Server 2008's local server groups and Central Management Servers to query multiple servers at the same time.
HSN
hardware, software, network, game, database, unix, linux, redhat, microsoft, oracle, sun, java, j2ee, IBM, market, lifestyle ......
Thursday, December 10, 2009
Seven Tips for SQL Server Production DBAs
Subscribe to:
Posts (Atom)
Latest Posts
Blog Archive
-
▼
2009
(36)
-
▼
December
(36)
- Seven Tips for SQL Server Production DBAs
- HSN: MSSQL DBA daily jobs
- MSSQL DBA daily jobs
- HSN: Oracle DBA checklist
- Oracle DBA checklist
- HSN: 股票买卖操盘策略
- 股票买卖操盘策略
- HSN: Replication Configuration Between MSSQL 2005 ...
- HSN: VMs vs. Multiple SQL Server Instances
- HSN: Steps to set up oracle database RAC
- HSN: 基金买卖操盘方式
- HSN: 我的投资策略
- HSN: 如何从MACD指标研判股市走势?
- HSN: Dollar Cost Averaging
- HSN: 4 ways to be a millionaire
- HSN: All Money Sense
- HSN: Linux User Guide (2)
- HSN: Linux User Guide (1)
- HSN: Oracle Dictionary - DBA Views
- HSN: Oracle Dictionary - All Views
- HSN: Oracle Dictionary - Dynamic Views
- HSN: Oracle Dictionary - User Views
- HSN: SCJP 310-035 Sample Questions (1)
- HSN: Sun Certified Web Component Developer 310-081...
- HSN: J2EE Patterns
- HSN: Catalog of design patterns
- HSN: Configure MSSQL to use more than 2GB RAM
- HSN: MCTS 07-431 Sample Questions (1)
- HSN: MSSQL 2005 Knowledge Base 1
- HSN: Using LogMiner to analyze transaction history
- HSN: How to query server and client environment in...
- HSN: OCA references
- HSN: OCP References
- HSN: 1Z0-043 sample questions (1)
- HSN: 1Z0-042 sample questions (1)
- HSN: Steps to set up oracle database RAC
-
▼
December
(36)