OK, I tried it. Mine *does* generate the STOPAT command. The only question is whether or not I have SP2 installed. I do *not* think I have it, but I'm not sure where to find whether I do or not. Any ideas?
~~Bonnie
>>What gets generated and what did you expect to get generated? Is there an error when you run it?
>>
>>~~Bonnie
>>
>Hi Bonnie,
>
>I appreciate you're replying on my message.
>
>The STOPAT option is not generated, which I expected to be generated using Point-in-time restoration. I don't recall at the moment the exact line that was generated and I'm on a different PC right now.
>
>Do you have SP2 installed? Can you please run a quick test for me if this is not too much to ask and you're on the computer with SQL Server 2005 at the moment? Please create a test database, create a table, insert some records, back it up, back the transaction log (set expiration for both backups to something different than 0), then select getdate() to remember the time, then delete some records, backup the log again and then restore database to the time before deleting the records and script the command. What would you get?
>
>Thanks a lot again in advance.