Re: Rewritten UPDATE query - is it the same?



On 29 Apr, 15:42, Tom van Stiphout <no.spam.tom7...@xxxxxxx> wrote:
On Tue, 29 Apr 2008 03:25:51 -0700 (PDT), teddysn...@xxxxxxxxxxx
wrote:

Backup the database (or take the backup from last night). Restore it
as <dbname>_Beta and perform your tests there. You can spare the 5
minutes.
My gut feeling: both are interchangeable.

-Tom.

Thanks. Will do.

Edward

.



Relevant Pages

  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)