Thursday, March 29, 2012

can we get the deleted data back in SQL 2000

Hi im current using SQL 2000, data in three tables has got deleted on friday
,
in the mean time some data is also get added into that tables. after two day
s
only i recognize the some data are deleted. No i need the deleted data and
also the newly inserted data. what should i do?
--
Sakthivel
SQL Server Developer
INDIAHi
Only if you have BACKUP LOG file issued during this period
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on
> friday,
> in the mean time some data is also get added into that tables. after two
> days
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA|||http://www.karaszi.com/SQLServer/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on frid
ay,
> in the mean time some data is also get added into that tables. after two d
ays
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA|||Yes, I have the backlog file. Everyday midnight the fullbackup will be taken
and stored.
Sakthivel
SQL Server Developer
INDIA
"Uri Dimant" wrote:

> Hi
> Only if you have BACKUP LOG file issued during this period
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>
>|||Is the database in simple or full recovery model?
Are you doing regular transaction log backups?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:9037CCBC-8515-44C0-9B51-64DA9B27F27C@.microsoft.com...[vbcol=seagreen]
> Yes, I have the backlog file. Everyday midnight the fullbackup will be tak
en
> and stored.
>
> --
> Sakthivel
> SQL Server Developer
> INDIA
>
> "Uri Dimant" wrote:
>|||Thanks Tibor Karaszi and Uri
Sakthivel
SQL Server Developer
INDIA
"Tibor Karaszi" wrote:

> http://www.karaszi.com/SQLServer/in...veral_times.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>
>

No comments:

Post a Comment