Thursday, December 10, 2009

Seven Tips for SQL Server Production DBAs

  1. 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
  2. Use ALTER USER WITH LOGIN to repair orphaned logins.
  3. Use sp_addsrvrolemember to give yourself the sysadmin role.
  4. Use the PortQryUI utility to troubleshoot connectivity problems.
  5. Use a different strategy when running DBCC CHECKDB against large databases.
  6. Use the Import Package Option to deploy SQL Server Integration Services (SSIS) packages to the msdb database.
  7. Use SQL Server 2008's local server groups and Central Management Servers to query multiple servers at the same time.
URL: Seven Tips for SQL Server Production DBAs

Latest Posts