TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ZwePyae PhyoOo
NA
1
733
SQL server log shipping error when copying secondary server
Sep 1 2016 7:02 AM
Dear friends,
I have a problem with log shipping of sql server 2005 to sql server 2008
in one computer and not using two computers. Primary Server(2005) shared folder is 'C:\Primary' and I allowed this folder to Full Access of Administrator. Secondary Server(2008) folder is 'C:\Secondary' and I also allowed Full Access to it but not shared. Then I created database on Primary Server with full recovery mode and restore it on Secondary Server.
After it, I setting up log shipping and start job on Server Agent. The problem is started. Backup process of primary server is success but coping it were failed. I don't know why? Please reply me, if you have free time.
I also want to know does schedule backup of log shipping backup the whole database or only new transaction?
Thank you very much to you all for reading my problem. :)
Reply
Answers (
2
)
Optimize redundant sproc calls
how to select top 3 OR top 5 from Column