restore weirdness

Hello,
I just did a restore on a backup. The date for the last good restore I
have, according to
select database_name,backup_finish_date from msdb..backupset
order by backup_finish_date desc
(thanks Hari) is 6/7/2004.
The odd thing is that I'm still missing some tables from that backup. I
know for sure because I did a cut and paste of a query I was using and
posted it to this news group on 6/7/2004. Any ideas why my table, and
more importantly the data, is gone?
Hi,
Only way to check that is to analyze your transaction log file. For that you
can use the log explorer.
www.lumigent.com
Thanks
Hari
MCDBA
"Won Lee" <noemail@.nospam.com> wrote in message
news:#zjjH9qWEHA.500@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I just did a restore on a backup. The date for the last good restore I
> have, according to
> select database_name,backup_finish_date from msdb..backupset
> order by backup_finish_date desc
> (thanks Hari) is 6/7/2004.
> The odd thing is that I'm still missing some tables from that backup. I
> know for sure because I did a cut and paste of a query I was using and
> posted it to this news group on 6/7/2004. Any ideas why my table, and
> more importantly the data, is gone?
>
|||OK will do.

restore weirdness

Hello,
I just did a restore on a backup. The date for the last good restore I
have, according to
select database_name,backup_finish_date from msdb..backupset
order by backup_finish_date desc
(thanks Hari) is 6/7/2004.
The odd thing is that I'm still missing some tables from that backup. I
know for sure because I did a cut and paste of a query I was using and
posted it to this news group on 6/7/2004. Any ideas why my table, and
more importantly the data, is gone?Hi,
Only way to check that is to analyze your transaction log file. For that you
can use the log explorer.
www.lumigent.com
Thanks
Hari
MCDBA
"Won Lee" <noemail@.nospam.com> wrote in message
news:#zjjH9qWEHA.500@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I just did a restore on a backup. The date for the last good restore I
> have, according to
> select database_name,backup_finish_date from msdb..backupset
> order by backup_finish_date desc
> (thanks Hari) is 6/7/2004.
> The odd thing is that I'm still missing some tables from that backup. I
> know for sure because I did a cut and paste of a query I was using and
> posted it to this news group on 6/7/2004. Any ideas why my table, and
> more importantly the data, is gone?
>|||OK will do.

restore weirdness

Hello,
I just did a restore on a backup. The date for the last good restore I
have, according to
select database_name,backup_finish_date from msdb..backupset
order by backup_finish_date desc
(thanks Hari) is 6/7/2004.
The odd thing is that I'm still missing some tables from that backup. I
know for sure because I did a cut and paste of a query I was using and
posted it to this news group on 6/7/2004. Any ideas why my table, and
more importantly the data, is gone?Hi,
Only way to check that is to analyze your transaction log file. For that you
can use the log explorer.
www.lumigent.com
--
Thanks
Hari
MCDBA
"Won Lee" <noemail@.nospam.com> wrote in message
news:#zjjH9qWEHA.500@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I just did a restore on a backup. The date for the last good restore I
> have, according to
> select database_name,backup_finish_date from msdb..backupset
> order by backup_finish_date desc
> (thanks Hari) is 6/7/2004.
> The odd thing is that I'm still missing some tables from that backup. I
> know for sure because I did a cut and paste of a query I was using and
> posted it to this news group on 6/7/2004. Any ideas why my table, and
> more importantly the data, is gone?
>|||OK will do.sql

Restore transactions based on date range?

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted about two weeks worth of data from the database.
Since then the db's users have continued to update new data. So basically
the database is missing about two weeks worth of data from a couple of
months ago.
Is there a way to restore just those two weeks worth of data from the
transaction logs? From everything that I know and everything I've found,
you restore a database to a point in time, instead of picking out a date
range from a backup. But as I said, I'm not a DBA. So any advice would be
appreciated. Thanks!
Thanks for your help! I will pass this info along.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23qmgAZKRHHA.4252@.TK2MSFTNGP05.phx.gbl...
> If your customer has transaction log backups covering this period, you
> might be able to do this.
> Either restore (db and then log backups) up to just before that deletion,
> to a new database. Then transfer the desired data over to the production
> database (take relationships, constraints, triggers etc into
> considerations).
> Or, use some log reader tool and see if it can "mine" out counter
> statements for the delete process from your log backup. I've listed some
> such tools at http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Ripplinger" <miker@.entrerock.com> wrote in message
> news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>

