Hi, I've had log shipping running for some time now and every now and then the restore would fail. It seems to happen at around 9PM every other two...
Hi, I'm trying to configure a log shipping maintenance plan. At the very end of the wizard after pressing the "Finish" button I am prompted with an...
Thanks for the information. I've been reading through database mirroring configuration guides and they all specify to restore your database on the...
Hi, I'm trying to restore a backup on a sql server 2005 instance. I needed to restore this using the WITH NORECOVERY option (I'm in the process of...
I am having trouble getting the SQL Mail to function. I am running SQL Server 2000 on a Windows 2003 Server and I have Outlook 2000 installed and...
Karl, I've decided to just start the configuration from scratch, and configure a new domain account to run the log shipping jobs under. I added the...
Karl, Sorry yes the wizard creates a restore job and a restore alert job, both on the secondary. The restore job is the one that's failing now. The...
Karl,<br /><br />On the monitor server, I granted select and update priveleges to the domain account explicitly on the msdb log shipping primaries...
Karl, I did not configure the linked servers, can this be the cause? Is it required for log shipping? -C
Karl, I made the changes and the backup job is now running under the sa account. However, it is still not updating the msdb table on the secondary...
Karl, Just to clarify, after running the wizard it creates the following jobs on the secondary server: 1. Log Shipping Alert Job - Backup 2. Log...
looking at the windows event viewer and i get this error: Error: 14420, Severity: 16, State: 1 The log shipping source (SERVERNAME) has not backed...
Ok, well i made more user account changes. The restore job now works, but now the backup job fails. By default the Maintenance wizard creates 5 jobs...
I'm looking at the copy /restore history on the secondary server and i see failures for the restore. it is still trying to restore the first file and...
I changed the account to a domain account and now the copies are working fine but the restore jobs fail. The database on the secondary server is in...
I ran the query on the history table and for some reason, the only TRN file that's being listed is the first_file_000000000000.trn. It looks like the...
One detail that i forgot to add to my setup is that the source node is actually a 2 node SQL cluster, so it has a shared computer name. The other...
Satya, the SQLAgents are running on both servers. I believe i've narrowed down the problem to the SQL Job that performs the log restore on the...
Hello. I'm trying to change the service account used in my Sql Server Agent config. I'm using a domain user account that i created for this...
Karl, I will try configuring the log shipping using the SP's. let's see if that works. Thanks.
Separate names with a comma.
