Setting up Log Shipping:
For Details : http://msdn.microsoft.com/en-us/library/ms188698.aspx
DB (Right Click)-> Task->Log Shipping->Select Server -> add path for the folder (must have write permission to the user assigned to the SQL services)
Configure the Frequency of Log Shipping.Click OK.
Restoring DB from no recovery (Log Shipping) mode to active mode:
Select database and run this command in Query browser:
RESTORE DATABASE CPSDB WITH RECOVERY
No comments:
Post a Comment