Could someone please help me how I can write a stored procedure to loop through the transaction file and return the File number.

for example:

If I'm using the following command to...

Once again thanx for your reply Greg.

You see that's my problem. The article is using INIT which is an ideal case but right now I have to do the same...

Thanx Greg,

Profiler is really a cool tool. check out the following link that I consulted for my standby server. Check out especially the restore log part which I'm using and...

Hi Greg,

Thanx for reply.

In continuation of my previous question. We have logs appending in the Transaction log file every 10 mins and I have to restore it on my standby...

Thanx SQLBill for your reply.

I'm using a standard version of the SQLServer 2000 and I in the middle of building my standby server. The method you mentioned to me, I...

The full backup starts at 10:30 PM every night executing following steps:

 * Perform Full Database Backup

  ?  Is this backup restored to the standby server?

 - Yes, but not always....

Thanx Paul.

I appreciate your help. Actually my log shipping is also based on this article as well. It's really interesting article after applying this article on my test servers I...

Hi Gary,

Let me briefly explain how my Production and Standyby server is setup in the following paragraph.Production Server is Linked with Standby Server thru Linked Server. 2 job...

Hi Gary,

Thanx for the reply.

Yes, a production server was backedup on Friday and restore on Saturday on the standby Server and the recovery model was full. The transaction logs were...

Hi Gary,

Thanx for the reply. Yes, I did what you have said. I am using the norecovery option and the standby option on the standby server with readonly.

Actually what happend...

Hi,

I am new to the SQL Server 2000 Administration and still learning and I can understand by seeing that message what you have been going through. Believe me, I had...