Re: Point in time recovery

Restore will not let you get an inconsistent views of a database. But that I mean that it won't allow for a restore where some objects are from one point in time and other objects are from another point in time. You can restore up to 10:05 into a new database name and move the desired data (TEST2) from there into the production database.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Smith" <naissani@xxxxxxxxxx> wrote in message news:3C7DF62C-9595-4750-A6B4-6D7F695B4D85@xxxxxxxxxxxxxxxx
Hi Professionals,

Following are my queries and I want to recover the table (Test2) with data and recover all the test1 data. I would appreciate if you can let me know the commands.


use eZSale
go
create table TEST1 (ID INT, NAME VARCHAR(50))
create table TEST2(ID INT, NAME VARCHAR(50))

--Time:10:01
BACKUP DATABASE eZSale to disk = 'C:\TEMP\test_FullDb.BAK'

--Time:10:02
INSERT INTO TEST1 SELECT 1, 'AFTER FULL BACKUP'
INSERT INTO TEST2 SELECT 1, 'AFTER FULL BACKUP'

--Time:10:03
BACKUP LOG eZsale to disk = 'c:\Temp\test_Logbk.BAK'

--Time: 10:04
INSERT INTO TEST1 SELECT 2, 'AFTER LOG BACKUP'
INSERT INTO TEST2 SELECT 2, 'AFTER LOG BACKUP'
INSERT INTO TEST2 SELECT 3, 'AFTER LOG BACKUP..SECOND ENTRY'

--Time: 10:05
DROP TABLE TEST2

--Time: 10:06
BACKUP DATABASE eZSale to disk = 'C:\TEMP\test_DiffDb.BAK' with differential

--Time: 10:07
INSERT INTO TEST1 SELECT 4, 'AFTER DIFFERNTIAL BACKUP'
INSERT INTO TEST1 SELECT 5, 'AFTER DIFFERNTIAL BACKUP..SECOND ENTRY'

.

Relevant Pages

  • Re: Point in time recovery
    ... RESTORE DATABASE AdventureWorks ... just do them with norecovery like you did the full backup. ... RESTORE LOG AdventureWorks FROM AdventureWorksBackups with NORECOVERY ... create table TEST1 ...
    (microsoft.public.sqlserver.clients)
  • Point in time recovery
    ... Following are my queries and I want to recover the table (Test2) with data and recover all the test1 data. ... 'AFTER FULL BACKUP' ...
    (microsoft.public.sqlserver.clients)
  • Re: Point in time recovery
    ... You can restore up to 10:05 into a new database name and move the desired data (TEST2) from there into the production database. ... Following are my queries and I want to recover the table with data and recover all the test1 data. ... 'AFTER FULL BACKUP' ...
    (microsoft.public.sqlserver.clients)
  • Re: Query Help Please
    ... FullName VARCHARNOT NULL ... INSERT INTO #Test1 VALUES ... INSERT INTO #Test2 VALUES ... > We have a database with a Surname and Forename column. ...
    (microsoft.public.sqlserver.programming)
  • 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)
Loading