【单选题】You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 co...
A.
Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
B.
Add SQL2 as remote server.
C.
Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
D.
Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
【单选题】Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need toreconfigure transa...
A.
On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.
B.
On SQL1, change the schedule type for the transaction log backup to Start automatically when SQL Server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
C.
On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
D.
On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.
【单选题】曲轴扭转疲劳裂纹主要是由于零件()引起的。
【单选题】Associez chaque réponse à un des cinq sens. 1. Toutes ces feuilles jaunes, oranges, c'est magnifique ! Et puis la lumière est superbe, elle est dorée à cette période de l'année !
【单选题】曲轴应力集中主要是由于曲轴________引起的
【多选题】社会主义荣辱观的提出有积极的意义,体现在( )。
【单选题】TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure trans...
A.
On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.
B.
On SQL1,change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.
C.
On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.
D.
On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.
【多选题】社会主义荣辱观的提出有积极的意义,体现在( )。