Script to apply pending logs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » Script to apply pending logs

Script to apply pending logs

Rate Topic

Display Mode

Topic Options

Author

Message

gk-411903

Posted Monday, March 17, 2008 6:29 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 6:18 PM
Points: 169, Visits: 418

I am looking at the backupset view/table ; My aim is to regenerate the SQL statements to apply the archivelogs at the STANDBY; The name column is showing blank. How do i find the name of the file; Order by first_lsn gets me the required order.

TIA

Post #470584

Sponge-592981

Posted Thursday, March 20, 2008 4:32 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 11:41 AM
Points: 45, Visits: 173

TIA.

1) I think you are posting an oracle database question in sql server world :P
2) This is not a fundemental question..:)

Reshadit@hotmail.com

Post #472627

gk-411903

Posted Thursday, March 20, 2008 4:47 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 6:18 PM
Points: 169, Visits: 418

It does not matter if this is Oracle or Sybase related. The question is how to get the answer.

Post #472628

Michael Valentine Jones

Posted Thursday, March 20, 2008 10:22 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 2,944, Visits: 10,500

If you want help with a query, it would help if you posted the actual code of the query.

Post #472670

Sponge-592981

Posted Sunday, March 23, 2008 12:19 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 11:41 AM
Points: 45, Visits: 173

GK,

With all do respect it definetly matters. It matters on how successful you will be in searching for your answer. What I meant by my post was if you have oracle or sybase the chance of you getting the answer you need is not probable.

Again,

1) You are on a SQL Server microsoft realated which does the same things but differently.
2) This is not a fundamental question, it would be a slight more difficult question.

To help you get your answer that you are looking for(Which I presume since you have not recieved a posting) I would first and upmost find an oracle or sybase forum (Perhaps even a diverse forum for all databases. This will increase your chances of finding your 'answer'.

Thanks,

ReshadIT@hotmail.com

Post #473287

« Prev Topic | Next Topic »

Permissions