I have tried it both ways and still a failure. Option "Ship the transaction logs to other SQL Servers (log shipping)" not appearing 13. do you have secondary database existing already or trying to establish for the first time ? bobanjayan Yak Posting Veteran India 67 Posts Posted-06/17/2004: 06:58:54 Yes, I was using,sa with same password in Master & Standby.and Administrator also have the same password.And moreover it is have a peek at this web-site
But I am facing one more > problem > After creating the maintenance plan, the backup database > is created inside the secondary server(with read only > status).But after that if Reports will be generated and stored in directory: D:\DB\Report\ SHIP LOGS TOPRINTER.LSDBExpecting your help!Thanks Thursday, October 08, 2009 5:36 AM Reply | Quote Answers 0 Sign in to vote Thank you But sometimes a variable does not appear by default in the options sheet for the painter. Monitor server: An entry for the primary server in table msdb.dbo.log_shipping_primaries. http://www.sqlservercentral.com/Forums/Topic240144-5-1.aspx
Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact I can access this folder from any PC in the netwok(//Master_Server/Backup). You cannot post new polls. I have created a user in windows andassign the Administrative power and that user name and passward given the 'Startup Service Account' section in the security tab.
Kelly SQL Server MVP > Hi, > Thank You for the help. You cannot post replies to polls. Some sections are always present by default, but others are created only when you specify different preferences. You cannot delete your own posts.
I managed to create the maintenance plan using domain user id of SQL server agent. Format of INI files The InfoMaker initialization file uses the Windows INI file format. You cannot post IFCode. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36381 You cannot vote within polls.
Please help Thanks Paulson Technical Consultant AIT Singapore -- Direct access to this group with http://web2news.com http://web2news.com/?microsoft.public.sqlserver.server Top 1. Please help Thanks Paulson Technical Consultant AIT Singapore -- Direct access to this group with http://web2news.com http://web2news.com/?microsoft.public.sqlserver.server 2. You cannot edit other posts. Recommended RAM for RH6.2 w/Oracle Enterprise 8i ?? 3.
You cannot edit HTML code. Kell » Sat, 21 Jun 2003 21:24:34 If the backups are not getting written to the proper directory then change them. You cannot delete your own events. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate?
Both Primary and secondary server is registered inside SQL Enterprise manager. Check This Out Top "Unable to copy initialization file to secondary server" while log shipping by Andrew J. TO OVERCOME THE PROBLEM:You may have to run the following stored procedures to clean up log shipping entries and allow the wizard to be re-run: sp_delete_log_shipping_primary (http://msdn.microsoft.com/en-us/library/aa259637(SQL.80).aspx) : To delete the You cannot rate topics.
InfoMaker records the path in the Windows registry. But by clicking the finish button it fails and given the errorODBC SQLState: 4200 ( Error 14261: The specified primary_server_name.Primary_database_name('(') already esits.my maintenance plan details given belowDATABASESMyDB SERVERS(local) COMPLETE BACKUPOccurs every It has three types of elements: Section names, which are enclosed in square brackets Keywords, which are the names of preference settings Values, which are numeric or text strings, assigned as Source Post #240441 « Prev Topic | Next Topic » Permissions You cannot post new topics.
You cannot post events. We've restricted the ability to create new threads on these forums. To record your initialization path: Select Tools>System Options from the menu bar.
Beginning SQL 5. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database All rights reserved. We've got lots of great SQL Server experts to answer whatever question you can come up with.
Log shipping: Copy job does not release .TRN file after copying it I have a log shipping load job fails with this entry in the SQL log: BackupDiskFile::OpenMedia: Backup device 'C:\Program shares for the database and logs are reestablished with security access by the same domain account that is a dbo for the database.does the log shipped database need to be setup Thanks, Leks Thursday, October 08, 2009 9:58 AM Reply | Quote 0 Sign in to vote Thank you Thursday, October 08, 2009 10:25 AM Reply | Quote 0 Sign in to have a peek here You may download attachments.
You cannot send emails. So easiest thing is to go for sql authentication.Thanks, Leks Proposed as answer by Xiao-Min Tan – MSFTModerator Tuesday, October 13, 2009 8:37 AM Marked as answer by Xiao-Min Tan – View this document as PDF Unable to copy the Lotus Notes client initialization file (NOTES.INI) This article applies to: AppDetectivePRO 8.4 Issue: Error: Unable to copy the Lotus Notes client How InfoMaker finds the initialization file InfoMaker looks in the Windows Registry for a path to the file, and then looks for the file in the directory where InfoMaker is installed.
Kelly >SQL Server MVP >> Hi, >> I am trying to setup logshipping in SQL server 2000 and >> stuck with the >> following error "Unable to copy initialization file to But that is also failed . Our new SQL Server Forums are live! Operating system error = 32(The process cannot access the file because it is being used by another process.).
If the initialization file is missing If InfoMaker does not find the initialization file when it starts up, it recreates it. This command is working in the same machine(primary server)I think it is because of the permission error..If you have any idea about this problem please give me a reply.Looking forward to Log Ship backup corrupted, unable to backup the DB anymore 1 post • Page:1 of 1 All times are UTC Board index Spam Report logo-symantec-dark-source Loading Your Community Experience Symantec Connect Please Help ...
Come on over! You cannot delete your own topics. Looking forward to hear from youTHanks and regards,Saji Thursday, October 08, 2009 10:59 AM Reply | Quote 0 Sign in to vote have you seen this link for this error http://support.microsoft.com/default.aspx/kb/811890Are It sounds like the account for sql agent >is running under is not a domain account or does not have sufficient access >to the other machine. >-- >Andrew J.
you can perform log shipping in dev edition. InfoMaker 12.5.2 > Users Guide > Working with InfoMaker > How your InfoMaker environment is managed Chapter 1: Working with InfoMaker About the initialization file The initialization file is a