A reliable academic resource for high school and college students.
Essay database with free papers will provide you with original and creative ideas.
Essay database with free papers will provide you with original and creative ideas.
Log Shipping
Date Submitted: 03/07/2003 21:20:58
Length: 4 pages (984 words)
Views: 71395
The concept of standby servers is not a new one. It has been around a long time and been used by many DBAs. Traditionally, using a standby server for failover has involved manually making database and log backups on the production server and then restoring them to the standby server on a regular basis. This way, should the production server fail, then users could access the standby server instead, and downtime and data loss would …
Is this essay helpful? Join now to read this particular paper
and access over 480,000 just like it!
…roles so that log shipping goes the other direction. Instead, SQL Server 2000 supplies four stored procedures to assist in the failover process and relies on a new built-in Data Transformation Services (DTS) feature to transfer logins from the source to the destination server. You can use the stored procedures to resolve the logins on the former standby server, to change the servers' roles, and even to change which server the Log Shipping Monitor resides on.
Need a unique paper?
