Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Adi Pear
Starting Member
2 Posts |
 Posted - 2011-03-28 : 08:23:15
|
| Helloi'm working with SQL and want to use the Log Shipping ability.First question is what kind's of versions working with this technique 2005/8 Enterprise Edition, regular maby other Editions?second question is how after the primary server fail the backup server load the lost data back to the primary server?In other words how dose the reverse process executed?Thank youAdi Pear. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-28 : 10:43:31
|
| Log shipping works with all versions of SQL Server from 2005 onward. Express editions do not have the SQL Agent component enabled, which is required for scheduling.Log shipping failover is a manual process. The details are listed in Books Online, and also includes the failback process. Keep in mind that while you can fail over from 2005 to 2008, you cannot fail back to 2005 once the database or log has been backed up under 2008. |
 |
|
|
Adi Pear
Starting Member
2 Posts |
Posted - 2011-03-28 : 11:16:41
|
| can you send me the books or a link to download them?I want to work on "No Recovery Mode" and for example my primary server fail and now I want to active the database on the secoundery server.What should I do ?Thanks in advance |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-28 : 11:27:50
|
| Books Online: http://msdn.microsoft.com/en-us/library/ms130214.aspxThere's also a copy installed with SQL Server, under the Start Menu program group for SQL Server.I don't know what you mean by "no recovery mode". Regarding the failover procedure, as I said earlier it's detailed in Books Online. |
|
|
|
|
|
|
Log Shipping-SQL 2005/8