80 likes | 328 Views
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.
E N D
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 • 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.
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
Windows Tasks Non replication related jobs become Windows Tasks. Can Be Found: Start -> Control Panel -> Scheduled Tasks
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
Other Tools 2 1 • Launch SQL Server Management Studio • Launch SQL Server Profiler