Explanation:Make sure your database is in full or bulk-logged recovery model. 5. Point out the wrong statement :
A. The principal database in a mirroring session can also act as the primary database in a log shipping
B. Log Shipping is comparatively tougher than database mirroring for setup
C. The database log shipping setup needs to be initiated from the principal server using the SQL Server Management Studio wizard
D. A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shipped
Answer:A
Explanation:Make sure your database is in full or bulk-logged recovery model. 5. Point out the wrong statement :
A. The principal database in a mirroring session can also act as the primary database in a log shipping B. Log Shipping is comparatively tougher than database mirroring for setup C. The database log shipping setup needs to be initiated from the principal server using the SQL Server Management Studio wizard D. A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shipped
Explanation:Log Shipping is a pretty simple process to setup. 6. Which of the following stored procedure is used to add a primary database on primary server ?