1 / 8

SQL 2005

SQL 2005. SQL Server Management Studio. In SQL 2005, a new tool called SQL Server Management Studio replaces both Query Analyzer and Enterprise Manager in SQL 2000. SQL Server Management Studio. 5. 1. 2. 3. 6. 4. SQL Server Management Studio.

vian
Télécharger la présentation

SQL 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL 2005

  2. SQL Server Management Studio In SQL 2005, a new tool called SQL Server Management Studio replaces both Query Analyzer and Enterprise Manager in SQL 2000.

  3. SQL Server Management Studio 5 1 2 3 6 4

  4. SQL Server Management Studio • The node for UnityDb. From here, you can browse to all Unity tables, views, functions and stored procedures. • Right click to get to the Replication Monitor. • Select this node to see the list of jobs on the “Object Explorer Details” tab. Note that only replication related jobs are here if failover is setup. Non replication related jobs become Windows Tasks.

  5. SQL Server Management Studio • You can use this tool to look at the job history of replication related SQL jobs. • SQL query window • SQL result window

  6. Windows Tasks Non replication related jobs become Windows Tasks. Can Be Found: Start -> Control Panel -> Scheduled Tasks

  7. Scheduled Tasks • SQL Nightly Backup Jobrun:osql –E –I C:\CommServer\Localize\DefaultConfiguration\ENU\SqlNightlyBackupJob.sqlrunas:<domain/DirSvcAccount name>Time : Daily 2am • SQL Weekly Backup Jobrun:osql -E -i C:\CommServer\Localize\DefaultConfiguration\ENU\SqlWeeklyBackupJob.sqlrunas:<domain/DirSvcAccount name>Time : Sunday 3am • Check SQL Configurationrun:osql -E -i C:\CommServer\Localize\DefaultConfiguration\ENU\CheckSqlConfiguration.sqlrunas:<domain/DirSvcAccount name>Time : Daily 11:30 PM • Cisco PCA Clean uprun:cmd /c "C:\CommServer\cscoserv\bin\clean_jar_cache.batrunas:NTAuthority/SystemTime : Daily 1:31 AM * - Install Drive was c:\commserver in this example

  8. Other Tools 2 1 • Launch SQL Server Management Studio • Launch SQL Server Profiler

More Related