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 |
|
Sasikala
Starting Member
8 Posts |
 Posted - 2010-05-05 : 03:39:24
|
| Hi, I just followed the steps given in the link,http://omaralzabir.com/how_to_setup_sql_server_2005_transaction_log_ship_on_large_database_that_really_works/After all the steps, I could able to see the jobs (listed below )in secondary server.LSAlert_xx-43LSCopy_xxxx777_dDSLSRestore_xxxx777_dDSEven manually I started those jobs its resulting success.And in the primary server, in the shared folder, I could notice the .trn files are getting generated in the scheduled time. (for every 15 mins). But in the secondary server, in the shared folder there are no files, even when I manually starting the jobs. But am able to notice for the scheduled time, the jobs status is getting changed to Executing. But no .trn files are being copied to secondary. Why is this happening?How do I test? I just followed the steps given here.1. Inserted one row in a table in primary server.2. It has to get reflect in a secondary, ( need not reflect immediately, even after few mins also, inserted row is not available in the secondary server database).Is this a right way to test log shipping? If not please guide me. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sasikala
Starting Member
8 Posts |
Posted - 2010-05-05 : 05:35:42
|
| @tkizer, Thanks for your apt response.Its a fresh sql 2005 installation in both the primary and secondary. Database has only one table. And shared folder C:\TranLogs which is there in both the primary and secondary, and I have shared and gave permission full permission for everyone on this folder.And primary and secondary server are using only localsystem account (not domain account). Will this cause an issue? |
 |
|
|
Sasikala
Starting Member
8 Posts |
Posted - 2010-05-05 : 06:38:36
|
| @tkizer, I found the mistake I have done..While configuring Log shipping, in the network path I have given secondary server's path instead of primary server path.Now resolved it. Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
varadarajan
Starting Member
3 Posts |
Posted - 2010-06-28 : 04:18:23
|
| In Microsoft SQL Server, log shipping is the process of automating the backup of a database and transaction log files on a primary (production) server, and then restoring them onto a standby server, "What is Log Shipping". Retrieved on 2008-12-16.. ... |
|
|
|
|
|
|
|
|
Verifying Logshipping