• palotaiarpad (2/16/2011)


    It's a good question, but maybe next time you should take a notice: using Server 2005 and above.

    The question is valid equally for SQL Server 2000/2005/2008. I'm not sure if the exact STOPAT syntax was available in SQL Server 7 (point-in-time recovery was, so I assume yes?), but in any case there was no BULK_LOGGED recovery model as such. Instead there was the db option "select into/bulkcopy" which could be set to "ON/TRUE" to achieve the same effect. However, since the question refered to bulk-logged and recovery models it could be assumed that it related to SQL 2000 and later.

    Cheers,

    Duncan