Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures

SQL Server/Windows Routine Procedures

Several procedures must be performed frequently to keep the CSE databases running efficiently. Unless the system administrator ID/password has been changed, use sa as the login ID and a blank password to start the SQL Server Management Studio:

• Cleaning up your database
• Updating database statistics
• Backing up your database
• Backing up transaction logs
• Adjusting database size
• Truncating transaction logs
• Stopping SQL Server
• Starting SQL Server
• Common SQL Server system procedures