Restore transactions based on date range?

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted about two weeks worth of data from the database.
Since then the db's users have continued to update new data. So basically
the database is missing about two weeks worth of data from a couple of
months ago.
Is there a way to restore just those two weeks worth of data from the
transaction logs? From everything that I know and everything I've found,
you restore a database to a point in time, instead of picking out a date
range from a backup. But as I said, I'm not a DBA. So any advice would be
appreciated. Thanks!If your customer has transaction log backups covering this period, you might
be able to do this.
Either restore (db and then log backups) up to just before that deletion, to
a new database. Then
transfer the desired data over to the production database (take relationship
s, constraints, triggers
etc into considerations).
Or, use some log reader tool and see if it can "mine" out counter statements
for the delete process
from your log backup. I've listed some such tools at http://www.karaszi.com/SQLSer
ver/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Ripplinger" <miker@.entrerock.com> wrote in message
news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
> Hi there -- I'm a developer who mostly uses SQL Server from that perspecti
ve, not a DBA, and I had
> a client ask me a question recently that I couldn't answer.
> My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted
> about two weeks worth of data from the database. Since then the db's users
have continued to
> update new data. So basically the database is missing about two weeks wor
th of data from a couple
> of months ago.
> Is there a way to restore just those two weeks worth of data from the tran
saction logs? From
> everything that I know and everything I've found, you restore a database t
o a point in time,
> instead of picking out a date range from a backup. But as I said, I'm not
a DBA. So any advice
> would be appreciated. Thanks!
>|||Thanks for your help! I will pass this info along.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23qmgAZKRHHA.4252@.TK2MSFTNGP05.phx.gbl...
> If your customer has transaction log backups covering this period, you
> might be able to do this.
> Either restore (db and then log backups) up to just before that deletion,
> to a new database. Then transfer the desired data over to the production
> database (take relationships, constraints, triggers etc into
> considerations).
> Or, use some log reader tool and see if it can "mine" out counter
> statements for the delete process from your log backup. I've listed some
> such tools at http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Ripplinger" <miker@.entrerock.com> wrote in message
> news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>sql

Restore transactions based on date range?

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly. A few weeks ago, he
accidentially deleted about two weeks worth of data from the database.
Since then the db's users have continued to update new data. So basically
the database is missing about two weeks worth of data from a couple of
months ago.
Is there a way to restore just those two weeks worth of data from the
transaction logs? From everything that I know and everything I've found,
you restore a database to a point in time, instead of picking out a date
range from a backup. But as I said, I'm not a DBA. So any advice would be
appreciated. Thanks!If your customer has transaction log backups covering this period, you might be able to do this.
Either restore (db and then log backups) up to just before that deletion, to a new database. Then
transfer the desired data over to the production database (take relationships, constraints, triggers
etc into considerations).
Or, use some log reader tool and see if it can "mine" out counter statements for the delete process
from your log backup. I've listed some such tools at http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Ripplinger" <miker@.entrerock.com> wrote in message
news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
> Hi there -- I'm a developer who mostly uses SQL Server from that perspective, not a DBA, and I had
> a client ask me a question recently that I couldn't answer.
> My client has a database that is updated constantly. A few weeks ago, he accidentially deleted
> about two weeks worth of data from the database. Since then the db's users have continued to
> update new data. So basically the database is missing about two weeks worth of data from a couple
> of months ago.
> Is there a way to restore just those two weeks worth of data from the transaction logs? From
> everything that I know and everything I've found, you restore a database to a point in time,
> instead of picking out a date range from a backup. But as I said, I'm not a DBA. So any advice
> would be appreciated. Thanks!
>|||Thanks for your help! I will pass this info along.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23qmgAZKRHHA.4252@.TK2MSFTNGP05.phx.gbl...
> If your customer has transaction log backups covering this period, you
> might be able to do this.
> Either restore (db and then log backups) up to just before that deletion,
> to a new database. Then transfer the desired data over to the production
> database (take relationships, constraints, triggers etc into
> considerations).
> Or, use some log reader tool and see if it can "mine" out counter
> statements for the delete process from your log backup. I've listed some
> such tools at http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike Ripplinger" <miker@.entrerock.com> wrote in message
> news:egaC1EKRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>> Hi there -- I'm a developer who mostly uses SQL Server from that
>> perspective, not a DBA, and I had a client ask me a question recently
>> that I couldn't answer.
>> My client has a database that is updated constantly. A few weeks ago, he
>> accidentially deleted about two weeks worth of data from the database.
>> Since then the db's users have continued to update new data. So
>> basically the database is missing about two weeks worth of data from a
>> couple of months ago.
>> Is there a way to restore just those two weeks worth of data from the
>> transaction logs? From everything that I know and everything I've found,
>> you restore a database to a point in time, instead of picking out a date
>> range from a backup. But as I said, I'm not a DBA. So any advice would
>> be appreciated. Thanks!
>