dbTalk Databases Forums  

Point in time recovery

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clients Point in time recovery

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Point in time recovery in the microsoft.public.sqlserver.clients forum.



Reply
Page 1 of 12 1 2 3 4 5 6 7 8 9 10 11 > Last »
 
Thread Tools Display Modes
  #1  
Old   
Smith
 
Posts: n/a

Default Point in time recovery - 01-24-2008 , 09:37 AM





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'


Reply With Quote
  #2  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM





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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #3  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #4  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #5  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #6  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #7  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #8  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #9  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
  #10  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Point in time recovery - 01-24-2008 , 01:21 PM


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 (AT) hotmail (DOT) co> wrote

Quote:
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'


Reply With Quote
Reply
Page 1 of 12 1 2 3 4 5 6 7 8 9 10 11 > Last »

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top