Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 5
1. Which of the following is the instance of SQL Server that is your production server in log shipping ?
Correct Answer is : primary server
2. Point out the correct statement :
Correct Answer is : The restore job can be delayed until all users disconnect themselves
3. In which of the following modes, the database is read-only ?
Correct Answer is : Stand by
4. Point out the wrong statement :
Correct Answer is : Log Shipping is comparatively tougher than database mirroring for setup
5. Which of the following stored procedure is used to add a primary database on primary server ?
Correct Answer is : sp_add_log_shipping_primary_database
