Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yhchan2005
Starting Member
26 Posts |
 Posted - 2010-04-04 : 22:51:00
|
| Hi, i have restore the full backup into secondary server and manual run the script to configure the log shipping setting. i also have copy the trx backup from primary server into secondary server. when i try to run the schedule copy job, the job run successful but no file are copy. it is same to restore job. below is the process which i copy from hisotryMessage2010-04-03 11:42:26.84 Skipped log backup file. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402003001.trn'2010-04-03 11:42:26.90 Skipped log backup file. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402004501.trn'2010-04-03 11:42:27.00 Skipped log backup file. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402010000.trn'2010-04-03 11:42:27.12 Skipped log backup file. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402011500.trn'2010-04-03 11:42:27.73 Skipped log backup file. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402013000.trn'2010-04-03 11:42:27.82 Found first log backup file to restore. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402014500.trn'2010-04-03 11:42:27.82 The restore operation was successful. Secondary Database: 'LS_Account', Number of log backup files restored: 02010-04-03 11:42:27.84 Deleting old log backup files. Primary Database: 'Account'2010-04-03 11:42:27.85 The restore operation was successful. Secondary ID: '9cbeb51a-5dfe-4295-a68d-c347e3f73c95' i have other 2 database ( CRM, Payroll ) which is doing the same but only this database i face this problem. CRM and Payroll Db now is running without any problem. Please help ! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
yhchan2005
Starting Member
26 Posts |
Posted - 2010-04-05 : 03:38:47
|
| since the log shipping manage to find the file ( refer to the message 2010-04-03 11:42:27.82 Found first log backup file to restore. Secondary DB: 'LS_Account', File: 'd:\LogShipping\Account_20100402014500.trn' ), i don't think this is the paths problem for both primary and secondary servers.all the path are correct , if not the SQL server will return other message.refer to the SQL message, '2010-04-03 11:42:27.82 Found first log backup file to restore', but sql server did not perform the restore job and report successful ( 2010-04-03 11:42:27.82 The restore operation was successful ). but you can see there is no file to restore ( Number of log backup files restored: 0 )i have done the same setting for other 2 database but no such problem. please help. |
 |
|
|
yhchan2005
Starting Member
26 Posts |
Posted - 2010-04-05 : 22:05:47
|
| i have search on the internet and also found some user facing the same problem. notice that is sql return this kind of message 'Skipped log backup file. Secondary .....' then the log shipping will not work. unfortunately all the result i search on the internet there is no answer for it.please help ..... if the log shipping not wrok for this db, i might need to study how to configure this db using database mirroring.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Found first log backup file to restore but Number