Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Sun, 10 Aug 2008 01:04:00 -0700,    group: microsoft.public.sqlserver.server        back       


Problem with log shipping, secondary database does not update   
Hi SQL Server MVPs,

I have set up log shipping in sql server 2000. I have a problem, secondary 
database does not update. It has not changed since the complete backup. The 
maintenance plan created 3 jobs on primary server and secondary server. The 
histories of these jobs are successful. Transaction log backup has created 
backup files every 15 minutes. But these files do not copy to the secondary 
server. I have created share for the folder in which the source database's 
transaction logs will reside and the Windows account that each server's SQL 
Agent is using has read and change permissions on this folder.

Thanks
-- 
Vakili
date: Sun, 10 Aug 2008 01:04:00 -0700   author:   Vakili

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us