| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-08-17 : 13:54:42
|
| Hi all,How can i check that if the logshipping is working perfectly fine.I test on test database. all the job worked successful but i don't see the changes in the database nor i seee th file which sould be copied to destination location.How to check it please@@@Thanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 14:05:58
|
| Log shipping monitor will show this.Tara Kizer |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-17 : 14:09:23
|
| but on the destinatin server log does not show that log restored!!!Why!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 14:11:32
|
| Because you've got some issue that needs to be resolved. Log shipping monitor will show whether or not the file copied over and whether or not it restored. So which part isn't working?Using 3 exclamation points in all of your posts does not increase the urgency for us. Please be respectful when you post.Tara Kizer |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-17 : 14:21:14
|
| sorry for that.my log gets back up every hour!! and it's been almost two log backup already but havent' seen any copied file at detination folder or nor the restore of the log on the database.on th monitor it show that last back up file first_file_0000000000.trn11.11.38 AMon last file coppied:first_file_0000000000.trn11.11.38 AMand last file loadedfirst_file_0000000000.trn11.11.38 AM |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-17 : 14:23:31
|
| also on the threshold:out of sync treshold 120 Minutesload delay : 0 MinFile retetion period: 1 Dayhistory retencion period : 2 Days:does all things look right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 14:26:49
|
| No it does not look right. The backups aren't even working. This is how I know:last back up file first_file_0000000000.trnIf the backups were working correctly, you'd see a real file name instead of first_file...Tara Kizer |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-17 : 14:29:50
|
| but the on the source the log backup is working just fine. how can i check the source file where i copy from? in log shipping monitor? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 14:36:37
|
| According to log shipping, the log backup is not working fine. Are you sure you don't have some other process that is backing up the transaction log for you? With log shipping, log shipping can be the only one backing up the transaction log.Tara Kizer |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-17 : 15:07:59
|
| i created new log shipping but it still shows me the same first_file_00000000.trn!!! would you please explaing me why? i am getting more and more confuse!!thanks |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-18 : 13:06:56
|
| Hi tara,would you please make me understand that why i am getting this error please!!My full back up on primary is running once a day at 3 AM and log runs every hour.i am getting error in server log is:The log shipping source (local).test has not backed up for 325 minutes..on the log shipping monitor the source bacup failure alert is set to 180 min (is it correct).the copy and restore job works fine and also log gets restore on the db.what could be wrong?please helpThanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-18 : 13:22:56
|
| If you make a change in the database at the source, does the change get copied to the destination database? Just because your jobs are showing as successful doesn't mean that it is actually working. You have to verify it with data. If everything is working, then the problem is with the monitor only.Tara Kizer |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-18 : 14:06:47
|
| does it make difference if i have not made complete db back up in maintenane plan? because i have different plan that runs for all the user db full back up?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-18 : 14:10:09
|
| You do not need to run the full backup using the log shipping maintenance plan.Tara Kizer |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-18 : 15:21:14
|
| the changes does get transfer but still getting error for The log shipping source (local).test has not backed up for 1424 minutes.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-18 : 15:26:59
|
| You've got something wrong with your log shipping monitor then.Tara Kizer |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-21 : 09:00:20
|
| i tried creating again and everything worked fine but still on the monitor the last back up the first one shows first_file_000000.trn!! Why would it show like that?please help!!! |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-08-21 : 10:26:16
|
| blind shot...mssql2000 patched to sp4?--------------------keeping it simple... |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-21 : 10:55:20
|
| yes!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-21 : 12:50:47
|
| Delete log shipping. Then delete all rows from any tables that start with log_shipping in the msdb database. Do this on both the primary and secondary server as well as the log shipping monitor server. All rows from all of these tables should be deleted. Then re-setup log shipping. Tara Kizer |
|
|
|
browser30
Starting Member
13 Posts |
Posted - 2007-09-27 : 22:26:58
|
| Hi,I"m having a somewhat similar problem.I"ve set up log shipping indicating that the target database already exists. However, the transaction files are not being copied to the destination server. However, the copying and restoring jobs run successfully.There is no issue with backing up the transaction log directly to the folder in question on the target server using the name Windows account.Any insight would be greatly appreciated. |
|
|
|
Next Page
|
how to check if Log shipping is successfull or not